#1242 subquery error on second SELECT run

eventExport

SELECT	post_date AS event_post_date,
		post_title AS event_title,
		fnStripTags(post_content) AS event_content,
		CONCAT('http://www.kcstudio.org/event/',post_name) AS event_URL,
		(SELECT meta_value FROM wp_postmeta WHERE wp_postmeta.meta_key = 'thumbnailURL' AND wp_postmeta.post_id = wp_posts.ID) AS event_thumbnail_URL,
		(SELECT (CASE meta_value WHEN meta_value REGEXP '^[[:digit:]]+$' THEN meta_value ELSE CONCAT('$', meta_value) END ) FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventCost' AND wp_postmeta.post_id = wp_posts.ID) AS event_cost,
		(SELECT DATE_FORMAT(meta_value, '%W') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.post_id = wp_posts.ID) AS event_start_day,
		(SELECT DATE_FORMAT(meta_value, '%M %D, %Y') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.post_id = wp_posts.ID) AS event_start_date,
		(SELECT TIME_FORMAT(meta_value, '%r') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.post_id = wp_posts.ID) AS start_time,
		(SELECT DATE_FORMAT(meta_value, '%W') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventEndDate'	AND wp_postmeta.post_id = wp_posts.ID) AS event_end_day,
		(SELECT DATE_FORMAT(meta_value, '%M %D, %Y') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventEndDate'	AND wp_postmeta.post_id = wp_posts.ID) AS event_end_date,
		(SELECT TIME_FORMAT(meta_value, '%h:%i %p') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventEndDate'	AND wp_postmeta.post_id = wp_posts.ID) AS event_end_time,
		(SELECT UPPER(meta_value) FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventAllDay' AND wp_postmeta.post_id = wp_posts.ID) AS event_all_day,
		(SELECT SEC_TO_TIME(meta_value) FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventDuration' AND wp_postmeta.post_id = wp_posts.ID) AS event_duration_in_hours_minutes,
		(SELECT organizer.post_title FROM wp_posts AS organizer WHERE organizer.id = (SELECT meta_value FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventOrganizerID' AND wp_postmeta.post_id = wp_posts.ID)) AS event_organizer,
		(SELECT venue.post_title FROM wp_posts AS venue WHERE venue.id = (SELECT meta_value FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventVenueID' AND wp_postmeta.post_id = wp_posts.ID)) AS event_venue
		
FROM	wp_posts
WHERE	post_type = 'tribe_events' AND
		post_status = 'publish' AND
		id IN (SELECT post_id FROM wp_postmeta WHERE meta_key = '_EventEndDate' AND meta_value BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 1 WEEK ))
ORDER BY event_start_day ASC, event_title ASC