MT | TEC | Count number of recurrences in database

count_recurrences.sql

/*
Shows how many recurrences each recurring event has.
Includes events from all statuses including in the trash.
*/

SELECT 
	`post_parent` as event_id, 
	COUNT(*) As recurrences 
FROM 
	wp_posts 
WHERE 
	`post_parent` <> 0 
	AND `post_type` = 'tribe_events' 
GROUP BY 
	`post_parent` 
ORDER BY 
	`recurrences` DESC