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

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

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

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

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

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='/2009/08/09/wordpress-com-stats-perkelimas/');

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

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2009' AND MONTH(wp_posts.post_date)='8' AND
DAYOFMONTH(wp_posts.post_date)='9' AND wp_posts.post_name = 'wordpress-com-stats-perkelimas' 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 (1260) ORDER BY t.name
ASC;

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

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

SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2009-08-09 12:33:29' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date
DESC LIMIT 1;

SELECT p.* FROM wp_posts AS p  WHERE p.post_date > '2009-08-09 12:33:29' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date
ASC LIMIT 1;

SELECT * FROM wp_users WHERE ID = '1';

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

SELECT * FROM wp_gdsr_data_article WHERE post_id = 1260;

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

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

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (2,1408,185,2440,2430);

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 * FROM wp_gdsr_data_article WHERE post_id in (1260);

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 =
'38.107.179.206' where p.ID in (1260) 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 =
'38.107.179.206' where p.ID in (1260) 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 =
'38.107.179.206' where p.ID in (1260) 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 =
'38.107.179.206' where p.ID in (1260) 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;

update wp_gdpt_posts_views set vst_views = vst_views + 1 where post_id = 1260 and day = '2012-02-11';

insert into wp_gdpt_posts_views (post_id, day, vst_views) values (1260, '2012-02-11', 1);

update wp_gdsr_data_article set views = views + 1 where post_id = 1260;

select * from wp_gdsr_multis where auto_insert != 'none';

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=196;;

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

SELECT COUNT(id) AS count FROM wp_movie_ratings WHERE watched_on >= '2012-01-12';

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

SELECT AVG(rating) FROM wp_movie_ratings;

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

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

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

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

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=196;;

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=196;;

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=196;;

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

select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 1260;

 SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, yarpp.score FROM wp_posts  join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1  AND
yarpp.score >= 5 and yarpp.reference_ID = 1260 AND wp_posts.post_type IN ('post')  ORDER BY wp_posts.post_date DESC  limit 5 ;

SELECT FOUND_ROWS();

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 (1090) ORDER BY t.name
ASC;

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

SELECT * FROM wp_gdsr_data_article WHERE post_id in (1090);

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 =
'38.107.179.206' where p.ID in (1090) 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 =
'38.107.179.206' where p.ID in (1090) 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 =
'38.107.179.206' where p.ID in (1090) 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 =
'38.107.179.206' where p.ID in (1090) group by p.ID;

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

SELECT * FROM wp_gdsr_data_comment WHERE post_id = 1260;

select p.comment_ID as ID, count(l.record_id) as counter from wp_comments p left join wp_gdsr_moderate l on l.id = p.comment_ID and l.vote_type =
'comment' and ip = '38.107.179.206' where p.comment_ID in (137, 138, 140, 142, 143) group by p.comment_ID;

select p.comment_ID as ID, count(l.record_id) as counter from wp_comments p left join wp_gdsr_votes_log l on l.id = p.comment_ID and l.vote_type =
'comment' and ip = '38.107.179.206' where p.comment_ID in (137, 138, 140, 142, 143) group by p.comment_ID;

select p.comment_ID as ID, count(l.record_id) as counter from wp_comments p left join wp_gdsr_moderate l on l.id = p.comment_ID and l.vote_type =
'cmmthumb' and ip = '38.107.179.206' where p.comment_ID in (137, 138, 140, 142, 143) group by p.comment_ID;

select p.comment_ID as ID, count(l.record_id) as counter from wp_comments p left join wp_gdsr_votes_log l on l.id = p.comment_ID and l.vote_type =
'cmmthumb' and ip = '38.107.179.206' where p.comment_ID in (137, 138, 140, 142, 143) group by p.comment_ID;

SELECT * FROM wp_gdsr_templates WHERE `template_id` = 26;

SELECT * FROM wp_gdsr_templates WHERE `template_id` = 24;

SELECT * FROM wp_gdsr_templates WHERE `template_id` = 1;

DESC wp_comments;

Select * from wp_social_links_sidebar order by sort_order;

 SELECT   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, 5;

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 (4991, 4935, 4909, 4896,
4836) ORDER BY t.name ASC;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4991,4935,4909,4896,4836);

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

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 4168 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2012-01-24 16:56:47';

SELECT * FROM wp_posts WHERE ID = 4168 LIMIT 1;

SELECT * FROM wp_comments WHERE comment_ID = 6071 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1090 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-10-19 21:31:24';

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1090 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-10-19 21:31:24';

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 4803 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-07-31 09:32:07';

SELECT * FROM wp_posts WHERE ID = 4803 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 4991 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2011-06-15 05:04:05';

UPDATE `wp_options` SET `option_value` = '57e6bb017860bf93aefccda940c92947' WHERE `option_name` = '_transient_random_seed';

UPDATE `wp_options` SET `option_value` =
'a:1:{s:32:\"4915792e653474fbae1f09420aa383f6\";a:1:{i:1328920144;a:10:{i:0;a:4:{s:7:\"post_id\";s:1:\"0\";s:10:\"post_title\";s:9:\"Home
page\";s:14:\"post_permalink\";s:21:\"http://www.callia.lt/\";s:5:\"views\";s:3:\"659\";}i:1;a:4:{s:7:\"post_id\";s:4:\"2998\";s:10:\"post_title\";s:35:\"Microsoft
egzaminai ir
sertifikatai\";s:14:\"post_permalink\";s:68:\"http://www.callia.lt/2009/11/30/microsoft-egzaminai-ir-sertifikatai/\";s:5:\"views\";s:3:\"227\";}i:2;a:4:{s:7:\"post_id\";s:4:\"3704\";s:10:\"post_title\";s:22:\"Kita
svajonių
komanda\";s:14:\"post_permalink\";s:54:\"http://www.callia.lt/2010/02/22/kita-svajoniu-komanda/\";s:5:\"views\";s:3:\"221\";}i:3;a:4:{s:7:\"post_id\";s:4:\"4168\";s:10:\"post_title\";s:46:\"Anonsuotas
Džeimso Kamerono \"Avatar 2\"
filmas\";s:14:\"post_permalink\";s:76:\"http://www.callia.lt/2010/04/14/anansuotas-dzeimso-kamerono-avatar-2-filmas/\";s:5:\"views\";s:3:\"209\";}i:4;a:4:{s:7:\"post_id\";s:4:\"2816\";s:10:\"post_title\";s:72:\"Sendaikčių
turgus - mūsų vaikystės žaislai ir kitokie
pričindalai\";s:14:\"post_permalink\";s:96:\"http://www.callia.lt/2009/11/09/sendaikciu-turgus-musu-vaikystes-zaislai-ir-kitokie-pricindalai/\";s:5:\"views\";s:3:\"176\";}i:5;a:4:{s:7:\"post_id\";s:4:\"4518\";s:10:\"post_title\";s:75:\"Filmas
\"Pradžia\" (\"Inception\") - nukrito ar nenukrito? štai kur
klausimas\";s:14:\"post_permalink\";s:57:\"http://www.callia.lt/2010/07/23/filmas-pradzia-inception/\";s:5:\"views\";s:3:\"131\";}i:6;a:4:{s:7:\"post_id\";s:3:\"185\";s:10:\"post_title\";s:6:\"Filmai\";s:14:\"post_permalink\";s:28:\"http://www.callia.lt/filmai/\";s:5:\"views\";s:2:\"70\";}i:7;a:4:{s:7:\"post_id\";s:3:\"443\";s:10:\"post_title\";s:32:\"Apie
greitojo skaitymo
techniką\";s:14:\"post_permalink\";s:59:\"http://www.callia.lt/2009/06/13/greitojo-skaitymo-technika/\";s:5:\"views\";s:2:\"56\";}i:8;a:4:{s:7:\"post_id\";s:4:\"2121\";s:10:\"post_title\";s:85:\"Filmas
\"Basomis per grindinį\" (\"Barefoot\") - ir dar šiek tiek apie vokiškus
filmus\";s:14:\"post_permalink\";s:107:\"http://www.callia.lt/2009/10/05/filmas-basomis-per-grindini-barefoot-ir-dar-siek-tiek-apie-vokiskus-filmus/\";s:5:\"views\";s:2:\"47\";}i:9;a:4:{s:7:\"post_id\";s:4:\"3138\";s:10:\"post_title\";s:41:\"Keli
įdomūs faktai apie filmą
\"Avatar\"\";s:14:\"post_permalink\";s:69:\"http://www.callia.lt/2009/12/19/keli-idomus-faktai-apie-filma-avatar/\";s:5:\"views\";s:2:\"36\";}}}}'
WHERE `option_name` = 'stats_cache';

SELECT p.id, p.post_title, p.post_author FROM wp_posts AS p WHERE p.id IN (2998,3704,4168,2816,4518,185,443,2121,3138) AND p.post_status != 'draft'
AND p.post_status != 'private' AND p.post_status != 'trash' AND p.post_type = 'post';

SELECT * FROM wp_posts WHERE ID = 2998 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 3704 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 2816 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 4518 LIMIT 1;

UPDATE `wp_options` SET `option_value` = 'a:1:{s:6:\"wppp-3\";a:2:{s:5:\"value\";s:1217:\"
Mėnesio populiariausi -
žiūrėta kartų
\n
\n	
Microsoft egzaminai ir sertifikatai - 227
\n	
Kita svajonių komanda - 221
\n	
Anonsuotas Džeimso Kamerono "Avatar 2" filmas - 209
\n	
Sendaikčių turgus - mūsų vaikystės žaislai ir kitokie pričindalai - 176
\n	
Filmas "Pradžia" ("Inception") - nukrito ar nenukrito? štai kur klausimas -
131
\n
\n\";s:4:\"time\";i:1328920144;}}' WHERE `option_name` = 'wppp_cache';

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 *    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' 
    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_date != '0000-00-00 00:00:00' AND post_status = 'publish' AND post_type = 'post'    
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC;