SELECT
am_posts.ID,
mk1.meta_value AS eventdate,
mk2.meta_value AS am2_content_unique,
mk3.meta_value AS boost_not_applicable,
mk4.meta_value AS bounce_rate,
mk5.meta_value AS bounty,
mk6.meta_value AS has_bounty,
CAST( mk7.meta_value AS SIGNED ) AS crave_eventid,
GROUP_CONCAT(am_term_relationships.term_taxonomy_id) as cities

FROM am_posts
LEFT JOIN am_postmeta mk1 ON mk1.post_id = am_posts.ID AND mk1.meta_key='eventdate'
LEFT JOIN am_postmeta mk2 ON mk2.post_id = am_posts.ID AND mk2.meta_key='am2_content_unique'
LEFT JOIN am_postmeta mk3 ON mk3.post_id = am_posts.ID AND mk3.meta_key='boost_not_applicable'
LEFT JOIN am_postmeta mk4 ON mk4.post_id = am_posts.ID AND mk4.meta_key='bounce_rate'
LEFT JOIN am_postmeta mk5 ON mk5.p
ost_id = am_posts.ID AND mk5.meta_key='bounty'
LEFT JOIN am_postmeta mk6 ON mk6.post_id = am_posts.ID AND mk6.meta_key='has_bounty'
LEFT JOIN am_postmeta mk7 ON mk7.post_id = am_posts.ID AND mk7.meta_key='crave_eventid'
LEFT JOIN am_term_relationships ON (am_posts.ID = am_term_relationships.object_id)

WHERE
	am_posts.post_type = 'events'
GROUP BY am_posts.ID