Exploraciones Sónicas

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'gad_disable_post_stats' LIMIT 1;

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'ossdl_https' LIMIT 1;

SELECT option_value FROM wp_tv0i11_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;

SELECT autoload FROM wp_tv0i11_options WHERE option_name = '_transient_doing_cron';

SELECT autoload FROM wp_tv0i11_options WHERE option_name = '_transient_timeout_doing_cron';

SELECT option_value FROM wp_tv0i11_options WHERE option_name = '_transient_doing_cron' LIMIT 1;

INSERT INTO `wp_tv0i11_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1328669310', 'yes') ON DUPLICATE KEY
UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'al2fb_use_ssp' LIMIT 1;

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

					SELECT wp_tv0i11_term_taxonomy.term_taxonomy_id
					FROM wp_tv0i11_term_taxonomy
					INNER JOIN wp_tv0i11_terms USING (term_id)
					WHERE taxonomy = 'post_tag'
					AND wp_tv0i11_terms.slug IN ('villa-diamante')
				;

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND
t.slug = 'villa-diamante' LIMIT 1;

 SELECT SQL_CALC_FOUND_ROWS  wp_tv0i11_posts.* FROM wp_tv0i11_posts  INNER JOIN wp_tv0i11_term_relationships ON (wp_tv0i11_posts.ID =
wp_tv0i11_term_relationships.object_id) WHERE 1=1  AND ( wp_tv0i11_term_relationships.term_taxonomy_id IN (49) ) AND wp_tv0i11_posts.post_type =
'post' AND (wp_tv0i11_posts.post_status = 'publish') GROUP BY wp_tv0i11_posts.ID ORDER BY wp_tv0i11_posts.post_date DESC LIMIT 0, 16;

SELECT FOUND_ROWS();

SELECT t.*, tt.*, tr.object_id FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN
wp_tv0i11_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 (253) ORDER BY t.name ASC;

SELECT post_id, meta_key, meta_value FROM wp_tv0i11_postmeta WHERE post_id IN (253);

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND
t.slug = 'villa-diamante' LIMIT 1;

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND
t.slug = 'villa-diamante' LIMIT 1;

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER
BY t.name ASC ;

SELECT * FROM wp_tv0i11_users WHERE ID = '2';

SELECT user_id, meta_key, meta_value FROM wp_tv0i11_usermeta WHERE user_id IN (2);

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'linkwithin_single_only' LIMIT 1;

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'al2fb_ssp_info' LIMIT 1;

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'al2fb_noscript' LIMIT 1;

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

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'al2fb_min_cap_comment' LIMIT 1;

SELECT option_value FROM wp_tv0i11_options WHERE option_name = 'al2fb_msg_maxage' LIMIT 1;

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

SELECT * FROM wp_tv0i11_comments JOIN wp_tv0i11_posts ON wp_tv0i11_posts.ID = wp_tv0i11_comments.comment_post_ID WHERE comment_approved = '1' AND
wp_tv0i11_posts.post_status = 'publish' ORDER BY comment_date_gmt DESC LIMIT 5;

SELECT COUNT(comment_ID) FROM wp_tv0i11_comments WHERE comment_post_ID = 1005 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2012-01-02 10:20:30';

SELECT * FROM wp_tv0i11_posts WHERE ID = 1005 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_tv0i11_comments WHERE comment_post_ID = 1005 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-12-31 16:34:35';

SELECT COUNT(comment_ID) FROM wp_tv0i11_comments WHERE comment_post_ID = 2152 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-10-18 13:49:48';

SELECT * FROM wp_tv0i11_posts WHERE ID = 2152 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_tv0i11_comments WHERE comment_post_ID = 2133 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-10-04 14:34:32';

SELECT * FROM wp_tv0i11_posts WHERE ID = 2133 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_tv0i11_comments WHERE comment_post_ID = 2129 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-10-03 17:14:45';

SELECT * FROM wp_tv0i11_posts WHERE ID = 2129 LIMIT 1;

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER
BY t.name ASC ;

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_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 ;

SELECT *    FROM wp_tv0i11_links  INNER JOIN wp_tv0i11_term_relationships AS tr ON (wp_tv0i11_links.link_id = tr.object_id) INNER JOIN
wp_tv0i11_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;

SELECT t.*, tt.* FROM wp_tv0i11_terms AS t INNER JOIN wp_tv0i11_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND
tt.count > 0 ORDER BY tt.count DESC LIMIT 45;

SELECT YEAR(min(post_date_gmt)) AS firstyear, YEAR(max(post_date_gmt)) AS lastyear FROM wp_tv0i11_posts WHERE post_date_gmt > 1970;