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

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

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

SELECT option_name, option_value FROM wp_options WHERE option_name IN
('_transient_jetpack_connection_active_plugins_refresh','_transient_timeout_jetpack_connection_active_plugins_refresh');

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

SELECT option_name, option_value FROM wp_options WHERE option_name IN
('_site_transient_wp_theme_files_patterns-4627ba0da0d6650a49a69534b3e70b8d','_site_transient_timeout_wp_theme_files_patterns-4627ba0da0d6650a49a69534b3e70b8d');

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

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

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

SELECT option_value FROM wp_options WHERE option_name = 'featured-content' LIMIT 1;

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, 10;

SELECT FOUND_ROWS();

SELECT wp_posts.* FROM wp_posts WHERE ID IN (1);

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1) ORDER BY meta_id ASC;

SELECT DISTINCT t.term_id, tr.object_id
			 FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.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 (1)
			 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 t.term_id IN (1);

SELECT  t.term_id
			 FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			 WHERE tt.taxonomy IN ('wp_theme') AND t.name IN ('twentyfourteen')
			 
			 LIMIT 1;

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

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

SELECT   wp_posts.*
					 FROM wp_posts 
					 WHERE 1=1  AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
					 
					 ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC
					 ;

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;

SELECT * FROM wp_users WHERE ID IN (1);

SELECT   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  wp_comments.comment_ID
			 FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID
			 WHERE ( comment_approved = '1' ) AND comment_type NOT IN ('note') AND  wp_posts.post_status IN ('publish')
			 
			 ORDER BY wp_comments.comment_date_gmt DESC
			 LIMIT 0,5;

SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (1);

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 ;

SELECT  t.term_id
			 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 tt.count > 0
			 ORDER BY t.name ASC
			 ;