DealQUE | Microsoft Zune 120GB Digital Media Player- Red (Open Box)

Massive capacity in a deluxe device that delivers uncompromised audio and video quality. Zune 120GB can fit a huge collection and still have room for videos, podcasts and more. This major player hooks up with innovative discovery features like Buy from FM and wireless sharing, so you never stop gobbling tunes. Holds up to 30,000 songs, 25,000 pictures, or 375 hours of video.

Price: $159.99
Features120GB capacity. Holds up to 30,000 songs, 25,000 pictures or 375 hours of video.Beautiful, big screen. Featuring a 3.2-inch color screen, Zune 120GB is perfect for portable video viewing.Touch controls. Kiss slow scrolling goodbye. The innovative new Zune pad makes browsing your device a blast. Fly effortlessly through your music, picture, and video collections.Wireless sync. Cut the cord to your PC. Refresh your Zune with new content anytime you charge your device, through your home wireless network.Wireless Zune-to-Zune sharing. Share full-length tracks of your favorite songs, albums, playlists or pictures.TV and movies to go. Zune Marketplace now offers more than 600 popular TV shows to download and own. Zune will import unprotected .WMV, .MPG4, and H.264 files into your video library.Built-in FM radio. Tune in to one of your favorite local stations while on the go or working out. Advanced tuning capabilities let you see the name of the song currently playing on select frequencies.Zune Marketplace. Featuring over 3 million songs, DRM-free MP3s, music videos, audio/video podcasts and more, your store is always open and just a mouse click away.Your games. Your music. Your way. Plug your Zune into your Xbox 360 and customize the soundtrack in your favorite games. You can also stream content in Zune software to your Xbox 360 using a wireless connection.Wirelessly browse and buy on the fly. Browse and purchase tracks from the Zune Marketplace online store directly from your device when in a Wi-Fi hotspot or through a home wireless network.Audiobooks. To start listening to your favorite book on your Zune, visit audible.com or overdrive.com to sync your favorites.Games on the go. Free games will keep you entertained on the go.Battery life: up to 30 hours of music playback.

(default) 50 queries took 638 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `comments`	10	10	1
2	DESCRIBE `user_comments`	8	8	1
3	DESCRIBE `users`	11	11	1
4	DESCRIBE `report_deals`	7	7	1
5	DESCRIBE `report_comments`	8	8	1
6	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
7	SELECT name,id,temp_cat,website FROM merchants WHERE id ="20"	1	1	0
8	SELECT category,sub_category FROM user_deals where uid = 20 AND start_date='2009-11-25 23^11^37'	0	0	0
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:1283520206;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520206 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
11	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
12	( 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='Computers and Electronics' 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='Computers and Electronics' 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	625
13	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
14	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520206;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
15	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
16	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "85" AND comments.start_date = "2010-09-03 08:09:20") 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 = "85" AND user_comments.start_date = "2010-09-03 08:09:20" )	2	2	0
17	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "85" AND date = "2010-09-03 08:09:20" AND TIMEDIFF("2010-09-03 08:09:27", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
18	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
19	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520207;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
20	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283502207	4		2
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 = "75" AND comments.start_date = "2010-09-03 07:09:25") 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 = "75" AND user_comments.start_date = "2010-09-03 07:09:25" )	2	2	0
23	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "75" AND date = "2010-09-03 07:09:25" AND TIMEDIFF("2010-09-03 08:09:27", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
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:1283520207;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 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 = "113" AND comments.start_date = "2010-09-03 06:09:21") 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 = "113" AND user_comments.start_date = "2010-09-03 06:09:21" )	2	2	0
28	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "113" AND date = "2010-09-03 06:09:21" AND TIMEDIFF("2010-09-03 08:09:27", 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:1283520207;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 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 = "146" AND comments.start_date = "2010-09-03 05:09:24") 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 = "146" AND user_comments.start_date = "2010-09-03 05:09:24" )	2	2	0
33	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "146" AND date = "2010-09-03 05:09:24" AND TIMEDIFF("2010-09-03 08:09:27", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
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:1283520207;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 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 = "131" AND comments.start_date = "2010-09-03 05:09:17") 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 = "131" AND user_comments.start_date = "2010-09-03 05:09:17" )	2	2	0
38	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "131" AND date = "2010-09-03 05:09:17" AND TIMEDIFF("2010-09-03 08:09:27", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
39	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "20" and deals.start_date="2009-11-25 23:11:37"	1	1	0
40	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '20' and start_date = '2009-11-25 23:11:37'	1	1	0
41	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "20" AND date = "2009-11-25 23^11^37" AND TIMEDIFF("2010-09-03 08:09:27", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
42	(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 = "20" AND comments.start_date = "2009-11-25 23^11^37") 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 = "20" AND user_comments.start_date = "2009-11-25 23^11^37" ) ORDER BY posted_on desc	0	0	2
43	SELECT img,code from verify_imgs	13	13	0
44	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
45	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="20"	1	1	0
46	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
47	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520207;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
48	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	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:1283520207;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520207 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0

(default) 50 queries took 638 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `comments`

DESCRIBE `user_comments`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `report_comments`

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

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

SELECT category,sub_category FROM user_deals where uid = 20 AND start_date='2009-11-25 23^11^37'

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:1283520206;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520206 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

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

( 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='Computers and Electronics' 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='Computers and Electronics' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5

625

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 = "85" AND comments.start_date = "2010-09-03 08:09:20") 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 = "85" AND user_comments.start_date = "2010-09-03 08:09:20" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "85" AND date = "2010-09-03 08:09:20" AND TIMEDIFF("2010-09-03 08:09:27", 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:1283520207;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520207 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'

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

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 = "75" AND comments.start_date = "2010-09-03 07:09:25") 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 = "75" AND user_comments.start_date = "2010-09-03 07:09:25" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "75" AND date = "2010-09-03 07:09:25" AND TIMEDIFF("2010-09-03 08:09:27", 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 = "113" AND comments.start_date = "2010-09-03 06:09:21") 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 = "113" AND user_comments.start_date = "2010-09-03 06:09:21" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "113" AND date = "2010-09-03 06:09:21" AND TIMEDIFF("2010-09-03 08:09:27", 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 = "146" AND comments.start_date = "2010-09-03 05:09:24") 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 = "146" AND user_comments.start_date = "2010-09-03 05:09:24" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "146" AND date = "2010-09-03 05:09:24" AND TIMEDIFF("2010-09-03 08:09:27", 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 = "131" AND comments.start_date = "2010-09-03 05:09:17") 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 = "131" AND user_comments.start_date = "2010-09-03 05:09:17" )

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

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "20" and deals.start_date="2009-11-25 23:11:37"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '20' and start_date = '2009-11-25 23:11:37'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "20" AND date = "2009-11-25 23^11^37" AND TIMEDIFF("2010-09-03 08:09:27", 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 = "20" AND comments.start_date = "2009-11-25 23^11^37") 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 = "20" AND user_comments.start_date = "2009-11-25 23^11^37" ) 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 ="20"

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(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'