select x.term_taxonomy_id as object_id, id, post_title, guid, m.meta_value as datum, s.name as kategorie from RebxDQwsposts p inner join RebxDQwspostmeta m on p.id=m.post_id inner join RebxDQwspostmeta h on p.id=h.post_id inner join RebxDQwsterm_relationships t on p.id=t.object_id inner join RebxDQwsterm_taxonomy x on x.term_taxonomy_id=t.term_taxonomy_id inner join RebxDQwsterms s on s.term_id=x.term_id where post_type=’tribe_events‘ and x.taxonomy=’tribe_events_cat‘ and m.meta_key=’_EventStartDate‘ and m.meta_value>=now() and h.meta_key=’_EventVenueID‘
Array
(
[0] => Array
(
[object_id] => 8
[id] => 6351
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6351
[datum] => 2024-05-02 17:00:00
[kategorie] => Probe
)
[1] => Array
(
[object_id] => 8
[id] => 6373
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6373
[datum] => 2024-05-02 19:15:00
[kategorie] => Probe
)
[2] => Array
(
[object_id] => 9
[id] => 6313
[post_title] => Sommerkonzert St. Annenkirche
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6313
[datum] => 2024-05-26 17:00:00
[kategorie] => Auftritt
)
[3] => Array
(
[object_id] => 9
[id] => 6317
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6317
[datum] => 2024-06-20 19:00:00
[kategorie] => Auftritt
)
[4] => Array
(
[object_id] => 9
[id] => 6319
[post_title] => Freiberg singt
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6319
[datum] => 2024-09-01 14:00:00
[kategorie] => Auftritt
)
[5] => Array
(
[object_id] => 9
[id] => 6321
[post_title] => Konzert Reha-Klinik
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6321
[datum] => 2024-09-12 19:00:00
[kategorie] => Auftritt
)
[6] => Array
(
[object_id] => 9
[id] => 6325
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6325
[datum] => 2024-10-24 19:00:00
[kategorie] => Auftritt
)
[7] => Array
(
[object_id] => 9
[id] => 6329
[post_title] => Weihnachtskonzert Reha-Klinik
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6329
[datum] => 2024-12-05 19:00:00
[kategorie] => Auftritt
)
[8] => Array
(
[object_id] => 9
[id] => 6331
[post_title] => Adventskonzert St. Annenkirche
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6331
[datum] => 2024-12-15 15:00:00
[kategorie] => Auftritt
)
[9] => Array
(
[object_id] => 10
[id] => 6313
[post_title] => Sommerkonzert St. Annenkirche
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6313
[datum] => 2024-05-26 17:00:00
[kategorie] => Öffentlich
)
[10] => Array
(
[object_id] => 10
[id] => 6317
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6317
[datum] => 2024-06-20 19:00:00
[kategorie] => Öffentlich
)
[11] => Array
(
[object_id] => 10
[id] => 6319
[post_title] => Freiberg singt
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6319
[datum] => 2024-09-01 14:00:00
[kategorie] => Öffentlich
)
[12] => Array
(
[object_id] => 10
[id] => 6321
[post_title] => Konzert Reha-Klinik
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6321
[datum] => 2024-09-12 19:00:00
[kategorie] => Öffentlich
)
[13] => Array
(
[object_id] => 10
[id] => 6325
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6325
[datum] => 2024-10-24 19:00:00
[kategorie] => Öffentlich
)
[14] => Array
(
[object_id] => 10
[id] => 6329
[post_title] => Weihnachtskonzert Reha-Klinik
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6329
[datum] => 2024-12-05 19:00:00
[kategorie] => Öffentlich
)
[15] => Array
(
[object_id] => 10
[id] => 6331
[post_title] => Adventskonzert St. Annenkirche
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6331
[datum] => 2024-12-15 15:00:00
[kategorie] => Öffentlich
)
[16] => Array
(
[object_id] => 10
[id] => 6351
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6351
[datum] => 2024-05-02 17:00:00
[kategorie] => Öffentlich
)
[17] => Array
(
[object_id] => 10
[id] => 6373
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6373
[datum] => 2024-05-02 19:15:00
[kategorie] => Öffentlich
)
)