davidfcarr on "[Plugin: RSVPMaker] SQL Query needed!!"

Hello! Please give me the SQL query through which RSVPmaker selects all the upcoming events from the database? Please, it's urgent!

https://wordpress.org/plugins/rsvpmaker/

A typical query associated with the rsvpmaker_upcoming shortcode would be something like

SELECT wpb_posts.*, meta_value as datetime, meta_id FROM wpb_posts JOIN wpb_postmeta ON wpb_postmeta.post_id = wpb_posts.ID AND meta_key='_rsvp_dates' WHERE 1=1 AND wpb_posts.post_type = 'rsvpmaker' AND ((wpb_posts.post_status = 'publish')) AND meta_value > CURDATE() AND meta_value < DATE_ADD( CURDATE() , INTERVAL 5 WEEK) ORDER BY meta_value

The specifics may vary depending on the options you have set. The query is pieced together using a series of filters on the standard WordPress query for posts.

What's the big emergency where you need to know this?