DealQUE | The Daily Steal 686 Mannual Hannah Puffy Jacket - Girls 2009

686 Mannual Hannah Puffy Jacket - Girls 2009 - Adorable and cute with technically specific youth sizing, features, prints and textures designed just for girls. 686 has created this Mannual Hannah Puffy Jacket for the girl that wants to be a part of every outside activity. There is 260 Grams of Polyfill insulation that has been quilted to the shell to keep her extra cozy and warm as she works her way through the fresh powder on the mountain, or her skills while in the park. The Youth Evolution lets the sleeves extend 1.5 inches more, it is easy to do, just turn the jacket inside out, snip the bright colored threads and she is set for another season, or until the end of this current season. Parents love this feature, especially knowing that another jacket may not be needed. There is an adjustable powder skirt with pant connect snap tabs to keep the unwanted snow from reaching her core. The hand warmer pockets help to warm her hand, should they need warming. The seams have been critically taped for added protection all day long. She will be stylish and comfortable while on or off of the mountain, and as a parent, that feeling is priceless.
Westech 5260 Grams of Polyfill insulated quilted to shellYouth Evolution 1.5 inch sleeve extension3 in 1 single pull hood drawcord adjustmentWeather guard rain gutter hood brimInternal center front zipper flap with peached chin guardAdjustable powder skirt with pant connect snap tabsInner hem side drawcord adjustHandwarmer pockets2 way center front vision zipperCritically taped seams

(default) 45 queries took 636 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
2	SELECT name,id,temp_cat,website FROM merchants WHERE id ="46"	1	1	0
3	SELECT category,sub_category FROM user_deals where uid = 46 AND start_date='2010-02-08 17^02^19'	0	0	0
4	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	1
5	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519935;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519935 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
6	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
7	( 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	628
8	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
9	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519935;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
10	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
11	(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
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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
13	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
14	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519936;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
15	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283501936	1		2
16	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
19	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
20	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519936;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
21	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519936;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
26	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519936;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
34	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "46" and deals.start_date="2010-02-08 17:02:19"	1	1	0
35	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '46' and start_date = '2010-02-08 17:02:19'	1	1	0
36	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "46" AND date = "2010-02-08 17^02^19" AND TIMEDIFF("2010-09-03 08:09:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
37	(SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "46" AND comments.start_date = "2010-02-08 17^02^19") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img 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-02-08 17^02^19" ) ORDER BY posted_on desc	0	0	0
38	SELECT img,code from verify_imgs	13	13	0
39	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
40	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="46"	1	1	0
41	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
42	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519936;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
43	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
44	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
45	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519936;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283519936 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0

(default) 45 queries took 636 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

SELECT name,id,temp_cat,website FROM merchants WHERE id ="46"

SELECT category,sub_category FROM user_deals where uid = 46 AND start_date='2010-02-08 17^02^19'

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

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

( 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

628

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

(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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283501936

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

(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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

(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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

(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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

(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:56", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "46" and deals.start_date="2010-02-08 17:02:19"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '46' and start_date = '2010-02-08 17:02:19'

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

(SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "46" AND comments.start_date = "2010-02-08 17^02^19") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img 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-02-08 17^02^19" ) ORDER BY posted_on desc

SELECT img,code from verify_imgs

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

SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="46"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

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