PARTENAIRES

SELECT www_blogs.blog_id 
FROM www_blogs 
WHERE domain = 'martinedoyen.com' 
AND path IN ( '/hamsters/', '/' ) 
ORDER BY CHAR_LENGTH(path) DESC 
LIMIT 1

SELECT * 
FROM www_blogs 
WHERE blog_id IN (11)

SELECT meta_key, meta_value 
FROM www_sitemeta 
WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'can_compress_scripts', 'global_terms_enabled', 'ms_files_rewriting') 
AND site_id = 1

SELECT option_name, option_value 
FROM www_11_options 
WHERE autoload = 'yes'

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'health-check-disable-plugin-hash' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'health-check-allowed-plugins' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'health-check-default-theme' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'health-check-current-theme' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'wordpress_api_key' 
LIMIT 1

SELECT VERSION()

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'uninstall_plugins' 
LIMIT 1

SELECT meta_value 
FROM www_sitemeta 
WHERE meta_key = 'oc_cu_consent' 
AND site_id = 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'analyst_notices' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'analyst_cache' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'analyst_accounts_data' 
LIMIT 1

SHOW FULL COLUMNS 
FROM `www_11_options`

UPDATE `www_11_options` 
SET `option_value` = 'a:3:{s:33:\"instagram-feed/instagram-feed.php\";s:22:\"sb_instagram_uninstall\";s:59:\"ultimate-social-media-icons/ultimate_social_media_icons.php\";a:2:{i:0;s:15:\"Account\\Account\";i:1;s:25:\"onUninstallPluginListener\";}s:26:\"onecom-vcache/vcaching.php\";s:26:\"oc_vcache_plugin_uninstall\";}' 
WHERE `option_name` = 'uninstall_plugins'

UPDATE `www_11_options` 
SET `option_value` = 'a:3:{s:33:\"instagram-feed/instagram-feed.php\";s:22:\"sb_instagram_uninstall\";s:59:\"ultimate-social-media-icons/ultimate_social_media_icons.php\";s:20:\"sfsi_Unistall_plugin\";s:26:\"onecom-vcache/vcaching.php\";s:26:\"oc_vcache_plugin_uninstall\";}' 
WHERE `option_name` = 'uninstall_plugins'

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'embed_size_w' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'embed_size_h' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sbi_oembed_token' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sb_instagram_settings' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sb_instagram_errors' 
LIMIT 1

show tables like 'www_11_sbi_instagram_posts'

show tables like 'www_11_sbi_instagram_feeds_posts'

SELECT meta_value 
FROM www_sitemeta 
WHERE meta_key = 'wpseo_ms' 
AND site_id = 1

SELECT meta_value 
FROM www_sitemeta 
WHERE meta_key = '_site_transient_timeout___onecom_allowed_onecom-vcache' 
AND site_id = 1

SELECT meta_value 
FROM www_sitemeta 
WHERE meta_key = '_site_transient___onecom_allowed_onecom-vcache' 
AND site_id = 1

SELECT meta_value 
FROM www_sitemeta 
WHERE meta_key = 'varnish_caching_enable' 
AND site_id = 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = '_transient_timeout_doing_cron' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = '_transient_doing_cron' 
LIMIT 1

INSERT INTO `www_11_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1619114961.9230039119720458984375', 'yes') 
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_hosts' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_dynamic_host' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_stats_json_file' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_purge_menu_save' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_purge_key' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_truncate_notice' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_override' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'varnish_caching_ssl' 
LIMIT 1

DELETE 
FROM `www_11_statistics_useronline` 
WHERE timestamp < 1619122043

UPDATE `www_11_options` 
SET `option_value` = '1619122163' 
WHERE `option_name` = 'wp_statistics_check_user_online'

SELECT ID, post_name, post_parent, post_type 
FROM www_11_posts 
WHERE post_name IN ('partenaires') 
AND post_type IN ('page','attachment')

SELECT * 
FROM www_11_posts 
WHERE ID = 26 
LIMIT 1

SELECT www_11_posts.* 
FROM www_11_posts 
WHERE 1=1 
AND (www_11_posts.ID = '26') 
AND www_11_posts.post_type = 'page' 
ORDER BY www_11_posts.post_date DESC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (26) 
ORDER BY meta_id ASC

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'oc_cdn_enabled' 
LIMIT 1

SELECT * 
FROM www_users 
WHERE ID = '1' 
LIMIT 1

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

SELECT * 
FROM `www_11_yoast_indexable` 
WHERE `object_id` = '26' 
AND `object_type` = 'post' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sfsi_section6_options' 
LIMIT 1

SELECT * 
FROM `www_11_yoast_indexable` 
WHERE `object_type` = 'home-page' 
LIMIT 1

SELECT * 
FROM `www_11_yoast_indexable` 
WHERE `object_id` = '40' 
AND `object_type` = 'post' 
LIMIT 1

SELECT `ancestor_id` 
FROM `www_11_yoast_indexable_hierarchy` 
WHERE `indexable_id` = '6' 
ORDER BY `depth` DESC

DELETE 
FROM `www_11_yoast_indexable_hierarchy` 
WHERE `indexable_id` = '6'

INSERT INTO `www_11_yoast_indexable_hierarchy` (`indexable_id`, `ancestor_id`, `depth`, `blog_id`) VALUES ('6', '0', '0', '11')

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sfsi_feed_id' 
LIMIT 1

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sfsi_verificatiom_code' 
LIMIT 1

SELECT * 
FROM www_11_posts 
WHERE (post_type = 'page' 
AND post_status = 'publish') 
AND post_parent = 26 
ORDER BY www_11_posts.post_title ASC 
LIMIT 0,1

SELECT t.*, tt.* 
FROM www_11_terms AS t 
INNER JOIN www_11_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE t.term_id = 2

SELECT tr.object_id 
FROM www_11_term_relationships AS tr 
INNER JOIN www_11_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND tt.term_id IN ('2') 
ORDER BY tr.object_id ASC

SELECT www_11_posts.* 
FROM www_11_posts 
WHERE 1=1 
AND www_11_posts.ID IN (27,28,30,33,43,44,45,46) 
AND www_11_posts.post_type = 'nav_menu_item' 
AND ((www_11_posts.post_status = 'publish')) 
ORDER BY www_11_posts.menu_order ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (27,28,30,46,45,44,43,33) 
ORDER BY meta_id ASC

SELECT www_11_posts.* 
FROM www_11_posts 
WHERE 1=1 
AND www_11_posts.ID IN (21,24,26) 
AND www_11_posts.post_type = 'page' 
AND ((www_11_posts.post_status = 'publish')) 
ORDER BY www_11_posts.post_date DESC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (24,21) 
ORDER BY meta_id ASC

SELECT t.*, tt.* 
FROM www_11_terms AS t 
INNER JOIN www_11_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('category') 
AND t.term_id IN ( 7,6,4,3 ) 
AND tt.count > 0 
ORDER BY t.name ASC

SELECT term_id, meta_key, meta_value 
FROM www_11_termmeta 
WHERE term_id IN (4,7,3) 
ORDER BY meta_id ASC

SELECT t.*, tt.* 
FROM www_11_terms AS t 
INNER JOIN www_11_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE t.term_id = 6

SELECT www_11_posts.* 
FROM www_11_posts 
WHERE ID IN (1180,1176,366,1178,1177,1181,1240)

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (1180) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (1176) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (366) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (1178) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (1177) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (1181) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM www_11_postmeta 
WHERE post_id IN (1240) 
ORDER BY meta_id ASC

SELECT * 
FROM www_11_posts 
WHERE (post_type = 'page' 
AND post_status = 'publish') 
ORDER BY www_11_posts.post_title ASC

SELECT option_value 
FROM www_11_options 
WHERE option_name = 'sfsi_section3_options' 
LIMIT 1