Daily Vinyl Deals

Website:

Stats

Member since:

06.04.09

Submitted Deals:

327

Total Ques:

328

Advertisment

Thursday, September 9, 2010 by Vinyl In Style

Compare

Daily Deals / Miscellaneous

"My give a damn is busted" Vinyl sti...

This vinyl sticker is designed for you to put on your car and let the world know that you don't care anymore. That way when you cut someone off and they yell all you have to do is ...

Check Price

Leave a Review

change monster

Name

Subject

R U Human?

change image

Prove It!

Comment

Terms & Conditions

(default) 33 queries took 24 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `merchants`	13	13	1
2	DESCRIBE `ratings`	5	5	1
3	DESCRIBE `deals`	17	17	1
4	DESCRIBE `sponsored_deals`	4	4	1
5	DESCRIBE `user_deals`	15	15	1
6	DESCRIBE `user_deal_ratings`	5	5	1
7	DESCRIBE `categories`	3	3	1
8	DESCRIBE `reviews`	9	9	1
9	DESCRIBE `user_reviews`	7	7	1
10	DESCRIBE `monsters`	6	6	1
11	DESCRIBE `verify_imgs`	3	3	1
12	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
13	SELECT `Merchant`.`id`, `Merchant`.`name`, `Merchant`.`categoryOLD`, `Merchant`.`url`, `Merchant`.`date_created`, `Merchant`.`logo`, `Merchant`.`website`, `Merchant`.`slogan`, `Merchant`.`is_live`, `Merchant`.`email`, `Merchant`.`temp_cat`, `Merchant`.`affiliate_type`, `Merchant`.`affiliate_options` FROM `merchants` AS `Merchant` WHERE `Merchant`.`name` = 'Vinyl In Style' LIMIT 1	1	1	0
14	SELECT deals.start_date, deals.title, deals.category, deals.sub_category, deals.description, deals.link, deals.que_count, deals.shipping, deals.pub_date, deals.available, deals.price, deals.img, deals.img_size FROM deals WHERE merchant_id = "144" AND available="Y"	1	1	3
15	DESCRIBE `comments`	10	10	1
16	DESCRIBE `user_comments`	8	8	1
17	DESCRIBE `users`	11	11	1
18	DESCRIBE `report_deals`	7	7	1
19	DESCRIBE `report_comments`	8	8	1
20	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
21	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284081401;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284081401 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
22	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
23	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "144" AND comments.start_date = "2010-09-09 00:09:34") 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 = "144" AND user_comments.start_date = "2010-09-09 00:09:34" )	2	2	0
24	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "144" AND date = "2010-09-09 00:09:34" AND TIMEDIFF("2010-09-09 20:09:41", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
25	(SELECT reviews.name as name, reviews.subject as subject, reviews.body as body, reviews.posted_on as posted_on, "anon" as user_type, reviews.id as ident_id, monsters.img as img FROM reviews,monsters WHERE reviews.is_live = "true" AND reviews.monster_id = monsters.id AND reviews.merchant_id = "144") UNION ALL ( SELECT users.username as name, user_reviews.subject as subject, user_reviews.body as body, user_reviews.posted_on as posted_on, user_reviews.user_id as user_type, user_reviews.posted_on as ident_id, monsters.img as img FROM users,user_reviews,monsters WHERE user_reviews.is_live = "true" AND user_reviews.user_id = users.id AND users.monster_id = monsters.id AND user_reviews.merchant_id = "144") ORDER BY posted_on desc	0	0	1
26	SELECT img,code from verify_imgs	13	13	0
27	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
28	SELECT count(merchant_id) as num_submited, sum(que_count) as total_ques FROM deals WHERE merchant_id = "144" GROUP BY merchant_id	1	1	3
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284081401;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284081401 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
32	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
33	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284081401;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284081401 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 33 queries took 24 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `merchants`

DESCRIBE `ratings`

DESCRIBE `deals`

DESCRIBE `sponsored_deals`

DESCRIBE `user_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `categories`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

DESCRIBE `monsters`

DESCRIBE `verify_imgs`

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

SELECT `Merchant`.`id`, `Merchant`.`name`, `Merchant`.`categoryOLD`, `Merchant`.`url`, `Merchant`.`date_created`, `Merchant`.`logo`, `Merchant`.`website`, `Merchant`.`slogan`, `Merchant`.`is_live`, `Merchant`.`email`, `Merchant`.`temp_cat`, `Merchant`.`affiliate_type`, `Merchant`.`affiliate_options` FROM `merchants` AS `Merchant` WHERE `Merchant`.`name` = 'Vinyl In Style' LIMIT 1

SELECT deals.start_date, deals.title, deals.category, deals.sub_category, deals.description, deals.link, deals.que_count, deals.shipping, deals.pub_date, deals.available, deals.price, deals.img, deals.img_size FROM deals WHERE merchant_id = "144" AND available="Y"

DESCRIBE `comments`

DESCRIBE `user_comments`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `report_comments`

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

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

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

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "144" AND comments.start_date = "2010-09-09 00:09:34") 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 = "144" AND user_comments.start_date = "2010-09-09 00:09:34" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "144" AND date = "2010-09-09 00:09:34" AND TIMEDIFF("2010-09-09 20:09:41", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

(SELECT reviews.name as name, reviews.subject as subject, reviews.body as body, reviews.posted_on as posted_on, "anon" as user_type, reviews.id as ident_id, monsters.img as img FROM reviews,monsters WHERE reviews.is_live = "true" AND reviews.monster_id = monsters.id AND reviews.merchant_id = "144") UNION ALL ( SELECT users.username as name, user_reviews.subject as subject, user_reviews.body as body, user_reviews.posted_on as posted_on, user_reviews.user_id as user_type, user_reviews.posted_on as ident_id, monsters.img as img FROM users,user_reviews,monsters WHERE user_reviews.is_live = "true" AND user_reviews.user_id = users.id AND users.monster_id = monsters.id AND user_reviews.merchant_id = "144") ORDER BY posted_on desc

SELECT img,code from verify_imgs

SELECT * from monsters where is_live ="true" and rights = "public"

SELECT count(merchant_id) as num_submited, sum(que_count) as total_ques FROM deals WHERE merchant_id = "144" GROUP BY merchant_id

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

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

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