callia – Понемножку about viską

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

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

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

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

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

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

select count(*) from wp_gdsr_ips where `status` = 'B' and `mode` = 'S' and `ip` = '54.81.166.196';

select count(*) from wp_gdsr_ips where `status` = 'B' and `mode` = 'R' and inet_aton(substring_index(ip, '|', 1)) <= inet_aton('54.81.166.196') and
inet_aton(substring_index(ip, '|', -1)) >= inet_aton('54.81.166.196');

select ip from wp_gdsr_ips where `status` = 'B' and `mode` = 'M';

SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_groups.position AS group_pos,wp_redirection_modules.id AS module_id FROM
wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND
wp_redirection_groups.status='enabled' INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND
wp_redirection_modules.type='wp' WHERE( wp_redirection_items.regex=1 OR wp_redirection_items.url='/tag/bullshit-bingo/');

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

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

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

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

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

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

					SELECT wp_term_taxonomy.term_taxonomy_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'post_tag'
					AND wp_terms.slug IN ('bullshit-bingo')
				;

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 ('post_tag') AND t.slug =
'bullshit-bingo'  LIMIT 1;

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 
AND ( 
  wp_term_relationships.term_taxonomy_id IN (637)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;

SELECT FOUND_ROWS();

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

SELECT  t.*, tt.*, 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 (4688) ORDER BY t.name
ASC ;

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

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 option_value FROM wp_options WHERE option_name = 'verification_services_codes' LIMIT 1;

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

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

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

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 * FROM wp_posts  WHERE (post_type = 'page' AND post_status = 'publish')     ORDER BY menu_order 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 IN ('category') ORDER BY t.name
ASC ;

SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (424,8,6,139,70,1,421,127,425,119,52,423,10,427,53) ORDER BY meta_id ASC;

SELECT * FROM wp_users WHERE ID = '1';

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

SELECT * FROM wp_gdsr_data_article WHERE post_id in (4688);

select p.ID as ID, count(l.record_id) as counter from wp_posts p left join wp_gdsr_moderate l on l.id = p.ID and l.vote_type = 'article' and ip =
'54.81.166.196' where p.ID in (4688) group by p.ID;

select p.ID as ID, count(l.record_id) as counter from wp_posts p left join wp_gdsr_votes_log l on l.id = p.ID and l.vote_type = 'article' and ip =
'54.81.166.196' where p.ID in (4688) group by p.ID;

select p.ID as ID, count(l.record_id) as counter from wp_posts p left join wp_gdsr_moderate l on l.id = p.ID and l.vote_type = 'artthumb' and ip =
'54.81.166.196' where p.ID in (4688) group by p.ID;

select p.ID as ID, count(l.record_id) as counter from wp_posts p left join wp_gdsr_votes_log l on l.id = p.ID and l.vote_type = 'artthumb' and ip =
'54.81.166.196' where p.ID in (4688) group by p.ID;

SELECT * FROM wp_gdsr_templates WHERE `template_id` = 50;

SELECT * FROM wp_gdsr_templates WHERE `template_id` = 45;

SELECT * FROM wp_gdsr_templates WHERE `template_id` = 46;

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

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

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

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

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

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

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

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

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

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

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

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

SELECT id, title, imdb_url_short, rotten_url, obuolys_url, rating, review, replacement_url, DATE_FORMAT(watched_on, '%Y-%m-%d %H:%i') AS watched_on,
DATE_FORMAT(added_on, '%Y-%m-%d %H:%i') AS added_on FROM wp_movie_ratings  ORDER BY watched_on DESC, watched_on DESC  LIMIT 0, 30;;

SELECT COUNT(id) AS count FROM wp_movie_ratings ;

SELECT COUNT(id) AS count FROM wp_movie_ratings ;

SELECT COUNT(id) AS count FROM wp_movie_ratings ;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT TO_DAYS(watched_on) FROM wp_movie_ratings WHERE id=6;;

SELECT TO_DAYS(watched_on) FROM wp_movie_ratings WHERE id=320;;

SELECT (COUNT(id)/6403) AS count FROM wp_movie_ratings ;

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE watched_on >= '2018-03-24';

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE watched_on >= '2018-04-16';

SELECT AVG(rating) FROM wp_movie_ratings;

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE MONTH(watched_on)=4 AND YEAR(watched_on)=2018;

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE MONTH(watched_on)=3 AND YEAR(watched_on)=2018;

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE YEAR(watched_on)=2018;

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE YEAR(watched_on)=2017;

SELECT COUNT(id) AS count FROM wp_movie_ratings ;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT watched_on, id, title FROM wp_movie_ratings WHERE id=6;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT watched_on, id, title FROM wp_movie_ratings WHERE id=6;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT watched_on, id, title FROM wp_movie_ratings WHERE id=6;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT watched_on, id, title FROM wp_movie_ratings WHERE id=320;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT watched_on, id, title FROM wp_movie_ratings WHERE id=320;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on ASC LIMIT 1;;

SELECT id FROM wp_movie_ratings ORDER BY watched_on DESC LIMIT 1;;

SELECT watched_on, id, title FROM wp_movie_ratings WHERE id=320;;

Select * from wp_social_links_sidebar order by sort_order;

SELECT id, title, imdb_url_short, rotten_url, obuolys_url, rating, review, replacement_url, DATE_FORMAT(watched_on, '%Y-%m-%d %H:%i') AS watched_on,
DATE_FORMAT(added_on, '%Y-%m-%d %H:%i') AS added_on FROM wp_movie_ratings  ORDER BY watched_on DESC, watched_on DESC  LIMIT 10;

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

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 
wp_posts.post_status IN ('publish')  ORDER BY wp_comments.comment_date_gmt DESC LIMIT 5;

SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (31085,31084,22675,22280,22232);

SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (22232,22280,22675,31084,31085) ORDER BY meta_id ASC;

SELECT wp_posts.* FROM wp_posts WHERE ID IN (2816,4168,3138,2121);

SELECT  COUNT(*) FROM wp_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 2816 AND comment_parent = 0 AND ( 
  wp_comments.comment_date_gmt < '2016-12-02 19:37:18'
)  ORDER BY wp_comments.comment_date_gmt DESC ;

SELECT  COUNT(*) FROM wp_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 4168 AND comment_parent = 0 AND ( 
  wp_comments.comment_date_gmt < '2016-06-09 15:17:15'
)  ORDER BY wp_comments.comment_date_gmt DESC ;

SELECT  COUNT(*) FROM wp_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 2816 AND comment_parent = 0 AND ( 
  wp_comments.comment_date_gmt < '2014-04-01 07:38:42'
)  ORDER BY wp_comments.comment_date_gmt DESC ;

SELECT  COUNT(*) FROM wp_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 3138 AND comment_parent = 0 AND ( 
  wp_comments.comment_date_gmt < '2014-03-17 14:47:49'
)  ORDER BY wp_comments.comment_date_gmt DESC ;

SELECT  COUNT(*) FROM wp_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 2121 AND comment_parent = 0 AND ( 
  wp_comments.comment_date_gmt < '2014-03-15 20:46:27'
)  ORDER BY wp_comments.comment_date_gmt DESC ;

SELECT *    FROM wp_links  WHERE 1=1 AND link_visible = 'Y'     ORDER BY link_name ASC;

SELECT wp_terms.slug, wp_posts.ID,
    wp_posts.post_name, wp_posts.post_title, wp_posts.post_author,
    wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
    MONTH(wp_posts.post_date) AS 'month' ,
    wp_posts.post_type
    FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
    wp_term_relationships.object_id 
		LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
																			wp_term_relationships.term_taxonomy_id
		LEFT JOIN wp_terms ON wp_terms.term_id = 
		                          wp_term_taxonomy.term_id 
  WHERE post_status='publish' AND wp_posts.post_type='post'   
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC;