Pre-Purchase InspectionNegotiate like a pro

SHOW TABLES LIKE 'wp_gmp_modules'

SELECT toe_m.*, toe_m_t.label as type_name 
FROM wp_gmp_modules as toe_m 
INNER JOIN wp_gmp_modules_type toe_m_t ON toe_m_t.id = toe_m.type_id 
ORDER BY id ASC

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

SELECT id 
FROM wp_gmp_icons 
WHERE title IN ('marker', 'flag', 'pin', 'star')

SELECT option_value 
FROM wp_options 
WHERE option_name = 'updraft_restore_in_progress' 
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'

SHOW FULL COLUMNS 
FROM `wp_wfBlocks7`

SELECT * 
FROM `wp_wfBlocks7` 
WHERE `IP` = '\0\0\0\0\0\0\0\0\0\0ÿÿ,Ôcø' 
AND `type` = 7 
AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP())

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

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_hide_uploaded_files' 
LIMIT 1

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` = '\0\0\0\0\0\0\0\0\0\0ÿÿ,Ôcø' 
AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) 
ORDER BY `blockedTime` DESC 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'can_compress_scripts' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'wposes_constant_WPOSES_
SETTINGS' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_disable_archive_page' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_remove_permalink_front_base' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_enable_featured_image' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'cptui_taxonomies' 
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
FROM wp_posts 
WHERE 1=1 
AND wp_posts.post_type = 'wpcf7_contact_form' 
AND ((wp_posts.post_status <> 'trash' 
AND wp_posts.post_status <> 'auto-draft')) 
ORDER BY wp_posts.post_modified DESC 
LIMIT 0, 20

SELECT FOUND_ROWS()

SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (5018,77,4614,5258,5223,5244,5243,5234,4740,5199,4797,5051,4748,4601,101,428,425,4558,299,4546)

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (77,101,299,425,428,4546,4558,4601,4614,4740,4748,4797,5018,5051,5199,5223,5234,5243,5244,5258) 
ORDER BY meta_id ASC

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_email_digest' 
LIMIT 1

SHOW FULL COLUMNS 
FROM `wp_wfLiveTrafficHuman`

SELECT COUNT(*) 
FROM wp_wfLiveTrafficHuman 
WHERE IP = '\0\0\0\0\0\0\0\0\0\0ÿÿ,Ôcø' 
AND identifier = '¸Fµø	š¨V¤¯\nV„¨âÉ|³á¨ñÍ!¦Ð' 
AND expiration >= UNIX_TIMESTAMP()

SELECT option_value 
FROM wp_options 
WHERE option_name = 'medium_crop' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'medium_large_crop' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'large_crop' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = '_transient_timeout_wposes_doing_cron_check' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = '_transient_wposes_doing_cron_check' 
LIMIT 1

INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_wposes_doing_cron_check', '1', 'yes') 
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

SELECT option_value 
FROM wp_options 
WHERE option_name = 'wposes_last_cron_check' 
LIMIT 1

SELECT autoload 
FROM wp_options 
WHERE option_name = '_transient_wposes_doing_cron_check'

SHOW FULL COLUMNS 
FROM `wp_options`

DELETE 
FROM `wp_options` 
WHERE `option_name` = '_transient_wposes_doing_cron_check'

SELECT autoload 
FROM wp_options 
WHERE option_name = '_transient_timeout_wposes_doing_cron_check'

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

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

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

SELECT ID, post_name, post_parent, post_type 
FROM wp_posts 
WHERE post_name IN ('ppi') 
AND post_type IN ('page','attachment')

SELECT * 
FROM wp_posts 
WHERE ID = 219 
LIMIT 1

SELECT wp_posts.* 
FROM wp_posts 
WHERE 1=1 
AND (wp_posts.ID = '219') 
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 (219) 
ORDER BY meta_id ASC

SELECT COUNT(*) 
FROM wp_wfLiveTrafficHuman 
WHERE IP = '\0\0\0\0\0\0\0\0\0\0ÿÿ,Ôcø' 
AND identifier = '¸Fµø	š¨V¤¯\nV„¨âÉ|³á¨ñÍ!¦Ð' 
AND expiration >= UNIX_TIMESTAMP()

SELECT option_value 
FROM wp_options 
WHERE option_name = '_transient_timeout_global_styles_driver' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = '_transient_global_styles_driver' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_enable_recaptcha' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_recaptcha_site_key' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_jobs_recaptcha_secret_key' 
LIMIT 1

SELECT option_value 
FROM wp_options 
WHERE option_name = 'awsm_enable_job_search' 
LIMIT 1

SELECT * 
FROM wp_users 
WHERE ID = '4' 
LIMIT 1

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

SELECT * 
FROM `wp_yoast_indexable` 
WHERE `object_id` = '219' 
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 = 4296 
LIMIT 1

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (4296) 
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` = '37' 
AND `object_type` = 'post' 
LIMIT 1

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

SHOW FULL COLUMNS 
FROM `wp_wfHits`

INSERT INTO `wp_wfHits` (`ctime`, `statusCode`, `isGoogle`, `IP`, `userID`, `URL`, `referer`, `UA`, `jsRun`) VALUES ('1675351543.238921', '200', '0', '\0\0\0\0\0\0\0\0\0\0ÿÿ,Ôcø', '0', 'https://driveroo.net/ppi/', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '')

select HEX(AES_ENCRYPT('692371', '33df64f5d8b99ca8')) as val

SELECT * 
FROM wp_posts 
WHERE ID = 5217 
LIMIT 1

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

SELECT * 
FROM wp_posts 
WHERE (post_type = 'page' 
AND post_status = 'publish') 
AND post_parent = 219 
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 = 3

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 (3) ) 
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 wp_posts.* 
FROM wp_posts 
WHERE ID IN (4689,1892,5159,5150,5154,5175,4932,5190,4699,5164,4944,4945,4925,4776,4572,4698,1586,1897,4790,1898,4673,4654,4655,4656)

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1586,1892,1897,1898,4572,4654,4655,4656,4673,4689,4698,4699,4776,4790,4925,4932,4944,4945,5150,5154,5159,5164,5175,5190) 
ORDER BY meta_id ASC

SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (5133,4692,4681,5171,4715,4730,4668,4356,4642,4246,4807,4718,4234,957,189,4788,786)

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (189,786,957,4234,4246,4356,4642,4668,4681,4692,4715,4718,4730,4788,4807,5133,5171) 
ORDER BY meta_id ASC

SELECT t.term_id 
FROM wp_terms AS t 
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND t.slug IN ('fleet-solutions') 
LIMIT 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 IN (19)

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 (19) ) 
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 wp_posts.* 
FROM wp_posts 
WHERE ID IN (4365,4366,4364,4368,4367,4363,4404)

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (4363,4364,4365,4366,4367,4368,4404) 
ORDER BY meta_id ASC

SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (4342,4336,4255,4359,4402)

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (4255,4336,4342,4359,4402) 
ORDER BY meta_id ASC

SELECT * 
FROM wp_posts 
WHERE ID = 4230 
LIMIT 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 = 2

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 (2) ) 
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 wp_posts.* 
FROM wp_posts 
WHERE ID IN (47,1917,1918,111)

SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (47,111,1917,1918) 
ORDER BY meta_id ASC