WordPress database error: [Column 'ID' in field list is ambiguous]
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_p2zdz4_posts.*, ID as postID, rsvpdates.date as datetime, date_format(rsvpdates.date,'%M %e, %Y') as date, rsvpdates.enddate, rsvpdates.display_type, rsvpdates.ts_start, rsvpdates.ts_end, rsvpdates.timezone
, wp_p2zdz4_posts.ID IN (166,172,171,170,164,153,148,173,163,165,169,168) AS ordered, (SELECT post_rank FROM wp_p2zdz4_q2w3_post_order WHERE post_id = wp_p2zdz4_posts.ID AND post_type = 'post') as order_num FROM wp_p2zdz4_posts JOIN wp_p2zdz4_rsvpmaker_event rsvpdates ON rsvpdates.event = wp_p2zdz4_posts.ID
LEFT JOIN wp_p2zdz4_q2w3_post_order ON (wp_p2zdz4_posts.ID = wp_p2zdz4_q2w3_post_order.post_id AND wp_p2zdz4_q2w3_post_order.post_type = 'post') WHERE 1=1 AND wp_p2zdz4_posts.post_type = 'rsvpmaker' AND ((wp_p2zdz4_posts.post_status = 'publish')) AND ( ( rsvpdates.date > '2024-05-16' OR rsvpdates.enddate > '2024-05-16' ) )
ORDER BY ordered DESC, order_num ASC, rsvpdates.date ASC
LIMIT 0, 1