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] => 6646
[post_title] => Stimmgruppenprobe /Gesamtprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6646
[datum] => 2024-05-16 19:15:00
[kategorie] => Probe
)
[1] => Array
(
[object_id] => 8
[id] => 6648
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6648
[datum] => 2024-05-16 17:00:00
[kategorie] => Probe
)
[2] => Array
(
[object_id] => 8
[id] => 6650
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6650
[datum] => 2024-05-23 17:00:00
[kategorie] => Probe
)
[3] => Array
(
[object_id] => 8
[id] => 6653
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6653
[datum] => 2024-05-23 19:15:00
[kategorie] => Probe
)
[4] => Array
(
[object_id] => 8
[id] => 6655
[post_title] => Generalprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6655
[datum] => 2024-05-25 19:00:00
[kategorie] => Probe
)
[5] => Array
(
[object_id] => 8
[id] => 6657
[post_title] => Stellprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6657
[datum] => 2024-05-26 15:30:00
[kategorie] => Probe
)
[6] => Array
(
[object_id] => 8
[id] => 6660
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6660
[datum] => 2024-05-30 17:00:00
[kategorie] => Probe
)
[7] => Array
(
[object_id] => 8
[id] => 6662
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6662
[datum] => 2024-05-30 19:15:00
[kategorie] => Probe
)
[8] => Array
(
[object_id] => 8
[id] => 6664
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6664
[datum] => 2024-06-06 17:00:00
[kategorie] => Probe
)
[9] => Array
(
[object_id] => 8
[id] => 6666
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6666
[datum] => 2024-06-06 19:15:00
[kategorie] => Probe
)
[10] => Array
(
[object_id] => 8
[id] => 6668
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6668
[datum] => 2024-06-13 17:00:00
[kategorie] => Probe
)
[11] => Array
(
[object_id] => 8
[id] => 6670
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6670
[datum] => 2024-06-13 19:15:00
[kategorie] => Probe
)
[12] => Array
(
[object_id] => 8
[id] => 6672
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6672
[datum] => 2024-06-27 17:00:00
[kategorie] => Probe
)
[13] => Array
(
[object_id] => 8
[id] => 6674
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6674
[datum] => 2024-06-27 19:15:00
[kategorie] => Probe
)
[14] => 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
)
[15] => 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
)
[16] => 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
)
[17] => 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
)
[18] => 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
)
[19] => 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
)
[20] => 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
)
[21] => Array
(
[object_id] => 9
[id] => 6657
[post_title] => Stellprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6657
[datum] => 2024-05-26 15:30:00
[kategorie] => Auftritt
)
[22] => Array
(
[object_id] => 9
[id] => 6678
[post_title] => Weihnachtsmarkt Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6678
[datum] => 2024-12-07 10:00:00
[kategorie] => Auftritt
)
[23] => 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
)
[24] => 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
)
[25] => 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
)
[26] => 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
)
[27] => 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
)
[28] => 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
)
[29] => 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
)
[30] => Array
(
[object_id] => 10
[id] => 6646
[post_title] => Stimmgruppenprobe /Gesamtprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6646
[datum] => 2024-05-16 19:15:00
[kategorie] => Öffentlich
)
[31] => Array
(
[object_id] => 10
[id] => 6648
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6648
[datum] => 2024-05-16 17:00:00
[kategorie] => Öffentlich
)
[32] => Array
(
[object_id] => 10
[id] => 6650
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6650
[datum] => 2024-05-23 17:00:00
[kategorie] => Öffentlich
)
[33] => Array
(
[object_id] => 10
[id] => 6653
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6653
[datum] => 2024-05-23 19:15:00
[kategorie] => Öffentlich
)
[34] => Array
(
[object_id] => 10
[id] => 6655
[post_title] => Generalprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6655
[datum] => 2024-05-25 19:00:00
[kategorie] => Öffentlich
)
[35] => Array
(
[object_id] => 10
[id] => 6657
[post_title] => Stellprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6657
[datum] => 2024-05-26 15:30:00
[kategorie] => Öffentlich
)
[36] => Array
(
[object_id] => 10
[id] => 6660
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6660
[datum] => 2024-05-30 17:00:00
[kategorie] => Öffentlich
)
[37] => Array
(
[object_id] => 10
[id] => 6662
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6662
[datum] => 2024-05-30 19:15:00
[kategorie] => Öffentlich
)
[38] => Array
(
[object_id] => 10
[id] => 6664
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6664
[datum] => 2024-06-06 17:00:00
[kategorie] => Öffentlich
)
[39] => Array
(
[object_id] => 10
[id] => 6666
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6666
[datum] => 2024-06-06 19:15:00
[kategorie] => Öffentlich
)
[40] => Array
(
[object_id] => 10
[id] => 6668
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6668
[datum] => 2024-06-13 17:00:00
[kategorie] => Öffentlich
)
[41] => Array
(
[object_id] => 10
[id] => 6670
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6670
[datum] => 2024-06-13 19:15:00
[kategorie] => Öffentlich
)
[42] => Array
(
[object_id] => 10
[id] => 6672
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6672
[datum] => 2024-06-27 17:00:00
[kategorie] => Öffentlich
)
[43] => Array
(
[object_id] => 10
[id] => 6674
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6674
[datum] => 2024-06-27 19:15:00
[kategorie] => Öffentlich
)
[44] => Array
(
[object_id] => 10
[id] => 6678
[post_title] => Weihnachtsmarkt Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6678
[datum] => 2024-12-07 10:00:00
[kategorie] => Öffentlich
)
)