Nos véhicules

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

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

SELECT name, val FROM wp_wfConfig WHERE autoload = 'yes';

SELECT `name`, `value` FROM `wp_wfls_settings` WHERE `autoload` = 'yes';

SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'detectProxyRecommendation';

SELECT * FROM `wp_wfBlocks7` WHERE `IP` = X'00000000000000000000ffff12db20ed' AND `type` = 7 AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP());

SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'wordfenceCentralConnected';

SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'keyExpDays';

SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'licenseType';

SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;

SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;

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

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

show tables like 'wp_sbi_instagram_feeds_posts';

SELECT COUNT(*) FROM wp_sbi_feeds;

SELECT COUNT(*) FROM wp_sbi_feeds;

SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'needsGeoIPSync';

SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'detectProxyRecommendation';

SELECT MAX(attackLogTime) FROM wp_wfHits;

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

SELECT *, CASE 
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE 
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
 FROM `wp_wfBlocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC;

SELECT *, CASE 
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE 
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
 FROM `wp_wfBlocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC;

SELECT * FROM `wp_wfBlocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = X'00000000000000000000ffff12db20ed' AND (`expiration` = 0 OR `expiration` >
UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1;

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

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

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

SELECT option_name, option_value FROM wp_options WHERE option_name IN
('_site_transient_wp_theme_files_patterns-0d8c1c8862af268522d04e78775a3917','_site_transient_timeout_wp_theme_files_patterns-0d8c1c8862af268522d04e78775a3917');

SHOW FULL COLUMNS FROM `wp_wfLiveTrafficHuman`;

SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = X'00000000000000000000ffff12db20ed' AND identifier = 'üÏ7`Væ?ûéðÎYϲ«–÷žRÜ~Óù\Z[' AND
expiration >= UNIX_TIMESTAMP();

		SELECT ID, post_name, post_parent, post_type
		FROM wp_posts
		WHERE post_name IN ('nos-vehicules')
		AND post_type IN ('page','attachment')
	;

SELECT * FROM wp_posts WHERE ID = 300 LIMIT 1;

SELECT   wp_posts.*
					 FROM wp_posts 
					 WHERE 1=1  AND (wp_posts.ID = '300') AND wp_posts.post_type = 'page'
					 
					 ORDER BY wp_posts.post_date DESC
					 ;

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

SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = X'00000000000000000000ffff12db20ed' AND identifier = 'üÏ7`Væ?ûéðÎYϲ«–÷žRÜ~Óù\Z[' AND
expiration >= UNIX_TIMESTAMP();

SELECT * FROM wp_users WHERE ID = '3' LIMIT 1;

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

SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '300' AND `object_type` = 'post' LIMIT 1;

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

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

SELECT * FROM wp_posts WHERE ID = 848 LIMIT 1;

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

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

SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '298' AND `object_type` = 'post' LIMIT 1;

SELECT `ancestor_id` FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '23' ORDER BY `depth` DESC;

SELECT * FROM wp_posts WHERE ID = 336 LIMIT 1;

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

SELECT option_name, option_value FROM wp_options WHERE option_name IN
('_transient_googlesitekit_setup_token','_transient_timeout_googlesitekit_setup_token');

SELECT * FROM wp_posts WHERE ID = 648 LIMIT 1;

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

SELECT * FROM wp_posts WHERE ID = 1147 LIMIT 1;

SELECT   wp_posts.ID
					 FROM wp_posts 
					 WHERE 1=1  AND wp_posts.post_parent = 300  AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
					 
					 ORDER BY wp_posts.post_title ASC
					 LIMIT 0, 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 33;

SELECT   wp_posts.*
					 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 (33)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.menu_order ASC
					 ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1139,343,342,1138,344) ORDER BY meta_id ASC;

SELECT wp_posts.* FROM wp_posts WHERE ID IN (298,299,42,79);

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (298,299,42,79) ORDER BY meta_id ASC;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 34;

SELECT   wp_posts.*
					 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 (34)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.menu_order ASC
					 ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (346,347,348,349) ORDER BY meta_id ASC;

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts 
					 WHERE 1=1  AND wp_posts.post_type = 'self-cars' AND ((wp_posts.post_status = 'publish'))
					 
					 
					 LIMIT 10, 10;

SELECT FOUND_ROWS();

SELECT wp_posts.* FROM wp_posts WHERE ID IN (1048,1053,1060);

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

SELECT DISTINCT t.term_id, 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 ('sc_free_options', 'sc_additional_options', 'sc_car_model_year', 'sc_car_fuel', 'sc_car_gearbox', 'sc_car_doors') AND
tr.object_id IN (1048, 1053, 1060)
			 ORDER BY t.name ASC
			 ;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN
(68,67,24,13,69,44,38,18,19,10,45,20,21,25,46,22,23);

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

SELECT * FROM wp_users WHERE ID IN (2);

SELECT * FROM wp_posts WHERE ID = 1050 LIMIT 1;

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

SELECT * FROM wp_posts WHERE ID = 1055 LIMIT 1;

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

SELECT * FROM wp_posts WHERE ID = 1064 LIMIT 1;

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

SELECT   wp_posts.*
					 FROM wp_posts 
					 WHERE 1=1  AND wp_posts.post_type = 'sc-testimonials' AND ((wp_posts.post_status = 'publish'))
					 
					 ORDER BY RAND()
					 ;

SELECT DISTINCT t.term_id, 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 ('sc-author-position') AND tr.object_id IN (330, 332, 328)
			 ORDER BY t.name ASC
			 ;

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

SELECT   wp_posts.ID
					 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
					 WHERE 1=1  AND ( 
  ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'page-contact.php' )
) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.post_title ASC
					 LIMIT 0, 1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 35;

SELECT   wp_posts.*
					 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 (35)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.menu_order ASC
					 ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (355,354,353,352) ORDER BY meta_id ASC;

SELECT wp_posts.* FROM wp_posts WHERE ID IN (29,31);

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

SELECT   wp_posts.ID
					 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 wp_posts.* FROM wp_posts WHERE ID IN (1191,1185,1165,1161,1133);

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1191,1185,1165,1161,1133) ORDER BY meta_id ASC;

SELECT DISTINCT t.term_id, 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 (1191, 1185, 1165, 1161, 1133)
			 ORDER BY t.name ASC
			 ;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (1,9);