Thought I’d denote some queries we commonly use to determine what has recently changed on one of our multisite instances in WordPress
Pages/Posts
SELECT ID, post_title FROM wp_X_posts WHERE post_status = 'publish' AND DATE(post_modified_gmt) BETWEEN '2023-08-15' AND '2023-10-31' AND post_type IN ('post', 'page') ORDER BY post_modified_gmt DESC;
Events Manager Pro Events
SELECT * FROM `wp_X_em_events` WHERE DATE(event_date_modified) BETWEEN '2023-08-15' AND '2023-10-31' OR DATE(event_date_created) BETWEEN '2023-08-15' AND '2023-10-31';
Events Manager Pro Bookings
SELECT * FROM `wp_X_em_bookings` WHERE DATE(booking_date) BETWEEN '2023-08-15' AND '2023-10-31';
Newsletter
SELECT * FROM `wp_X_newsletter_emails` WHERE DATE(created) BETWEEN '2023-08-15' AND '2023-10-31';
Gravity Forms Entries
SELECT wp_X_gf_entry.form_id FROM wp_X_gf_entry
WHERE DATE(wp_X_gf_entry.date_created) BETWEEN '2023-01-01' AND '2023-10-31'
GROUP BY wp_X_gf_entry.form_id