Consulta no vĂ¡lida: SELECT 'medellin' as ciudad, p.id, p.post_content, p.post_date, p.post_title, (SELECT guid FROM `emw_posts` WHERE `ID` = pm.meta_value) as post_image, 'w' as frsite FROM emw_posts as p INNER JOIN emw_term_relationships as rp on rp.object_id = p.id INNER JOIN emw_postmeta as pm on (p.ID = pm.post_id) where rp.term_taxonomy_id = 28 AND meta_key = '_thumbnail_id' and p.post_status = 'publish' and post_date between '2023-01-01' and '2023-06-30' ORDER BY p.post_date desc