DealQUE - Social Bargain Hunting and daily deal aggregator. Great bargains at DealQUE.com | Browsing Daily Deals / Sporting Goods Deals

Tramdock Hestra Full Leather C-Zone Glove - $41.99 (Reg. $10...

The chick sitting next to you on the lift profusely claps her hands together in order to warm up her fingertips, but not you, since you're wearing the oh-so-toasty Hestra Full Leather C-Zone...

DeMarini 375: DXFZM Fastpitch

Great deal on the DeMarini 375: DXFZM Fastpitch at $44.99 each. DeMarini introduced the 375 specifically to maximize performance with 375 lb. compression softballs. T...

Burton Day Hiker Pack Firecracker Red - Kids, Youth

Price: $19.95 (57% Off) Retail Price: $45.95

The Daily Steal O'Brien Skyla Wakeboard - Womens 2009 - $98....

O'Brien Skyla Wakeboard - Womens 2009 - The O'Brien Skyla was specifically designed with the input of pro wake boarder Dallas Friday. The Skyla is one of the first boards on the market desi...

Rockwell RK5101K SoniCrafter 37 Piece Professional Kit

The Rockwell RK5101K SoniCrafter 37Piece Variable Speed Complete Professional Kit comes with the SoniCrafter one of the most versatile power tools ever invented plus different accessories ...

Rockwell RK5101K SoniCrafter 37 Piece Professional Kit

The Rockwell RK5101K SoniCrafter 37Piece Variable Speed Complete Professional Kit comes with the SoniCrafter one of the most versatile power tools ever invented plus different accessories ...

Rockwell RK5101K SoniCrafter 37 Piece Professional Kit

The Rockwell RK5101K SoniCrafter 37Piece Variable Speed Complete Professional Kit comes with the SoniCrafter one of the most versatile power tools ever invented plus different accessories ...

(default) 73 queries took 1411 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
2	SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-03 08:09:00" LIMIT 2	0	0	0
3	SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Daily Deals' AND category='Sporting Goods'	1	1	0
4	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'	1	1	21
5	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'	1	1	124
6	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'	1	1	0
7	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'	1	1	0
8	( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description, uid as ID, link, rating as ratingOrdered, que_count as rating, user_deals.img, user_deals.img_size, monsters.img as logo, username as name, 0 as shipping, additional_info as additional_info, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description, merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, img_size, logo, name, shipping, '' as additional_info, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,10	7	7	623
9	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
10	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520120;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
11	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
12	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "73" AND comments.start_date = "2010-09-03 08:09:12") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "73" AND user_comments.start_date = "2010-09-03 08:09:12" )	2	2	0
13	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "73" AND date = "2010-09-03 08:09:12" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
14	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
15	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
16	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
17	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "65" AND comments.start_date = "2010-09-03 03:09:05") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "65" AND user_comments.start_date = "2010-09-03 03:09:05" )	2	2	0
18	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "65" AND date = "2010-09-03 03:09:05" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
19	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
20	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
21	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
22	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "104" AND comments.start_date = "2010-09-02 13:09:32") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "104" AND user_comments.start_date = "2010-09-02 13:09:32" )	2	2	0
23	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "104" AND date = "2010-09-02 13:09:32" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
26	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
27	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "46" AND comments.start_date = "2010-07-19 19:07:47") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "46" AND user_comments.start_date = "2010-07-19 19:07:47" )	2	2	0
28	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "46" AND date = "2010-07-19 19:07:47" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
32	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "114" AND comments.start_date = "2010-07-19 19:07:16") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "114" AND user_comments.start_date = "2010-07-19 19:07:16" )	2	2	0
33	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "114" AND date = "2010-07-19 19:07:16" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
34	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
35	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
36	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
37	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "103" AND comments.start_date = "2010-07-19 19:07:13") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "103" AND user_comments.start_date = "2010-07-19 19:07:13" )	2	2	0
38	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "103" AND date = "2010-07-19 19:07:13" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
39	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
40	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
41	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
42	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "70" AND comments.start_date = "2010-07-19 19:07:01") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "70" AND user_comments.start_date = "2010-07-19 19:07:01" )	2	2	0
43	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "70" AND date = "2010-07-19 19:07:01" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
44	( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5	5	5	636
45	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
46	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
47	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
48	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "73" AND comments.start_date = "2010-09-03 08:09:12") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "73" AND user_comments.start_date = "2010-09-03 08:09:12" )	2	2	0
49	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
50	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
51	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
52	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "65" AND comments.start_date = "2010-09-03 03:09:05") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "65" AND user_comments.start_date = "2010-09-03 03:09:05" )	2	2	0
53	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
54	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
55	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
56	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "104" AND comments.start_date = "2010-09-02 13:09:32") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "104" AND user_comments.start_date = "2010-09-02 13:09:32" )	2	2	0
57	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
58	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
59	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
60	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "46" AND comments.start_date = "2010-07-19 19:07:47") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "46" AND user_comments.start_date = "2010-07-19 19:07:47" )	2	2	0
61	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
62	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
63	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
64	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "114" AND comments.start_date = "2010-07-19 19:07:16") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "114" AND user_comments.start_date = "2010-07-19 19:07:16" )	2	2	0
65	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
66	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
67	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
68	SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent	18	18	0
69	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
70	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
71	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
72	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
73	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0

(default) 73 queries took 1411 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-03 08:09:00" LIMIT 2

SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Daily Deals' AND category='Sporting Goods'

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'

124

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y'

( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description, uid as ID, link, rating as ratingOrdered, que_count as rating, user_deals.img, user_deals.img_size, monsters.img as logo, username as name, 0 as shipping, additional_info as additional_info, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description, merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, img_size, logo, name, shipping, '' as additional_info, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,10

623

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520120;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "73" AND comments.start_date = "2010-09-03 08:09:12") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "73" AND user_comments.start_date = "2010-09-03 08:09:12" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "73" AND date = "2010-09-03 08:09:12" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520121;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520121 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "65" AND comments.start_date = "2010-09-03 03:09:05") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "65" AND user_comments.start_date = "2010-09-03 03:09:05" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "65" AND date = "2010-09-03 03:09:05" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "104" AND comments.start_date = "2010-09-02 13:09:32") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "104" AND user_comments.start_date = "2010-09-02 13:09:32" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "104" AND date = "2010-09-02 13:09:32" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "46" AND comments.start_date = "2010-07-19 19:07:47") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "46" AND user_comments.start_date = "2010-07-19 19:07:47" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "46" AND date = "2010-07-19 19:07:47" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "114" AND comments.start_date = "2010-07-19 19:07:16") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "114" AND user_comments.start_date = "2010-07-19 19:07:16" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "114" AND date = "2010-07-19 19:07:16" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "103" AND comments.start_date = "2010-07-19 19:07:13") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "103" AND user_comments.start_date = "2010-07-19 19:07:13" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "103" AND date = "2010-07-19 19:07:13" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "70" AND comments.start_date = "2010-07-19 19:07:01") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "70" AND user_comments.start_date = "2010-07-19 19:07:01" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "70" AND date = "2010-07-19 19:07:01" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Sporting Goods' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5

636