select ( select meta_value from wp_postmeta where post_id = ID and meta_key = 'region' ) as region, ( select meta_value from wp_postmeta where post_id = ID and meta_key = 'start_date' ) as start_date, ( select meta_value from wp_postmeta where post_id = ID and meta_key = 'end_date' ) as end_date, ID, post_title, post_content from wp_posts where post_type = 'events' and post_status= 'publish' and ( ( select meta_value from wp_postmeta where post_id = ID and meta_key='end_date' ) >= 20241121 or ( select meta_value from wp_postmeta where post_id = ID and meta_key = 'start_date' ) >= 20241121 ) order by RAND() limit 48,12