This Site utilizes Flash Player 9 or above.

For the full experience please get Flash Player 9 or above. Click on the link below and follow the instructions to install.

Get Adobe Flash player

Latest Games

Show Only:

News

  • thumbnail

    9.2.10

    Phantom EFX Game Giveaway Code: 9/2/10

    We posted another episode in the Phantom EFX web series yesterday! Go to www.YouTube.com/officialphantomefx to enjoy all seven episodes that have been released thus far.

     

    Today's Insider Blog...

  • thumbnail

    9.1.10

    Phantom EFX Game Giveaway Code: 9/110

    Happy September!

     

    Thanks to everyone who participated in yesterday's contest. We are happy to announce three happy winners-- to find their names head on over to www.facebook.com/phantomefx or...

  • thumbnail

    8.31.10

    Phantom EFX Game Giveaway Code: 8/31/10

    Today we are giving away THREE free games! That's 3X the chances for you to win your game! Be sure to collect all your codes & good luck!

     

    Today's Insider Blog code is: 2WR5SCR7RD

     

    Enter...

Read More Of Our News Stories

 Subscribe

Interact With Us

Phantom EFX on twitter

Subscribing to our email newsletter allows you to be the first to hear about our latest releases. Plus, you also learn about special offers that you won't hear about anywhere else. Did we mention it's free?

Close
(default) 49 queries took 40 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, `Post`.`created`, `Post`.`modified`, `Post`.`status_id`, `Post`.`published`, `Post`.`tags`, `Post`.`type`, `Post`.`category_id`, `Post`.`attachmentName`, `Post`.`attachmentType`, `Post`.`attachmentLocation`, `Post`.`attachmentSize`, `Post`.`attachmentWidth`, `Post`.`attachmentHeight`, `Post`.`user_id`, `Post`.`parent_id`, `Post`.`comment_count`, `Post`.`photo_count`, `Post`.`url`, `Post`.`installInstructions`, `Post`.`newsBanner`, `Status`.`id`, `Status`.`name`, `Status`.`post_count`, `Status`.`comment_count`, `Status`.`album_count`, `Status`.`media_count`, `Status`.`link_count`, `Status`.`newsletter_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`created`, `User`.`modified`, `User`.`subscribed`, `Category`.`id`, `Category`.`name` FROM `posts` AS `Post` LEFT JOIN `statuses` AS `Status` ON (`Post`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) WHERE `Post`.`category_id` IN (1, 4) ORDER BY `Post`.`published` DESC LIMIT 3330
2SELECT `Comment`.`id`, `Comment`.`title`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`status_id`, `Comment`.`published`, `Comment`.`tags`, `Comment`.`type`, `Comment`.`category_id`, `Comment`.`attachmentName`, `Comment`.`attachmentType`, `Comment`.`attachmentLocation`, `Comment`.`attachmentSize`, `Comment`.`attachmentWidth`, `Comment`.`attachmentHeight`, `Comment`.`user_id`, `Comment`.`parent_id`, `Comment`.`comment_count`, `Comment`.`photo_count`, `Comment`.`url`, `Comment`.`installInstructions`, `Comment`.`newsBanner` FROM `posts` AS `Comment` WHERE `Comment`.`parent_id` IN (20, 18, 7) ORDER BY `Comment`.`id` DESC 000
3SELECT `Tag`.`id`, `Tag`.`name`, `PostsTag`.`id`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (20, 18, 7) AND `PostsTag`.`tag_id` = `Tag`.`id`) 000
4SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, `Post`.`created`, `Post`.`modified`, `Post`.`status_id`, `Post`.`published`, `Post`.`tags`, `Post`.`type`, `Post`.`category_id`, `Post`.`attachmentName`, `Post`.`attachmentType`, `Post`.`attachmentLocation`, `Post`.`attachmentSize`, `Post`.`attachmentWidth`, `Post`.`attachmentHeight`, `Post`.`user_id`, `Post`.`parent_id`, `Post`.`comment_count`, `Post`.`photo_count`, `Post`.`url`, `Post`.`installInstructions`, `Post`.`newsBanner`, `Status`.`id`, `Status`.`name`, `Status`.`post_count`, `Status`.`comment_count`, `Status`.`album_count`, `Status`.`media_count`, `Status`.`link_count`, `Status`.`newsletter_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`created`, `User`.`modified`, `User`.`subscribed`, `Category`.`id`, `Category`.`name` FROM `posts` AS `Post` LEFT JOIN `statuses` AS `Status` ON (`Post`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) WHERE `Post`.`category_id` = 2 ORDER BY `Post`.`published` DESC LIMIT 3111
5SELECT `Comment`.`id`, `Comment`.`title`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`status_id`, `Comment`.`published`, `Comment`.`tags`, `Comment`.`type`, `Comment`.`category_id`, `Comment`.`attachmentName`, `Comment`.`attachmentType`, `Comment`.`attachmentLocation`, `Comment`.`attachmentSize`, `Comment`.`attachmentWidth`, `Comment`.`attachmentHeight`, `Comment`.`user_id`, `Comment`.`parent_id`, `Comment`.`comment_count`, `Comment`.`photo_count`, `Comment`.`url`, `Comment`.`installInstructions`, `Comment`.`newsBanner` FROM `posts` AS `Comment` WHERE `Comment`.`parent_id` = (8) ORDER BY `Comment`.`id` DESC 000
6SELECT `Tag`.`id`, `Tag`.`name`, `PostsTag`.`id`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 8 AND `PostsTag`.`tag_id` = `Tag`.`id`) 000
7SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, `Post`.`created`, `Post`.`modified`, `Post`.`status_id`, `Post`.`published`, `Post`.`tags`, `Post`.`type`, `Post`.`category_id`, `Post`.`attachmentName`, `Post`.`attachmentType`, `Post`.`attachmentLocation`, `Post`.`attachmentSize`, `Post`.`attachmentWidth`, `Post`.`attachmentHeight`, `Post`.`user_id`, `Post`.`parent_id`, `Post`.`comment_count`, `Post`.`photo_count`, `Post`.`url`, `Post`.`installInstructions`, `Post`.`newsBanner`, `Status`.`id`, `Status`.`name`, `Status`.`post_count`, `Status`.`comment_count`, `Status`.`album_count`, `Status`.`media_count`, `Status`.`link_count`, `Status`.`newsletter_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`created`, `User`.`modified`, `User`.`subscribed`, `Category`.`id`, `Category`.`name` FROM `posts` AS `Post` LEFT JOIN `statuses` AS `Status` ON (`Post`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) WHERE `Post`.`category_id` = 3 ORDER BY `Post`.`published` DESC LIMIT 3331
8SELECT `Comment`.`id`, `Comment`.`title`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`status_id`, `Comment`.`published`, `Comment`.`tags`, `Comment`.`type`, `Comment`.`category_id`, `Comment`.`attachmentName`, `Comment`.`attachmentType`, `Comment`.`attachmentLocation`, `Comment`.`attachmentSize`, `Comment`.`attachmentWidth`, `Comment`.`attachmentHeight`, `Comment`.`user_id`, `Comment`.`parent_id`, `Comment`.`comment_count`, `Comment`.`photo_count`, `Comment`.`url`, `Comment`.`installInstructions`, `Comment`.`newsBanner` FROM `posts` AS `Comment` WHERE `Comment`.`parent_id` IN (54, 53, 52) ORDER BY `Comment`.`id` DESC 000
9SELECT `Tag`.`id`, `Tag`.`name`, `PostsTag`.`id`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (54, 53, 52) AND `PostsTag`.`tag_id` = `Tag`.`id`) 000
10SELECT `Game`.`id`, `Game`.`name`, `Game`.`created`, `Game`.`published`, `Game`.`gametype_id`, `Game`.`seriesTitle`, `Game`.`gameTitle`, `Game`.`description`, `Game`.`tagline`, `Game`.`systemRequirements`, `Game`.`gameIdImage`, `Game`.`boxImage`, `Game`.`adSwf`, `Game`.`bannerSwf`, `Game`.`bannerImg`, `Game`.`screenshots`, `Game`.`video`, `Game`.`rating_id`, `Game`.`rcontents`, `Game`.`patches`, `Game`.`tags`, `Game`.`modified`, `Game`.`compatible_id`, `Rating`.`id`, `Rating`.`name`, `Rating`.`img`, `Rating`.`smallImg`, `Compatible`.`id`, `Compatible`.`type`, `Compatible`.`game_list`, `Gametype`.`id`, `Gametype`.`name`, `Gametype`.`image` FROM `games` AS `Game` LEFT JOIN `ratings` AS `Rating` ON (`Game`.`rating_id` = `Rating`.`id`) LEFT JOIN `compatibles` AS `Compatible` ON (`Game`.`compatible_id` = `Compatible`.`id`) LEFT JOIN `gametypes` AS `Gametype` ON (`Game`.`gametype_id` = `Gametype`.`id`) WHERE `Game`.`gametype_id` IN (2, 1, 5) ORDER BY `Game`.`published` DESC LIMIT 9991
11SELECT `Screenshot`.`id`, `Screenshot`.`game_id`, `Screenshot`.`name` FROM `screenshots` AS `Screenshot` WHERE `Screenshot`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) 88880
12SELECT `Registeration`.`id`, `Registeration`.`game_id`, `Registeration`.`first_name`, `Registeration`.`last_name`, `Registeration`.`email`, `Registeration`.`address`, `Registeration`.`country`, `Registeration`.`city`, `Registeration`.`state`, `Registeration`.`other_state`, `Registeration`.`zip`, `Registeration`.`gender`, `Registeration`.`reason`, `Registeration`.`average_income`, `Registeration`.`email_opt_in`, `Registeration`.`purchased` FROM `registerations` AS `Registeration` WHERE `Registeration`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) 362636269
13SELECT `Rcontent`.`id`, `Rcontent`.`name`, `GamesRcontent`.`id`, `GamesRcontent`.`game_id`, `GamesRcontent`.`rcontent_id` FROM `rcontents` AS `Rcontent` JOIN `games_rcontents` AS `GamesRcontent` ON (`GamesRcontent`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) AND `GamesRcontent`.`rcontent_id` = `Rcontent`.`id`) 22220
14SELECT `Tag`.`id`, `Tag`.`name`, `GamesTag`.`id`, `GamesTag`.`game_id`, `GamesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `games_tags` AS `GamesTag` ON (`GamesTag`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) AND `GamesTag`.`tag_id` = `Tag`.`id`) 330
15SELECT `Store`.`id`, `Store`.`name`, `Store`.`url`, `Store`.`icon`, `Location`.`id`, `Location`.`game_id`, `Location`.`store_id`, `Location`.`link`, `Location`.`price` FROM `stores` AS `Store` JOIN `locations` AS `Location` ON (`Location`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) AND `Location`.`store_id` = `Store`.`id`) 220
16SELECT `Update`.`id`, `Update`.`name`, `Update`.`description`, `Update`.`instructions`, `Update`.`modified`, `Update`.`size`, `Update`.`created`, `Update`.`link`, `GamesUpdate`.`id`, `GamesUpdate`.`game_id`, `GamesUpdate`.`update_id` FROM `updates` AS `Update` JOIN `games_updates` AS `GamesUpdate` ON (`GamesUpdate`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) AND `GamesUpdate`.`update_id` = `Update`.`id`) 20200
17SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`icon`, `Product`.`id`, `Product`.`game_id`, `Product`.`platform_id`, `Product`.`sku`, `Product`.`buyGameLink`, `Product`.`price` FROM `platforms` AS `Platform` JOIN `products` AS `Product` ON (`Product`.`game_id` IN (157, 158, 8, 9, 1, 2, 18, 3, 7) AND `Product`.`platform_id` = `Platform`.`id`) 990
18SELECT `Game`.`id`, `Game`.`name`, `Game`.`created`, `Game`.`published`, `Game`.`gametype_id`, `Game`.`seriesTitle`, `Game`.`gameTitle`, `Game`.`description`, `Game`.`tagline`, `Game`.`systemRequirements`, `Game`.`gameIdImage`, `Game`.`boxImage`, `Game`.`adSwf`, `Game`.`bannerSwf`, `Game`.`bannerImg`, `Game`.`screenshots`, `Game`.`video`, `Game`.`rating_id`, `Game`.`rcontents`, `Game`.`patches`, `Game`.`tags`, `Game`.`modified`, `Game`.`compatible_id`, `Rating`.`id`, `Rating`.`name`, `Rating`.`img`, `Rating`.`smallImg`, `Compatible`.`id`, `Compatible`.`type`, `Compatible`.`game_list`, `Gametype`.`id`, `Gametype`.`name`, `Gametype`.`image` FROM `games` AS `Game` LEFT JOIN `ratings` AS `Rating` ON (`Game`.`rating_id` = `Rating`.`id`) LEFT JOIN `compatibles` AS `Compatible` ON (`Game`.`compatible_id` = `Compatible`.`id`) LEFT JOIN `gametypes` AS `Gametype` ON (`Game`.`gametype_id` = `Gametype`.`id`) WHERE `Game`.`gametype_id` = 2 ORDER BY `Game`.`published` DESC LIMIT 9991
19SELECT `Screenshot`.`id`, `Screenshot`.`game_id`, `Screenshot`.`name` FROM `screenshots` AS `Screenshot` WHERE `Screenshot`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) 92920
20SELECT `Registeration`.`id`, `Registeration`.`game_id`, `Registeration`.`first_name`, `Registeration`.`last_name`, `Registeration`.`email`, `Registeration`.`address`, `Registeration`.`country`, `Registeration`.`city`, `Registeration`.`state`, `Registeration`.`other_state`, `Registeration`.`zip`, `Registeration`.`gender`, `Registeration`.`reason`, `Registeration`.`average_income`, `Registeration`.`email_opt_in`, `Registeration`.`purchased` FROM `registerations` AS `Registeration` WHERE `Registeration`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) 4080408010
21SELECT `Rcontent`.`id`, `Rcontent`.`name`, `GamesRcontent`.`id`, `GamesRcontent`.`game_id`, `GamesRcontent`.`rcontent_id` FROM `rcontents` AS `Rcontent` JOIN `games_rcontents` AS `GamesRcontent` ON (`GamesRcontent`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) AND `GamesRcontent`.`rcontent_id` = `Rcontent`.`id`) 25250
22SELECT `Tag`.`id`, `Tag`.`name`, `GamesTag`.`id`, `GamesTag`.`game_id`, `GamesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `games_tags` AS `GamesTag` ON (`GamesTag`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) AND `GamesTag`.`tag_id` = `Tag`.`id`) 220
23SELECT `Store`.`id`, `Store`.`name`, `Store`.`url`, `Store`.`icon`, `Location`.`id`, `Location`.`game_id`, `Location`.`store_id`, `Location`.`link`, `Location`.`price` FROM `stores` AS `Store` JOIN `locations` AS `Location` ON (`Location`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) AND `Location`.`store_id` = `Store`.`id`) 000
24SELECT `Update`.`id`, `Update`.`name`, `Update`.`description`, `Update`.`instructions`, `Update`.`modified`, `Update`.`size`, `Update`.`created`, `Update`.`link`, `GamesUpdate`.`id`, `GamesUpdate`.`game_id`, `GamesUpdate`.`update_id` FROM `updates` AS `Update` JOIN `games_updates` AS `GamesUpdate` ON (`GamesUpdate`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) AND `GamesUpdate`.`update_id` = `Update`.`id`) 23230
25SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`icon`, `Product`.`id`, `Product`.`game_id`, `Product`.`platform_id`, `Product`.`sku`, `Product`.`buyGameLink`, `Product`.`price` FROM `platforms` AS `Platform` JOIN `products` AS `Product` ON (`Product`.`game_id` IN (157, 8, 2, 18, 7, 13, 16, 19, 22) AND `Product`.`platform_id` = `Platform`.`id`) 11110
26SELECT `Game`.`id`, `Game`.`name`, `Game`.`created`, `Game`.`published`, `Game`.`gametype_id`, `Game`.`seriesTitle`, `Game`.`gameTitle`, `Game`.`description`, `Game`.`tagline`, `Game`.`systemRequirements`, `Game`.`gameIdImage`, `Game`.`boxImage`, `Game`.`adSwf`, `Game`.`bannerSwf`, `Game`.`bannerImg`, `Game`.`screenshots`, `Game`.`video`, `Game`.`rating_id`, `Game`.`rcontents`, `Game`.`patches`, `Game`.`tags`, `Game`.`modified`, `Game`.`compatible_id`, `Rating`.`id`, `Rating`.`name`, `Rating`.`img`, `Rating`.`smallImg`, `Compatible`.`id`, `Compatible`.`type`, `Compatible`.`game_list`, `Gametype`.`id`, `Gametype`.`name`, `Gametype`.`image` FROM `games` AS `Game` LEFT JOIN `ratings` AS `Rating` ON (`Game`.`rating_id` = `Rating`.`id`) LEFT JOIN `compatibles` AS `Compatible` ON (`Game`.`compatible_id` = `Compatible`.`id`) LEFT JOIN `gametypes` AS `Gametype` ON (`Game`.`gametype_id` = `Gametype`.`id`) WHERE `Game`.`gametype_id` = 1 ORDER BY `Game`.`published` DESC LIMIT 9881
27SELECT `Screenshot`.`id`, `Screenshot`.`game_id`, `Screenshot`.`name` FROM `screenshots` AS `Screenshot` WHERE `Screenshot`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) 65650
28SELECT `Registeration`.`id`, `Registeration`.`game_id`, `Registeration`.`first_name`, `Registeration`.`last_name`, `Registeration`.`email`, `Registeration`.`address`, `Registeration`.`country`, `Registeration`.`city`, `Registeration`.`state`, `Registeration`.`other_state`, `Registeration`.`zip`, `Registeration`.`gender`, `Registeration`.`reason`, `Registeration`.`average_income`, `Registeration`.`email_opt_in`, `Registeration`.`purchased` FROM `registerations` AS `Registeration` WHERE `Registeration`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) 154015406
29SELECT `Rcontent`.`id`, `Rcontent`.`name`, `GamesRcontent`.`id`, `GamesRcontent`.`game_id`, `GamesRcontent`.`rcontent_id` FROM `rcontents` AS `Rcontent` JOIN `games_rcontents` AS `GamesRcontent` ON (`GamesRcontent`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) AND `GamesRcontent`.`rcontent_id` = `Rcontent`.`id`) 16160
30SELECT `Tag`.`id`, `Tag`.`name`, `GamesTag`.`id`, `GamesTag`.`game_id`, `GamesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `games_tags` AS `GamesTag` ON (`GamesTag`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) AND `GamesTag`.`tag_id` = `Tag`.`id`) 000
31SELECT `Store`.`id`, `Store`.`name`, `Store`.`url`, `Store`.`icon`, `Location`.`id`, `Location`.`game_id`, `Location`.`store_id`, `Location`.`link`, `Location`.`price` FROM `stores` AS `Store` JOIN `locations` AS `Location` ON (`Location`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) AND `Location`.`store_id` = `Store`.`id`) 220
32SELECT `Update`.`id`, `Update`.`name`, `Update`.`description`, `Update`.`instructions`, `Update`.`modified`, `Update`.`size`, `Update`.`created`, `Update`.`link`, `GamesUpdate`.`id`, `GamesUpdate`.`game_id`, `GamesUpdate`.`update_id` FROM `updates` AS `Update` JOIN `games_updates` AS `GamesUpdate` ON (`GamesUpdate`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) AND `GamesUpdate`.`update_id` = `Update`.`id`) 17170
33SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`icon`, `Product`.`id`, `Product`.`game_id`, `Product`.`platform_id`, `Product`.`sku`, `Product`.`buyGameLink`, `Product`.`price` FROM `platforms` AS `Platform` JOIN `products` AS `Product` ON (`Product`.`game_id` IN (158, 1, 3, 14, 17, 20, 23, 26) AND `Product`.`platform_id` = `Platform`.`id`) 11110
34SELECT `Game`.`id`, `Game`.`name`, `Game`.`created`, `Game`.`published`, `Game`.`gametype_id`, `Game`.`seriesTitle`, `Game`.`gameTitle`, `Game`.`description`, `Game`.`tagline`, `Game`.`systemRequirements`, `Game`.`gameIdImage`, `Game`.`boxImage`, `Game`.`adSwf`, `Game`.`bannerSwf`, `Game`.`bannerImg`, `Game`.`screenshots`, `Game`.`video`, `Game`.`rating_id`, `Game`.`rcontents`, `Game`.`patches`, `Game`.`tags`, `Game`.`modified`, `Game`.`compatible_id`, `Rating`.`id`, `Rating`.`name`, `Rating`.`img`, `Rating`.`smallImg`, `Compatible`.`id`, `Compatible`.`type`, `Compatible`.`game_list`, `Gametype`.`id`, `Gametype`.`name`, `Gametype`.`image` FROM `games` AS `Game` LEFT JOIN `ratings` AS `Rating` ON (`Game`.`rating_id` = `Rating`.`id`) LEFT JOIN `compatibles` AS `Compatible` ON (`Game`.`compatible_id` = `Compatible`.`id`) LEFT JOIN `gametypes` AS `Gametype` ON (`Game`.`gametype_id` = `Gametype`.`id`) WHERE `Game`.`gametype_id` = 5 ORDER BY `Game`.`published` DESC LIMIT 3331
35SELECT `Screenshot`.`id`, `Screenshot`.`game_id`, `Screenshot`.`name` FROM `screenshots` AS `Screenshot` WHERE `Screenshot`.`game_id` IN (9, 12, 15) 30300
36SELECT `Registeration`.`id`, `Registeration`.`game_id`, `Registeration`.`first_name`, `Registeration`.`last_name`, `Registeration`.`email`, `Registeration`.`address`, `Registeration`.`country`, `Registeration`.`city`, `Registeration`.`state`, `Registeration`.`other_state`, `Registeration`.`zip`, `Registeration`.`gender`, `Registeration`.`reason`, `Registeration`.`average_income`, `Registeration`.`email_opt_in`, `Registeration`.`purchased` FROM `registerations` AS `Registeration` WHERE `Registeration`.`game_id` IN (9, 12, 15) 3493494
37SELECT `Rcontent`.`id`, `Rcontent`.`name`, `GamesRcontent`.`id`, `GamesRcontent`.`game_id`, `GamesRcontent`.`rcontent_id` FROM `rcontents` AS `Rcontent` JOIN `games_rcontents` AS `GamesRcontent` ON (`GamesRcontent`.`game_id` IN (9, 12, 15) AND `GamesRcontent`.`rcontent_id` = `Rcontent`.`id`) 880
38SELECT `Tag`.`id`, `Tag`.`name`, `GamesTag`.`id`, `GamesTag`.`game_id`, `GamesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `games_tags` AS `GamesTag` ON (`GamesTag`.`game_id` IN (9, 12, 15) AND `GamesTag`.`tag_id` = `Tag`.`id`) 220
39SELECT `Store`.`id`, `Store`.`name`, `Store`.`url`, `Store`.`icon`, `Location`.`id`, `Location`.`game_id`, `Location`.`store_id`, `Location`.`link`, `Location`.`price` FROM `stores` AS `Store` JOIN `locations` AS `Location` ON (`Location`.`game_id` IN (9, 12, 15) AND `Location`.`store_id` = `Store`.`id`) 000
40SELECT `Update`.`id`, `Update`.`name`, `Update`.`description`, `Update`.`instructions`, `Update`.`modified`, `Update`.`size`, `Update`.`created`, `Update`.`link`, `GamesUpdate`.`id`, `GamesUpdate`.`game_id`, `GamesUpdate`.`update_id` FROM `updates` AS `Update` JOIN `games_updates` AS `GamesUpdate` ON (`GamesUpdate`.`game_id` IN (9, 12, 15) AND `GamesUpdate`.`update_id` = `Update`.`id`) 330
41SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`icon`, `Product`.`id`, `Product`.`game_id`, `Product`.`platform_id`, `Product`.`sku`, `Product`.`buyGameLink`, `Product`.`price` FROM `platforms` AS `Platform` JOIN `products` AS `Product` ON (`Product`.`game_id` IN (9, 12, 15) AND `Product`.`platform_id` = `Platform`.`id`) 440
42SELECT `Game`.`id`, `Game`.`name`, `Game`.`created`, `Game`.`published`, `Game`.`gametype_id`, `Game`.`seriesTitle`, `Game`.`gameTitle`, `Game`.`description`, `Game`.`tagline`, `Game`.`systemRequirements`, `Game`.`gameIdImage`, `Game`.`boxImage`, `Game`.`adSwf`, `Game`.`bannerSwf`, `Game`.`bannerImg`, `Game`.`screenshots`, `Game`.`video`, `Game`.`rating_id`, `Game`.`rcontents`, `Game`.`patches`, `Game`.`tags`, `Game`.`modified`, `Game`.`compatible_id`, `Rating`.`id`, `Rating`.`name`, `Rating`.`img`, `Rating`.`smallImg`, `Compatible`.`id`, `Compatible`.`type`, `Compatible`.`game_list`, `Gametype`.`id`, `Gametype`.`name`, `Gametype`.`image` FROM `games` AS `Game` LEFT JOIN `ratings` AS `Rating` ON (`Game`.`rating_id` = `Rating`.`id`) LEFT JOIN `compatibles` AS `Compatible` ON (`Game`.`compatible_id` = `Compatible`.`id`) LEFT JOIN `gametypes` AS `Gametype` ON (`Game`.`gametype_id` = `Gametype`.`id`) WHERE `Game`.`gametype_id` = 7 ORDER BY `Game`.`published` DESC LIMIT 9991
43SELECT `Screenshot`.`id`, `Screenshot`.`game_id`, `Screenshot`.`name` FROM `screenshots` AS `Screenshot` WHERE `Screenshot`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) 30300
44SELECT `Registeration`.`id`, `Registeration`.`game_id`, `Registeration`.`first_name`, `Registeration`.`last_name`, `Registeration`.`email`, `Registeration`.`address`, `Registeration`.`country`, `Registeration`.`city`, `Registeration`.`state`, `Registeration`.`other_state`, `Registeration`.`zip`, `Registeration`.`gender`, `Registeration`.`reason`, `Registeration`.`average_income`, `Registeration`.`email_opt_in`, `Registeration`.`purchased` FROM `registerations` AS `Registeration` WHERE `Registeration`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) 62624
45SELECT `Rcontent`.`id`, `Rcontent`.`name`, `GamesRcontent`.`id`, `GamesRcontent`.`game_id`, `GamesRcontent`.`rcontent_id` FROM `rcontents` AS `Rcontent` JOIN `games_rcontents` AS `GamesRcontent` ON (`GamesRcontent`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) AND `GamesRcontent`.`rcontent_id` = `Rcontent`.`id`) 000
46SELECT `Tag`.`id`, `Tag`.`name`, `GamesTag`.`id`, `GamesTag`.`game_id`, `GamesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `games_tags` AS `GamesTag` ON (`GamesTag`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) AND `GamesTag`.`tag_id` = `Tag`.`id`) 000
47SELECT `Store`.`id`, `Store`.`name`, `Store`.`url`, `Store`.`icon`, `Location`.`id`, `Location`.`game_id`, `Location`.`store_id`, `Location`.`link`, `Location`.`price` FROM `stores` AS `Store` JOIN `locations` AS `Location` ON (`Location`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) AND `Location`.`store_id` = `Store`.`id`) 000
48SELECT `Update`.`id`, `Update`.`name`, `Update`.`description`, `Update`.`instructions`, `Update`.`modified`, `Update`.`size`, `Update`.`created`, `Update`.`link`, `GamesUpdate`.`id`, `GamesUpdate`.`game_id`, `GamesUpdate`.`update_id` FROM `updates` AS `Update` JOIN `games_updates` AS `GamesUpdate` ON (`GamesUpdate`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) AND `GamesUpdate`.`update_id` = `Update`.`id`) 000
49SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`icon`, `Product`.`id`, `Product`.`game_id`, `Product`.`platform_id`, `Product`.`sku`, `Product`.`buyGameLink`, `Product`.`price` FROM `platforms` AS `Platform` JOIN `products` AS `Product` ON (`Product`.`game_id` IN (159, 160, 107, 96, 89, 92, 93, 94, 98) AND `Product`.`platform_id` = `Platform`.`id`) 990