'veranstaltung'
(object) array(
'de' => 'veranstaltung',
'en' => 'event',
'it' => 'evento',
)
(object) array(
'dauerausstellung' =>
(object) array(
'de' => 'dauerausstellung',
'en' => 'permanent-exhibition',
'it' => 'mostra-permanente',
),
'ausstellung' =>
(object) array(
'de' => 'ausstellung',
'en' => 'exhibition',
'it' => 'mostra',
),
'veranstaltung' =>
(object) array(
'de' => 'veranstaltung',
'en' => 'event',
'it' => 'evento',
),
'rund_ums_domquartier' =>
(object) array(
'de' => 'rund-um-das-domquartier',
'en' => 'around-the-domquartier-2',
'it' => 'attorno-al-domquartier-2',
),
)
SELECT wp_posts.*
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (116)
) AND (
wp_postmeta.meta_key = 'dq_event_date_start'
AND
(
( mt1.meta_key = 'dq_event_date_end' AND mt1.meta_value >= '2024-11-21' )
)
) AND wp_posts.post_type = 'veranstaltung' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value ASC