Skip to content

Instantly share code, notes, and snippets.

@roccogalluzzo
Created May 13, 2010 15:57
Show Gist options
  • Save roccogalluzzo/399990 to your computer and use it in GitHub Desktop.
Save roccogalluzzo/399990 to your computer and use it in GitHub Desktop.
144 Query SET NAMES utf8
144 Init DB wordpress
144 Query SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
144 Query SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1
144 Query SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
144 Query SELECT SQL_CALC_FOUND_ROWS wp_posts.* 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, 10
144 Query SELECT FOUND_ROWS()
144 Query 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') AND tr.object_id IN (4, 1) ORDER BY t.name ASC
144 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4,1)
144 Query SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_image' LIMIT 1
144 Query SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_color' LIMIT 1
144 Query SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_display' LIMIT 1
144 Query SELECT * FROM wp_users WHERE ID = 1 LIMIT 1
144 Query SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1
144 Query SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order, post_title ASC
144 Query SELECT option_value FROM wp_options WHERE option_name = 'page_for_posts' LIMIT 1
144 Query SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
144 Query 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') ORDER BY t.name ASC
144 Query 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 ('link_category') AND tt.count > 0 ORDER BY t.name ASC
144 Query SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 2 ) AND taxonomy = 'link_category' ORDER BY link_name ASC
144 Quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment