Audio and Video / Speakers
0 deals found

all deals   all daily deals   all user submited deals


There are no deals in this category, please try again or look for some deals using our search bar.

Advertisment
Our Sponsors
Top Ques / Audio and Video / Speakers
Advertisment
(default) 18 queries took 1721 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'110
2SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-09 19:09:37" LIMIT 2000
3SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Audio and Video' AND category='Speakers' 110
4SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y' 1122
5SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y' 11183
6SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y' 110
7SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y' 110
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='Audio and Video' AND sub_category='Speakers' 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='Audio and Video' AND sub_category='Speakers' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,1000778
9 ( 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='Audio and Video' AND sub_category='Speakers' 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='Audio and Video' AND sub_category='Speakers' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 500734
10SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'111
11UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077737;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077739 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'11
12SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'110
13SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent 18180
14SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'110
15UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077739;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077739 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'11
16SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'110
17SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'111
18UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077739;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077739 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'00