DealQUE | Final Fantasy X + X-2 + XII (3 Games)

Buyers will receive the following PS2 games: Final Fantasy X, Final Fantasy X-2, and Final Fantasy XII. Each game has been tested and works properly. Buyers will receive the game discs only. Following the exploits of the Summoner Yuna and her guardians as they battle an evil immortal enemy known as Sin, Final Fantasy X is the first title in the franchise to appear on the PlayStation 2. It's also the first game in Squaresoft's popular RPG series to feature voiceovers in addition to written text. Character expressiveness also reaches new heights with the aid of Squaresoft's "Facial Motion System", adding subtle facial expressions to characters in real-time. New side-quests include the underwater sport of Blitzball, and a monster battle arena as well as a redesigned fighting system that mixes classic Final Fantasy elements with a new "Sphere Grid" system. Marking the first true sequel in Squaresoft's popular RPG series, the story of Final Fantasy X-2 picks up two years after the events that took place in Final Fantasy X. Following the young and powerful Summoner Yuna's quest to rid Spira of the destructive force known as Sin, the world enters into a period known as the "Eternal Calm". During this moment of change, the people of Spira have shunned the once-sacred teachings of Yevon, and embraced the use of the formerly forbidden machina. While many of Spira's inhabitants are enjoying this time of peace, evidence of the High Summoner Yuna's lost love Tidus surfaces, prompting her to begin a new quest to find him. As war looms on the horizon, the mighty Archadian Empire begins a campaign to subjugate its neighbors. To Vaan, a young man living on the streets of Rabanastre, the Empire is a hated enemy who took the life of his brother. Planning on exacting revenge by breaking into the palace, Vaan gets more than he bargained for as he runs into Princess Ashe, the sole surviving heir to the Dalmascan throne. Together, the two embark on an incredible journey tracing the mysteries behind the Archadian Empire's invasion. Once again taking RPG players beyond imagination, the twelfth Final Fantasy's gameplay features include the Active Dimension Battle system enabling players to move seamlessly between exploration and combat. Characters act according to an intricate "gambit" system of actions and reactions that you determine. As they fight, characters earn license points that can be spent to broaden their knowledge of magic, arms and armor.

(default) 60 queries took 664 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `deals`	17	17	1
2	DESCRIBE `merchants`	13	13	1
3	DESCRIBE `verify_imgs`	3	3	1
4	DESCRIBE `monsters`	6	6	1
5	DESCRIBE `comments`	10	10	1
6	DESCRIBE `ratings`	5	5	1
7	DESCRIBE `user_comments`	8	8	1
8	DESCRIBE `user_deals`	15	15	1
9	DESCRIBE `users`	11	11	1
10	DESCRIBE `report_deals`	7	7	1
11	DESCRIBE `user_deal_ratings`	5	5	1
12	DESCRIBE `report_comments`	8	8	1
13	DESCRIBE `categories`	3	3	1
14	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
15	SELECT name,id,temp_cat,website FROM merchants WHERE id ="130"	1	1	0
16	SELECT category,sub_category FROM user_deals where uid = 130 AND start_date='2010-03-11 03^03^24'	0	0	0
17	DESCRIBE `sponsored_deals`	4	4	1
18	DESCRIBE `reviews`	9	9	1
19	DESCRIBE `user_reviews`	7	7	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:1284078594;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078594 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
22	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
23	( 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='Miscellaneous' 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='Miscellaneous' 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	645
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078594;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
26	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
27	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") 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 = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )	2	2	0
28	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078595;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
32	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "136" AND comments.start_date = "2010-09-09 18:09:09") 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 = "136" AND user_comments.start_date = "2010-09-09 18:09:09" )	2	2	0
33	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "136" AND date = "2010-09-09 18:09:09" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
34	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
35	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078595;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
36	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
37	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "42" AND comments.start_date = "2010-09-09 17:09:35") 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 = "42" AND user_comments.start_date = "2010-09-09 17:09:35" )	2	2	0
38	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "42" AND date = "2010-09-09 17:09:35" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
39	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
40	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078595;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
41	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
42	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "29" AND comments.start_date = "2010-09-09 17:09:33") 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 = "29" AND user_comments.start_date = "2010-09-09 17:09:33" )	2	2	0
43	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "29" AND date = "2010-09-09 17:09:33" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
44	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
45	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078595;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
46	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
47	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "26" AND comments.start_date = "2010-09-09 17: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 = "26" AND user_comments.start_date = "2010-09-09 17:09:32" )	2	2	0
48	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "26" AND date = "2010-09-09 17:09:32" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
49	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "130" and deals.start_date="2010-03-11 03:03:24"	1	1	0
50	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '130' and start_date = '2010-03-11 03:03:24'	1	1	0
51	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "130" AND date = "2010-03-11 03^03^24" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
52	(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 = "130" AND comments.start_date = "2010-03-11 03^03^24") 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 = "130" AND user_comments.start_date = "2010-03-11 03^03^24" ) ORDER BY posted_on desc	0	0	2
53	SELECT img,code from verify_imgs	13	13	0
54	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
55	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="130"	1	1	0
56	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
57	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078595;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
58	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
59	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
60	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078595;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078595 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 60 queries took 664 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `deals`

DESCRIBE `merchants`

DESCRIBE `verify_imgs`

DESCRIBE `monsters`

DESCRIBE `comments`

DESCRIBE `ratings`

DESCRIBE `user_comments`

DESCRIBE `user_deals`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `report_comments`

DESCRIBE `categories`

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

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

SELECT category,sub_category FROM user_deals where uid = 130 AND start_date='2010-03-11 03^03^24'

DESCRIBE `sponsored_deals`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

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

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

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

645

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(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") 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 = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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:1284078595;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284078595 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 = "136" AND comments.start_date = "2010-09-09 18:09:09") 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 = "136" AND user_comments.start_date = "2010-09-09 18:09:09" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "136" AND date = "2010-09-09 18:09:09" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "42" AND comments.start_date = "2010-09-09 17:09:35") 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 = "42" AND user_comments.start_date = "2010-09-09 17:09:35" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "42" AND date = "2010-09-09 17:09:35" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "29" AND comments.start_date = "2010-09-09 17:09:33") 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 = "29" AND user_comments.start_date = "2010-09-09 17:09:33" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "29" AND date = "2010-09-09 17:09:33" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "26" AND comments.start_date = "2010-09-09 17: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 = "26" AND user_comments.start_date = "2010-09-09 17:09:32" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "26" AND date = "2010-09-09 17:09:32" AND TIMEDIFF("2010-09-09 19:09:55", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "130" and deals.start_date="2010-03-11 03:03:24"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '130' and start_date = '2010-03-11 03:03:24'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "130" AND date = "2010-03-11 03^03^24" AND TIMEDIFF("2010-09-09 19:09:55", 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 = "130" AND comments.start_date = "2010-03-11 03^03^24") 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 = "130" AND user_comments.start_date = "2010-03-11 03^03^24" ) 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 ="130"

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'