Nintendo Direct 2/22/12 Live-Blog [UPDATE: It's over]

SELECT option_value FROM wp_options WHERE option_name = 'jetpack_id' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'jwl_options_group8' LIMIT 1;

SELECT wp_terms.term_id,wp_terms.name,wp_terms.slug FROM wp_terms,wp_term_taxonomy WHERE wp_terms.term_id = wp_term_taxonomy.term_id AND
wp_term_taxonomy.taxonomy = 'category'  AND wp_term_taxonomy.count > 0 ORDER BY wp_terms.name ASC;

SELECT wp_terms.term_id,wp_terms.name,wp_terms.slug FROM wp_terms,wp_term_taxonomy WHERE wp_terms.term_id = wp_term_taxonomy.term_id AND
wp_term_taxonomy.taxonomy = 'category'  AND wp_term_taxonomy.count > 0 ORDER BY wp_terms.name ASC;

SELECT wp_posts.ID,wp_posts.post_title FROM wp_posts WHERE wp_posts.post_type = 'page' AND wp_posts.post_status = 'publish' ORDER BY
wp_posts.post_title ASC;

SELECT option_value FROM wp_options WHERE option_name = 'widget_akismet_widget' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_blog_subscription' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_facebook-likebox' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_grofile' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_image' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_jetpack_readmill_widget' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_rss_links' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_top-posts' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_stats_topposts' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_twitter_timeline' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'widget_twitter' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'tweet_this_db_version' LIMIT 1;

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts.post_date)='2' AND
DAYOFMONTH(wp_posts.post_date)='21' AND wp_posts.post_name = 'nintendo-direct-22212-live-blog' AND wp_posts.post_type = 'post'  ORDER BY
wp_posts.post_date DESC ;

SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (39363) ORDER BY t.name
ASC;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (39363);

SELECT   wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'safecss' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date
DESC LIMIT 0, 1;

SELECT option_value FROM wp_options WHERE option_name = 'safecss_add' LIMIT 1;

SELECT * FROM wp_users WHERE ID = '146';

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (146);

SELECT option_value FROM wp_options WHERE option_name = 'disqus_cc_fix' LIMIT 1;

SELECT p.id FROM wp_posts AS p  WHERE p.post_date < '2012-02-21 21:17:54' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date
DESC LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 39349 LIMIT 1;

SELECT p.id FROM wp_posts AS p  WHERE p.post_date > '2012-02-21 21:17:54' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date
ASC LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 39405 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 39364 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (39364);

SELECT option_value FROM wp_options WHERE option_name = 'safecss_revision_migrated' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'safecss' LIMIT 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.term_id = 4133
LIMIT 1;

SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy
IN ('nav_menu') AND tt.term_id IN ('4133') ORDER BY tr.object_id ASC;

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (30832,30833,30834,33837) AND wp_posts.post_type = 'nav_menu_item' AND
(wp_posts.post_status = 'publish')  ORDER BY wp_posts.menu_order ASC ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33837,30832,30833,30834);

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (22999,2573,4887,2) AND wp_posts.post_type = 'page' AND (wp_posts.post_status =
'publish')  ORDER BY wp_posts.post_date DESC ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (22999,4887,2573,2);

SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (39363) ORDER BY t.name ASC;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.term_id = 2582
LIMIT 1;

SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy
IN ('nav_menu') AND tt.term_id IN ('2582') ORDER BY tr.object_id ASC;

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (30642,30648,30649,30650,30652,30653,32387,37034,46432) AND wp_posts.post_type =
'nav_menu_item' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.menu_order ASC ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (30652,32387,30642,30649,30648,30650,30653,37034,46432);

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND ( t.term_id = 86
 OR t.term_id = 4182  OR t.term_id = 2416  OR t.term_id = 9  OR t.term_id = 4113  OR t.term_id = 519  OR t.term_id = 65  OR t.term_id = 2  OR
t.term_id = 4115 ) ORDER BY t.name ASC ;

SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (39363) ORDER BY t.name ASC;

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY
wp_posts.post_date DESC LIMIT 0, 5;

SELECT FOUND_ROWS();

SELECT wp_posts.* FROM wp_posts WHERE ID IN (46680,46625,46637,46661,46649);

SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (46625, 46637, 46649,
46661, 46680) ORDER BY t.name ASC;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (46625,46637,46649,46661,46680);

SELECT * FROM wp_posts WHERE ID = 36303 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (36303);

SELECT * FROM wp_users WHERE ID = '171';

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (171);

SELECT * FROM wp_posts WHERE ID = 46672 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (46672);

SELECT * FROM wp_posts WHERE ID = 46670 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (46670);

SELECT * FROM wp_users WHERE ID = '167';

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (167);

SELECT * FROM wp_posts WHERE ID = 46662 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (46662);

SELECT * FROM wp_posts WHERE ID = 46318 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (46318);

SELECT * FROM wp_comments JOIN wp_posts ON ID = comment_post_ID WHERE comment_approved = '1' AND post_status = 'publish' AND post_password ='' AND
comment_type = '' ORDER BY comment_date DESC LIMIT 5;

SELECT * FROM wp_posts WHERE ID = 37595 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 46480 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 46611 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 4797 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 46546 LIMIT 1;

SELECT ID, post_title, comment_count, post_date FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post' AND MONTH(post_date) = MONTH(NOW())
AND YEAR(post_date) = YEAR(NOW()) AND comment_count > 0 ORDER BY comment_count DESC LIMIT 5;

SELECT * FROM wp_posts WHERE ID = 46462 LIMIT 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (46462) ORDER BY t.name ASC;

SELECT * FROM wp_posts WHERE ID = 46428 LIMIT 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (46428) ORDER BY t.name ASC;

SELECT * FROM wp_posts WHERE ID = 46583 LIMIT 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (46583) ORDER BY t.name ASC;

SELECT * FROM wp_posts WHERE ID = 46543 LIMIT 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (46543) ORDER BY t.name ASC;

SELECT * FROM wp_posts WHERE ID = 44753 LIMIT 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (44753) ORDER BY t.name ASC;

SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_feed_bfd0132476f9857303465e48f0778f2c' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = '_transient_feed_bfd0132476f9857303465e48f0778f2c' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_feed_mod_bfd0132476f9857303465e48f0778f2c' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = '_transient_feed_mod_bfd0132476f9857303465e48f0778f2c' LIMIT 1;

SELECT pollq_active FROM wp_pollsq WHERE pollq_id = 59;

SELECT pollip_aid FROM wp_pollsip WHERE pollip_qid = 59 AND pollip_ip = '107.22.25.119' ;

SELECT pollq_id, pollq_question, pollq_totalvotes, pollq_timestamp, pollq_expiry, pollq_multiple, pollq_totalvoters FROM wp_pollsq WHERE pollq_id = 59
LIMIT 1;

SELECT polla_aid, polla_answers, polla_votes FROM wp_pollsa WHERE polla_qid = 59 ORDER BY polla_aid asc;

SELECT * FROM wp_comments  WHERE ( comment_approved = '0' OR comment_approved = '1' ) AND comment_post_ID = 39363  ORDER BY comment_date_gmt DESC ;

SELECT option_value FROM wp_options WHERE option_name = 'disqus_active' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'text_direction' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'disabled_likes' LIMIT 1;

SELECT * FROM wp_comments  WHERE comment_approved = '1' AND comment_post_ID = 39363  ORDER BY comment_date_gmt ASC ;

SELECT option_value FROM wp_options WHERE option_name = 'disqus_disable_ssr' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'disqus_manual_sync' LIMIT 1;