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

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

UPDATE `wp_options` SET `option_value` =
'a:5:{i:0;b:0;s:38:\"simple-tags/2.7/simple-tags.client.php\";a:2:{i:0;O:15:\"SimpleTagsAdmin\":11:{s:7:\"version\";s:5:\"1.6.6\";s:4:\"info\";a:4:{s:4:\"home\";s:20:\"http://www.callia.lt\";s:7:\"siteurl\";s:20:\"http://www.callia.lt\";s:11:\"install_url\";s:55:\"http://www.callia.lt/wp-content/plugins/simple-tags/2.7\";s:11:\"install_dir\";s:79:\"/home/callialt/domains/callia.lt/public_html/wp-content/plugins/simple-tags/2.7\";}s:7:\"options\";a:64:{s:13:\"use_tag_pages\";i:1;s:18:\"allow_embed_tcloud\";i:0;s:9:\"no_follow\";i:0;s:14:\"auto_link_tags\";i:0;s:13:\"auto_link_min\";i:1;s:14:\"auto_link_case\";i:1;s:21:\"auto_link_max_by_post\";i:20;s:14:\"use_click_tags\";i:1;s:18:\"use_suggested_tags\";i:1;s:18:\"use_autocompletion\";i:1;s:14:\"use_embed_tags\";i:0;s:16:\"start_embed_tags\";s:6:\"[tags]\";s:14:\"end_embed_tags\";s:7:\"[/tags]\";s:7:\"rp_feed\";i:0;s:11:\"rp_embedded\";s:2:\"no\";s:8:\"rp_order\";s:10:\"count-desc\";s:12:\"rp_limit_qty\";i:5;s:13:\"rp_notagstext\";s:17:\"No
related posts.\";s:8:\"rp_title\";s:22:\"
Related posts
\";s:10:\"rp_xformat\";s:95:\"%post_title%
(%post_comment%)\";s:12:\"rp_adv_usage\";s:0:\"\";s:15:\"cloud_selection\";s:10:\"count-desc\";s:10:\"cloud_sort\";s:6:\"random\";s:15:\"cloud_limit_qty\";i:45;s:16:\"cloud_notagstext\";s:8:\"No
tags.\";s:11:\"cloud_title\";s:18:\"
Tag Cloud
\";s:12:\"cloud_format\";s:4:\"flat\";s:13:\"cloud_xformat\";s:155:\"%tag_name%\";s:15:\"cloud_max_color\";s:7:\"#000000\";s:15:\"cloud_min_color\";s:7:\"#CCCCCC\";s:14:\"cloud_max_size\";i:22;s:14:\"cloud_min_size\";i:8;s:10:\"cloud_unit\";s:2:\"pt\";s:14:\"cloud_inc_cats\";i:0;s:15:\"cloud_adv_usage\";s:0:\"\";s:7:\"tt_feed\";i:0;s:11:\"tt_embedded\";s:2:\"no\";s:12:\"tt_separator\";s:2:\",
\";s:9:\"tt_before\";s:6:\"Tags: \";s:8:\"tt_after\";s:6:\"
\";s:13:\"tt_notagstext\";s:22:\"No tags for this
post.\";s:9:\"tt_number\";i:0;s:11:\"tt_inc_cats\";i:0;s:10:\"tt_xformat\";s:64:\"%tag_name%\";s:12:\"tt_adv_usage\";s:0:\"\";s:9:\"rt_number\";i:5;s:8:\"rt_order\";s:10:\"count-desc\";s:12:\"rt_separator\";s:1:\"
\";s:9:\"rt_format\";s:4:\"list\";s:9:\"rt_method\";s:2:\"OR\";s:8:\"rt_title\";s:21:\"
Related tags
\";s:13:\"rt_notagstext\";s:22:\"No
related tags found.\";s:10:\"rt_xformat\";s:91:\"%tag_count% + %tag_name%\";s:19:\"rt_remove_separator\";s:1:\"
\";s:16:\"rt_remove_format\";s:4:\"list\";s:20:\"rt_remove_notagstext\";s:1:\" \";s:17:\"rt_remove_xformat\";s:105:\"» Remove
%tag_name%\";s:15:\"meta_autoheader\";i:1;s:19:\"meta_always_include\";s:0:\"\";s:17:\"meta_keywords_qty\";i:0;s:13:\"use_auto_tags\";i:0;s:6:\"at_all\";i:0;s:8:\"at_empty\";i:0;s:9:\"auto_list\";s:0:\"\";}s:15:\"default_options\";a:64:{s:13:\"use_tag_pages\";i:1;s:18:\"allow_embed_tcloud\";i:0;s:9:\"no_follow\";i:0;s:14:\"auto_link_tags\";i:0;s:13:\"auto_link_min\";i:1;s:14:\"auto_link_case\";i:1;s:21:\"auto_link_max_by_post\";i:20;s:14:\"use_click_tags\";i:1;s:18:\"use_suggested_tags\";i:1;s:18:\"use_autocompletion\";i:1;s:14:\"use_embed_tags\";i:0;s:16:\"start_embed_tags\";s:6:\"[tags]\";s:14:\"end_embed_tags\";s:7:\"[/tags]\";s:7:\"rp_feed\";i:0;s:11:\"rp_embedded\";s:2:\"no\";s:8:\"rp_order\";s:10:\"count-desc\";s:12:\"rp_limit_qty\";i:5;s:13:\"rp_notagstext\";s:17:\"No
related posts.\";s:8:\"rp_title\";s:22:\"
Related posts
\";s:10:\"rp_xformat\";s:95:\"%post_title%
(%post_comment%)\";s:12:\"rp_adv_usage\";s:0:\"\";s:15:\"cloud_selection\";s:10:\"count-desc\";s:10:\"cloud_sort\";s:6:\"random\";s:15:\"cloud_limit_qty\";i:45;s:16:\"cloud_notagstext\";s:8:\"No
tags.\";s:11:\"cloud_title\";s:18:\"
Tag Cloud
\";s:12:\"cloud_format\";s:4:\"flat\";s:13:\"cloud_xformat\";s:155:\"%tag_name%\";s:15:\"cloud_max_color\";s:7:\"#000000\";s:15:\"cloud_min_color\";s:7:\"#CCCCCC\";s:14:\"cloud_max_size\";i:22;s:14:\"cloud_min_size\";i:8;s:10:\"cloud_unit\";s:2:\"pt\";s:14:\"cloud_inc_cats\";i:0;s:15:\"cloud_adv_usage\";s:0:\"\";s:7:\"tt_feed\";i:0;s:11:\"tt_embedded\";s:2:\"no\";s:12:\"tt_separator\";s:2:\",
\";s:9:\"tt_before\";s:6:\"Tags: \";s:8:\"tt_after\";s:6:\"
\";s:13:\"tt_notagstext\";s:22:\"No tags for this
post.\";s:9:\"tt_number\";i:0;s:11:\"tt_inc_cats\";i:0;s:10:\"tt_xformat\";s:64:\"%tag_name%\";s:12:\"tt_adv_usage\";s:0:\"\";s:9:\"rt_number\";i:5;s:8:\"rt_order\";s:10:\"count-desc\";s:12:\"rt_separator\";s:1:\"
\";s:9:\"rt_format\";s:4:\"list\";s:9:\"rt_method\";s:2:\"OR\";s:8:\"rt_title\";s:21:\"
Related tags
\";s:13:\"rt_notagstext\";s:22:\"No
related tags found.\";s:10:\"rt_xformat\";s:91:\"%tag_count% + %tag_name%\";s:19:\"rt_remove_separator\";s:1:\"
\";s:16:\"rt_remove_format\";s:4:\"list\";s:20:\"rt_remove_notagstext\";s:1:\" \";s:17:\"rt_remove_xformat\";s:105:\"» Remove
%tag_name%\";s:15:\"meta_autoheader\";i:1;s:19:\"meta_always_include\";s:0:\"\";s:17:\"meta_keywords_qty\";i:0;s:13:\"use_auto_tags\";i:0;s:6:\"at_all\";i:0;s:8:\"at_empty\";i:0;s:9:\"auto_list\";s:0:\"\";}s:10:\"db_options\";s:10:\"simpletags\";s:14:\"posts_base_url\";s:44:\"http://www.callia.lt/wp-admin/edit.php?page=\";s:16:\"options_base_url\";s:55:\"http://www.callia.lt/wp-admin/options-general.php?page=\";s:7:\"message\";s:0:\"\";s:6:\"status\";s:0:\"\";s:8:\"all_tags\";b:0;s:7:\"nb_tags\";i:50;}i:1;s:9:\"uninstall\";}s:27:\"simple-tags/simple-tags.php\";s:20:\"SimpleTags_Uninstall\";s:27:\"wp-super-cache/wp-cache.php\";s:23:\"wpsupercache_deactivate\";s:19:\"captcha/captcha.php\";s:20:\"cptch_delete_options\";}'
WHERE `option_name` = 'uninstall_plugins';

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

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

SELECT option_value FROM wp_options WHERE option_name = 'mods_Pixeled White (localized)' LIMIT 1;

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

SELECT option_value FROM wp_options WHERE option_name = 'widget_top-posts' LIMIT 1;

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

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

SELECT option_value FROM wp_options WHERE option_name = 'widget_facebook-likebox' LIMIT 1;

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

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

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

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

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/grupe-vakaras/');

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 ('grupe-vakaras')
				;

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 = 'post_tag' AND t.slug =
'grupe-vakaras' LIMIT 1;

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (216) ) 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 (1115);

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

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

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 = 'post_tag' AND t.slug =
'grupe-vakaras' LIMIT 1;

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 = 'hs4wp_useFullJS' 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 t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND t.slug =
'grupe-vakaras' 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (2);

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

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

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

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (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 (1115);

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 =
'107.21.186.38' where p.ID in (1115) 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 =
'107.21.186.38' where p.ID in (1115) 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 =
'107.21.186.38' where p.ID in (1115) 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 =
'107.21.186.38' where p.ID in (1115) 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=260;;

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

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

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

SELECT AVG(rating) FROM wp_movie_ratings;

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

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

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

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

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

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

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

Select * from wp_social_links_sidebar order by sort_order;

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 wp_posts.* FROM wp_posts WHERE ID IN (1655);

SELECT * FROM wp_comments WHERE comment_ID = 8360 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1655 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2013-04-09 07:14:47';

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1655 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2013-04-09 07:14:47';

SELECT * FROM wp_comments WHERE comment_ID = 7843 LIMIT 1;

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1655 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2013-03-28 11:59:51';

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1655 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2013-03-28 11:59:51';

SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 1655 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt <
'2013-03-27 13:32:01';

UPDATE `wp_options` SET `option_value` = '6a5c03d115c280f116395f7fe5926b94' WHERE `option_name` = '_transient_random_seed';

UPDATE `wp_options` SET `option_value` =
'a:1:{s:32:\"4915792e653474fbae1f09420aa383f6\";a:1:{i:1369007778;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:\"359\";}i:1;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:2:\"97\";}i:2;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:2:\"78\";}i:3;a:4:{s:7:\"post_id\";s:4:\"1655\";s:10:\"post_title\";s:79:\"Garantinis
remontas ir kitos žmogaus teisės, arba \"kuris čia
kupranugarius?\"\";s:14:\"post_permalink\";s:76:\"http://www.callia.lt/2009/08/31/garantinis-remontas-ir-kitos-zmogaus-teises/\";s:5:\"views\";s:2:\"53\";}i:4;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:2:\"38\";}i:5;a:4:{s:7:\"post_id\";s:4:\"3866\";s:10:\"post_title\";s:85:\"Kaip
atstatyti sugadintą Windows Registry - retai naudojamas, bet veiksmingas
būdas\";s:14:\"post_permalink\";s:113:\"http://www.callia.lt/2010/03/08/kaip-atstatyti-sugadinta-windows-registry-retai-naudojamas-bet-veiksmingas-budas/\";s:5:\"views\";s:2:\"31\";}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:\"27\";}i:7;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:\"18\";}i:8;a:4:{s:7:\"post_id\";s:4:\"4454\";s:10:\"post_title\";s:89:\"Futbolo
menedžeriai - FIFA Manager vs Football Manager vs Championship Manager vs
Others\";s:14:\"post_permalink\";s:119:\"http://www.callia.lt/2010/06/27/futbolo-menedzeriai-fifa-manager-vs-football-manager-vs-championship-manager-vs-others/\";s:5:\"views\";s:2:\"17\";}i:9;a:4:{s:7:\"post_id\";s:4:\"2733\";s:10:\"post_title\";s:54:\"Žmogus
kosmose be skafandro - ar įmanoma
išgyventi?\";s:14:\"post_permalink\";s:60:\"http://www.callia.lt/2009/11/04/zmogus-kosmose-be-skafandro/\";s:5:\"views\";s:2:\"15\";}}}}' WHERE
`option_name` = 'stats_cache';

SELECT p.id, p.post_title, p.post_author FROM wp_posts AS p WHERE p.id IN (4168,2816,1655,2998,3866,185,2121,4454,2733) 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 = 4168 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 2816 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 2998 LIMIT 1;

SELECT * FROM wp_posts WHERE ID = 3866 LIMIT 1;

UPDATE `wp_options` SET `option_value` = 'a:1:{s:6:\"wppp-3\";a:2:{s:5:\"value\";s:1404:\"
Mėnesio populiariausi -
žiūrėta kartų
\n
\n	
Anonsuotas Džeimso Kamerono "Avatar 2" filmas - 97
\n	
Sendaikčių turgus - mūsų vaikystės žaislai ir kitokie pričindalai - 78
\n	
Garantinis remontas ir kitos žmogaus teisės, arba "kuris čia kupranugarius?" -
53
\n	
Microsoft
egzaminai ir sertifikatai - 38
\n	
Kaip atstatyti sugadintą Windows Registry - retai naudojamas, bet
veiksmingas būdas - 31
\n
\n\";s:4:\"time\";i:1369007778;}}' 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' ,
    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;