• Escape Dead Island

    by JohnnRckr, Posted25 Nov 2014

    Zombies, like the plague itself, have been infesting every single aspect of media and entertainment. I don’t want to be the one who says it, but

    0
  • Assassin's Creed Unity

    by Grayshadow, Posted23 Nov 2014

    Assassin's Creed Unity is Ubisoft's first effort exclusively for this generation, sacrificing competitive multiplayer for cooperative and addi

    0
  • Assassin's Creed Rogue

    by Grayshadow, Posted16 Nov 2014

    Assassin’s Creed Rogue is a safe game. Instead of attempt bold new risk, Rogue merely builds upon the mechanics of Black Flag. Without a multipl

    0

Editorials

Featured

03 Oct, 2014

Too many games! How do I choose?!

  • Middle-earth: Shadow of Mordor
  • Super Smash Bros for 3DS
  • Hyrule Warriors
  • Sherlock Holmes: Crimes & Punishments
  • Destiny, man. It's still all about Destiny.
Sign Up to Vote!

(default) 28 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `News`.`id`, `News`.`title`, `News`.`tagline`, `News`.`game_id`, `News`.`featured`, `News`.`total_comment`, `News`.`created`, `News`.`user_id`, `News`.`news_image`, `News`.`content`, `News`.`status`, `News`.`modified`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`dob`, `User`.`gender`, `User`.`country`, `User`.`time_zone`, `User`.`password`, `User`.`avatar_image`, `User`.`banner_image`, `User`.`signature`, `User`.`show_online`, `User`.`my_sig`, `User`.`newsletter_subscription`, `User`.`other_sig`, `User`.`allow_html`, `User`.`per_page`, `User`.`post_per_page`, `User`.`show_dob`, `User`.`show_email`, `User`.`blog_read`, `User`.`blog_comment`, `User`.`profile_read`, `User`.`status`, `User`.`created`, `User`.`activation_key`, `User`.`activated`, `User`.`level`, `User`.`level_name`, `User`.`level_point`, `User`.`level_time`, `User`.`about_me`, `User`.`penalty`, `User`.`online`, `User`.`log_time`, `User`.`site_writer`, `User`.`visited`, `User`.`last_login`, `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`news` AS `News` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `noobfsjv_nooblive`.`games` AS `Game` ON (`News`.`game_id` = `Game`.`id`) WHERE `News`.`featured` = 1 AND `News`.`status` = 'Published' ORDER BY `News`.`id` DESC LIMIT 5554
2SELECT `News`.`id`, `News`.`title`, `News`.`tagline`, `News`.`game_id`, `News`.`featured`, `News`.`total_comment`, `News`.`created`, `News`.`user_id`, `News`.`news_image`, `News`.`content`, `News`.`status`, `News`.`modified` FROM `noobfsjv_nooblive`.`news` AS `News` WHERE `News`.`status` = 'Published' ORDER BY `News`.`id` DESC LIMIT 3330
3SELECT `News`.`id`, `News`.`title`, `News`.`tagline`, `News`.`game_id`, `News`.`featured`, `News`.`total_comment`, `News`.`created`, `News`.`user_id`, `News`.`news_image`, `News`.`content`, `News`.`status`, `News`.`modified` FROM `noobfsjv_nooblive`.`news` AS `News` WHERE `News`.`status` = 'Published' ORDER BY `News`.`total_comment` DESC LIMIT 3331
4SELECT `Review`.`id`, `Review`.`title`, `Review`.`tagline`, `Review`.`rating`, `Review`.`game_id`, `Review`.`retro`, `Review`.`content`, `Review`.`review_image`, `Review`.`user_id`, `Review`.`featured`, `Review`.`status`, `Review`.`total_comment`, `Review`.`owner`, `Review`.`created`, `Review`.`modified`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`dob`, `User`.`gender`, `User`.`country`, `User`.`time_zone`, `User`.`password`, `User`.`avatar_image`, `User`.`banner_image`, `User`.`signature`, `User`.`show_online`, `User`.`my_sig`, `User`.`newsletter_subscription`, `User`.`other_sig`, `User`.`allow_html`, `User`.`per_page`, `User`.`post_per_page`, `User`.`show_dob`, `User`.`show_email`, `User`.`blog_read`, `User`.`blog_comment`, `User`.`profile_read`, `User`.`status`, `User`.`created`, `User`.`activation_key`, `User`.`activated`, `User`.`level`, `User`.`level_name`, `User`.`level_point`, `User`.`level_time`, `User`.`about_me`, `User`.`penalty`, `User`.`online`, `User`.`log_time`, `User`.`site_writer`, `User`.`visited`, `User`.`last_login`, `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`reviews` AS `Review` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `noobfsjv_nooblive`.`games` AS `Game` ON (`Review`.`game_id` = `Game`.`id`) WHERE `Review`.`status` = 'Published' AND `Game`.`ps3` = 1 ORDER BY `Review`.`id` DESC LIMIT 3330
5SELECT `Preview`.`id`, `Preview`.`title`, `Preview`.`tagline`, `Preview`.`game_id`, `Preview`.`content`, `Preview`.`preview_image`, `Preview`.`user_id`, `Preview`.`status`, `Preview`.`featured`, `Preview`.`total_comment`, `Preview`.`created`, `Preview`.`modified`, `Preview`.`top_image`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`dob`, `User`.`gender`, `User`.`country`, `User`.`time_zone`, `User`.`password`, `User`.`avatar_image`, `User`.`banner_image`, `User`.`signature`, `User`.`show_online`, `User`.`my_sig`, `User`.`newsletter_subscription`, `User`.`other_sig`, `User`.`allow_html`, `User`.`per_page`, `User`.`post_per_page`, `User`.`show_dob`, `User`.`show_email`, `User`.`blog_read`, `User`.`blog_comment`, `User`.`profile_read`, `User`.`status`, `User`.`created`, `User`.`activation_key`, `User`.`activated`, `User`.`level`, `User`.`level_name`, `User`.`level_point`, `User`.`level_time`, `User`.`about_me`, `User`.`penalty`, `User`.`online`, `User`.`log_time`, `User`.`site_writer`, `User`.`visited`, `User`.`last_login`, `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`previews` AS `Preview` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`Preview`.`user_id` = `User`.`id`) LEFT JOIN `noobfsjv_nooblive`.`games` AS `Game` ON (`Preview`.`game_id` = `Game`.`id`) WHERE `Game`.`ps3` = 1 ORDER BY `Preview`.`id` DESC LIMIT 3330
6SELECT `Game`.`id`, `Game`.`title`, `Game`.`boxart`, `Game`.`youtube_url` FROM `noobfsjv_nooblive`.`games` AS `Game` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`Game`.`user_id` = `User`.`id`) WHERE `Game`.`ps3` = 1 AND `Game`.`youtube_url` != '' ORDER BY `Game`.`id` DESC LIMIT 3330
7SELECT `Feature`.`id`, `Feature`.`title`, `Feature`.`tagline`, `Feature`.`game_id`, `Feature`.`content`, `Feature`.`feature_image`, `Feature`.`user_id`, `Feature`.`status`, `Feature`.`featured`, `Feature`.`total_comment`, `Feature`.`created`, `Feature`.`modified`, `Feature`.`top_image`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`dob`, `User`.`gender`, `User`.`country`, `User`.`time_zone`, `User`.`password`, `User`.`avatar_image`, `User`.`banner_image`, `User`.`signature`, `User`.`show_online`, `User`.`my_sig`, `User`.`newsletter_subscription`, `User`.`other_sig`, `User`.`allow_html`, `User`.`per_page`, `User`.`post_per_page`, `User`.`show_dob`, `User`.`show_email`, `User`.`blog_read`, `User`.`blog_comment`, `User`.`profile_read`, `User`.`status`, `User`.`created`, `User`.`activation_key`, `User`.`activated`, `User`.`level`, `User`.`level_name`, `User`.`level_point`, `User`.`level_time`, `User`.`about_me`, `User`.`penalty`, `User`.`online`, `User`.`log_time`, `User`.`site_writer`, `User`.`visited`, `User`.`last_login`, `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`features` AS `Feature` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`Feature`.`user_id` = `User`.`id`) LEFT JOIN `noobfsjv_nooblive`.`games` AS `Game` ON (`Feature`.`game_id` = `Game`.`id`) WHERE `Feature`.`status` = 'Published' ORDER BY `Feature`.`id` DESC LIMIT 4443
8SELECT `Blog`.`id`, `Blog`.`category_id`, `Blog`.`title`, `Blog`.`tagline`, `Blog`.`game_id`, `Blog`.`content`, `Blog`.`blog_image`, `Blog`.`user_id`, `Blog`.`owner`, `Blog`.`status`, `Blog`.`featured`, `Blog`.`total_comment`, `Blog`.`created`, `Blog`.`modified`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`dob`, `User`.`gender`, `User`.`country`, `User`.`time_zone`, `User`.`password`, `User`.`avatar_image`, `User`.`banner_image`, `User`.`signature`, `User`.`show_online`, `User`.`my_sig`, `User`.`newsletter_subscription`, `User`.`other_sig`, `User`.`allow_html`, `User`.`per_page`, `User`.`post_per_page`, `User`.`show_dob`, `User`.`show_email`, `User`.`blog_read`, `User`.`blog_comment`, `User`.`profile_read`, `User`.`status`, `User`.`created`, `User`.`activation_key`, `User`.`activated`, `User`.`level`, `User`.`level_name`, `User`.`level_point`, `User`.`level_time`, `User`.`about_me`, `User`.`penalty`, `User`.`online`, `User`.`log_time`, `User`.`site_writer`, `User`.`visited`, `User`.`last_login`, `BlogCategory`.`id`, `BlogCategory`.`category`, `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`blogs` AS `Blog` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `noobfsjv_nooblive`.`blog_categories` AS `BlogCategory` ON (`Blog`.`category_id` = `BlogCategory`.`id`) LEFT JOIN `noobfsjv_nooblive`.`games` AS `Game` ON (`Blog`.`game_id` = `Game`.`id`) WHERE `Blog`.`featured` = 1 AND `Blog`.`status` = 'Published' ORDER BY `Blog`.`id` DESC LIMIT 4440
9SELECT `User`.`id`, `User`.`username` FROM `noobfsjv_nooblive`.`users` AS `User` WHERE 1 = 1 ORDER BY `User`.`id` DESC150215021
10SELECT `User`.`id`, `User`.`avatar_image` FROM `noobfsjv_nooblive`.`users` AS `User` WHERE 1 = 1 ORDER BY `User`.`id` DESC150215021
11SELECT `Ad`.`id`, `Ad`.`status`, `Ad`.`mobile`, `Ad`.`vita`, `Ad`.`3ds`, `Ad`.`wii`, `Ad`.`pc`, `Ad`.`ps3`, `Ad`.`xbox360`, `Ad`.`Manage`, `Ad`.`Poll`, `Ad`.`User`, `Ad`.`Feature`, `Ad`.`Blog`, `Ad`.`Review`, `Ad`.`Preview`, `Ad`.`News`, `Ad`.`Page`, `Ad`.`ad_image`, `Ad`.`text`, `Ad`.`js`, `Ad`.`link`, `Ad`.`category`, `Ad`.`expire_date`, `Ad`.`summary`, `Ad`.`price`, `Ad`.`serial_no`, `Ad`.`created`, `Ad`.`modified` FROM `noobfsjv_nooblive`.`ads` AS `Ad` WHERE `Ad`.`category` = 'rightpane_big' AND `Ad`.`status` = 'Published' AND `Ad`.`Page` = '1' ORDER BY `Ad`.`id` DESC LIMIT 1110
12SELECT `Ad`.`id`, `Ad`.`status`, `Ad`.`mobile`, `Ad`.`vita`, `Ad`.`3ds`, `Ad`.`wii`, `Ad`.`pc`, `Ad`.`ps3`, `Ad`.`xbox360`, `Ad`.`Manage`, `Ad`.`Poll`, `Ad`.`User`, `Ad`.`Feature`, `Ad`.`Blog`, `Ad`.`Review`, `Ad`.`Preview`, `Ad`.`News`, `Ad`.`Page`, `Ad`.`ad_image`, `Ad`.`text`, `Ad`.`js`, `Ad`.`link`, `Ad`.`category`, `Ad`.`expire_date`, `Ad`.`summary`, `Ad`.`price`, `Ad`.`serial_no`, `Ad`.`created`, `Ad`.`modified` FROM `noobfsjv_nooblive`.`ads` AS `Ad` WHERE `Ad`.`category` = 'rightpane_small' AND `Ad`.`status` = 'Published' AND `Ad`.`Page` = '1' ORDER BY `Ad`.`id` DESC LIMIT 1110
13SELECT `Ad`.`id`, `Ad`.`status`, `Ad`.`mobile`, `Ad`.`vita`, `Ad`.`3ds`, `Ad`.`wii`, `Ad`.`pc`, `Ad`.`ps3`, `Ad`.`xbox360`, `Ad`.`Manage`, `Ad`.`Poll`, `Ad`.`User`, `Ad`.`Feature`, `Ad`.`Blog`, `Ad`.`Review`, `Ad`.`Preview`, `Ad`.`News`, `Ad`.`Page`, `Ad`.`ad_image`, `Ad`.`text`, `Ad`.`js`, `Ad`.`link`, `Ad`.`category`, `Ad`.`expire_date`, `Ad`.`summary`, `Ad`.`price`, `Ad`.`serial_no`, `Ad`.`created`, `Ad`.`modified` FROM `noobfsjv_nooblive`.`ads` AS `Ad` WHERE `Ad`.`category` = 'header' AND `Ad`.`status` = 'Published' AND `Ad`.`Page` = '1' ORDER BY `Ad`.`id` DESC LIMIT 1110
14SELECT `News`.`id`, `News`.`title`, `News`.`tagline`, `News`.`game_id`, `News`.`featured`, `News`.`total_comment`, `News`.`created`, `News`.`user_id`, `News`.`news_image`, `News`.`content`, `News`.`status`, `News`.`modified`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`dob`, `User`.`gender`, `User`.`country`, `User`.`time_zone`, `User`.`password`, `User`.`avatar_image`, `User`.`banner_image`, `User`.`signature`, `User`.`show_online`, `User`.`my_sig`, `User`.`newsletter_subscription`, `User`.`other_sig`, `User`.`allow_html`, `User`.`per_page`, `User`.`post_per_page`, `User`.`show_dob`, `User`.`show_email`, `User`.`blog_read`, `User`.`blog_comment`, `User`.`profile_read`, `User`.`status`, `User`.`created`, `User`.`activation_key`, `User`.`activated`, `User`.`level`, `User`.`level_name`, `User`.`level_point`, `User`.`level_time`, `User`.`about_me`, `User`.`penalty`, `User`.`online`, `User`.`log_time`, `User`.`site_writer`, `User`.`visited`, `User`.`last_login`, `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`news` AS `News` LEFT JOIN `noobfsjv_nooblive`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `noobfsjv_nooblive`.`games` AS `Game` ON (`News`.`game_id` = `Game`.`id`) WHERE `News`.`status` = 'Published' ORDER BY `News`.`id` DESC LIMIT 4440
15SELECT `NewsComment`.`id`, `NewsComment`.`news_id`, `NewsComment`.`user_id`, `NewsComment`.`content`, `NewsComment`.`created`, `NewsComment`.`modified` FROM `noobfsjv_nooblive`.`news_comments` AS `NewsComment` WHERE `NewsComment`.`news_id` IN (2198, 2197, 2196, 2195) 000
16SELECT `Event`.`id`, `Event`.`name`, `Event`.`event_image`, `Event`.`summary`, `Event`.`link`, `Event`.`tergetdate`, `Event`.`status`, `Event`.`created`, `Event`.`modified` FROM `noobfsjv_nooblive`.`events` AS `Event` WHERE `Event`.`status` = 'Published' ORDER BY `Event`.`id` DESC LIMIT 1000
17SELECT `Poll`.`id`, `Poll`.`topic`, `Poll`.`option1`, `Poll`.`option2`, `Poll`.`option3`, `Poll`.`option4`, `Poll`.`option5`, `Poll`.`option6`, `Poll`.`option7`, `Poll`.`option8`, `Poll`.`created`, `Poll`.`modified`, `Poll`.`topic_id` FROM `noobfsjv_nooblive`.`polls` AS `Poll` WHERE 1 = 1 ORDER BY `Poll`.`id` DESC LIMIT 1110
18SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`xbox360`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
19SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`ps3`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
20SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`pc`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
21SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`wii`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
22SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`3ds`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
23SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`vita`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
24SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`mobile`="1" ORDER BY `Game`.`rating` DESC LIMIT 6660
25SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE 1 = 1 ORDER BY `Game`.`rating` DESC LIMIT 6660
26SELECT `News`.`id`, `News`.`title`, `News`.`tagline`, `News`.`game_id`, `News`.`featured`, `News`.`total_comment`, `News`.`created`, `News`.`user_id`, `News`.`news_image`, `News`.`content`, `News`.`status`, `News`.`modified` FROM `noobfsjv_nooblive`.`news` AS `News` WHERE `News`.`status` = 'Published' ORDER BY `News`.`id` DESC LIMIT 8880
27SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`release_date` < '2014-11-26' ORDER BY `Game`.`rating` DESC LIMIT 8880
28SELECT `Game`.`id`, `Game`.`title`, `Game`.`rating`, `Game`.`xbox360`, `Game`.`ps3`, `Game`.`pc`, `Game`.`wii`, `Game`.`3ds`, `Game`.`vita`, `Game`.`mobile`, `Game`.`publishers`, `Game`.`developers`, `Game`.`genres`, `Game`.`themes`, `Game`.`release_date`, `Game`.`coming_soon`, `Game`.`boxart`, `Game`.`banner`, `Game`.`youtube_url`, `Game`.`featured`, `Game`.`status`, `Game`.`user_id`, `Game`.`created`, `Game`.`modified` FROM `noobfsjv_nooblive`.`games` AS `Game` WHERE `Game`.`release_date` > '2014-11-26' ORDER BY `Game`.`id` DESC LIMIT 8880