Hotel per motociclisti, Agriturismi, B&B in Europa

Query:
SELECT p.ID as lst_id, p.post_title as post_title, p.guid as post_url, pmd.meta_value as date_ts, pmevt.meta_value as data_evento, pmde.meta_value as date_end_ts, pmete.meta_value as data_evento_end, pmspv.meta_value as siglapv, pmadr.meta_value as friendly_address FROM wpmtr_posts p INNER JOIN wpmtr_postmeta pmtyp ON pmtyp.post_id = p.ID AND pmtyp.meta_key = '_listing_type' AND pmtyp.meta_value = 'event' INNER JOIN wpmtr_postmeta pmadr ON pmadr.post_id = p.ID and pmadr.meta_key = '_friendly_address' LEFT OUTER JOIN wpmtr_postmeta pmspv ON pmspv.post_id = p.ID and pmspv.meta_key = '_provincia' LEFT OUTER JOIN wpmtr_postmeta pmd ON pmd.post_id = p.ID AND pmd.meta_key = '_event_date_timestamp' LEFT OUTER JOIN wpmtr_postmeta pmevt ON pmevt.post_id = p.ID AND pmevt.meta_key = '_event_date' LEFT OUTER JOIN wpmtr_postmeta pmde ON pmde.post_id = p.ID AND pmde.meta_key = '_event_date_end_timestamp' LEFT OUTER JOIN wpmtr_postmeta pmete ON pmete.post_id = p.ID AND pmete.meta_key = '_event_date_end' WHERE p.post_type = 'listing' AND p.post_status = 'publish' AND (pmde.meta_value >= 1745877600) ORDER BY date_ts, post_title LIMIT 10