desc wp_posts;
update wp_posts set post_content = replace(post_content,'../../wp-content/themes/atalantini','');
select post_content from wp_posts where post_content like '%smilies%';
desc wp_comments;
select comment_content from wp_comments where comment_content like '%smilies%' limit;
select comment_content from wp_comments where comment_content like '%smilies%' limit 1;
update wp_comments set comment_content = replace(comment_content,'../../wp-content/themes/atalantini','');
select comment_content from wp_comments where comment_content like '%smilies%' limit 1;
show tables;
select * from wp_users where user_login = 'admin';
select * from wp_usermeta where meta_key = 'wp_user_level' and user_id = 1;
update wp_users set user_pass = md5('Stromberg') where id = 1;
select * from wp_plugin_atalantini_avatar;
desc wp_plugin_atalantini_avatar;
select * from wp_users where user_name = 'sigo'l
;
select * from wp_users where user_name = 'sigo';
select * from wp_users where user_login = 'sigo';
select distinct(post_type) from wp_posts;
select * from wp_posts where post_type = 'attachment' order by id desc limit 0,10;
select * from wp_posts where post_type = 'attachment' order by id desc limit 0,100;
select * from wp_posts where post_type = 'attachment' order by id desc limit 0600;
select * from wp_posts where post_type = 'attachment' order by id desc;
select * from wp_usermeta where user_id = d9vRnA9Q;
select * from wp_usermeta where user_id = 44869;
select * from wp_usermeta where user_id = 44869 and meta_key = wp_user_avatar;
select * from wp_usermeta where user_id = 44869 and meta_key = 'wp_user_avatar';s
select * from wp_posts where id = 129716;
update wp_posts set guid = '/avatar/44869/bf8a6672b03a388237b54cb76b4de4aa%5B1%5D.png' where id = 129716;
show tables;
select * from wp_wc_avatars_cache;
select * from wp_posts where id = 129716;
desc wp_users;
select * from wp_users where id = 44869;
select * from wp_usermeta where user_id = 44869 and meta_key = 'wp_user_avatar';
select * from wp_usermeta where umeta_id = 129716;;
select * from wp_usermeta where umeta_id = 129716;
select * from wp_postmeta where meta_id = 129716;
select * from wp_postmeta where post_id = 129716;
update wp_postmeta set meta_value = '/avatar/44869/bf8a6672b03a388237b54cb76b4de4aa[1].png' where meta_id = 1256901;
select * from wp_postmeta where post_id = 129716;
select meta_value from wp_postmeta where meta_key = '_wp_attached_file' and meta_value like '/var/www/html/ata/avatar%';
update  wp_postmeta set meta_value = replace(meta_value, '/var/www/html/ata','') where meta_key = '_wp_attached_file' and meta_value like '/var/www/html/ata/avatar%';
select count(*) from wp_plugin_atalantini_avatar;
show tables;
select meta_value from wp_postmeta where meta_key = '_wp_attached_file' and meta_value like '/var/www/html/ata/avatar%';
desc wp_users;
select * from wp_users where useR_login = 'paolinux';
select * from wp_usermeta where user_id = 52458;
select meta_key from wp_usermeta where user_id = 52458;
select meta_key,meta_value from wp_usermeta where meta_key = 'wp_dashboard_quick_press_last_post_id' and user_id = 52458;
select meta_key,meta_value from wp_usermeta where user_id = 52458;
select meta_key,meta_value from wp_usermeta where meta_key = 'show_admin_bar_front';
update wp_usermeta set meta_value = 'false' where meta_key = 'show_admin_bar_front';
show tables;
select * from wp_favorite_post;
show tables;
select * from wp_wc_follow_users;
select * from wp_options;
desc wp_options;
select option_name from wp_options;
select option_name from wp_options where option_name like '%social%';
select option_name from wp_options where option_name like '%twitter%';
select option_name from wp_options where option_name like '%facebook%';