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] => 6051
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6051
[datum] => 2023-10-05 19:15:00
[kategorie] => Probe
)
[1] => Array
(
[object_id] => 8
[id] => 6053
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6053
[datum] => 2023-10-12 19:15:00
[kategorie] => Probe
)
[2] => Array
(
[object_id] => 8
[id] => 6055
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6055
[datum] => 2023-10-26 19:15:00
[kategorie] => Probe
)
[3] => Array
(
[object_id] => 8
[id] => 6057
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6057
[datum] => 2023-11-02 19:15:00
[kategorie] => Probe
)
[4] => Array
(
[object_id] => 8
[id] => 6060
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6060
[datum] => 2023-11-16 19:15:00
[kategorie] => Probe
)
[5] => Array
(
[object_id] => 8
[id] => 6062
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6062
[datum] => 2023-11-23 19:15:00
[kategorie] => Probe
)
[6] => Array
(
[object_id] => 8
[id] => 6064
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6064
[datum] => 2023-11-30 19:15:00
[kategorie] => Probe
)
[7] => Array
(
[object_id] => 8
[id] => 6066
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6066
[datum] => 2023-12-07 19:15:00
[kategorie] => Probe
)
[8] => Array
(
[object_id] => 8
[id] => 6068
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6068
[datum] => 2023-11-09 19:15:00
[kategorie] => Probe
)
[9] => Array
(
[object_id] => 8
[id] => 6071
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6071
[datum] => 2023-10-26 17:15:00
[kategorie] => Probe
)
[10] => Array
(
[object_id] => 8
[id] => 6073
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6073
[datum] => 2023-11-02 17:15:00
[kategorie] => Probe
)
[11] => Array
(
[object_id] => 8
[id] => 6075
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6075
[datum] => 2023-11-09 17:15:00
[kategorie] => Probe
)
[12] => Array
(
[object_id] => 8
[id] => 6079
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6079
[datum] => 2023-11-16 17:15:00
[kategorie] => Probe
)
[13] => Array
(
[object_id] => 8
[id] => 6081
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6081
[datum] => 2023-11-23 17:15:00
[kategorie] => Probe
)
[14] => Array
(
[object_id] => 8
[id] => 6083
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6083
[datum] => 2023-11-30 17:15:00
[kategorie] => Probe
)
[15] => Array
(
[object_id] => 8
[id] => 6085
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6085
[datum] => 2023-12-07 17:30:00
[kategorie] => Probe
)
[16] => Array
(
[object_id] => 8
[id] => 6087
[post_title] => Konzertprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6087
[datum] => 2023-12-15 19:00:00
[kategorie] => Probe
)
[17] => Array
(
[object_id] => 8
[id] => 6089
[post_title] => Proben-Wochenende
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6089
[datum] => 2023-11-03 18:00:00
[kategorie] => Probe
)
[18] => Array
(
[object_id] => 9
[id] => 5456
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=5456
[datum] => 2023-10-19 19:00:00
[kategorie] => Auftritt
)
[19] => Array
(
[object_id] => 9
[id] => 5458
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=5458
[datum] => 2023-11-27 19:00:00
[kategorie] => Auftritt
)
[20] => Array
(
[object_id] => 9
[id] => 5460
[post_title] => Adventskonzert in der St. Annenkirche Niederschöna
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=5460
[datum] => 2023-12-17 15:00:00
[kategorie] => Auftritt
)
[21] => Array
(
[object_id] => 10
[id] => 5456
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=5456
[datum] => 2023-10-19 19:00:00
[kategorie] => Öffentlich
)
[22] => Array
(
[object_id] => 10
[id] => 5458
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=5458
[datum] => 2023-11-27 19:00:00
[kategorie] => Öffentlich
)
[23] => Array
(
[object_id] => 10
[id] => 5460
[post_title] => Adventskonzert in der St. Annenkirche Niederschöna
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=5460
[datum] => 2023-12-17 15:00:00
[kategorie] => Öffentlich
)
[24] => Array
(
[object_id] => 10
[id] => 6051
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6051
[datum] => 2023-10-05 19:15:00
[kategorie] => Öffentlich
)
[25] => Array
(
[object_id] => 10
[id] => 6053
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6053
[datum] => 2023-10-12 19:15:00
[kategorie] => Öffentlich
)
[26] => Array
(
[object_id] => 10
[id] => 6055
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6055
[datum] => 2023-10-26 19:15:00
[kategorie] => Öffentlich
)
[27] => Array
(
[object_id] => 10
[id] => 6057
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6057
[datum] => 2023-11-02 19:15:00
[kategorie] => Öffentlich
)
[28] => Array
(
[object_id] => 10
[id] => 6060
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6060
[datum] => 2023-11-16 19:15:00
[kategorie] => Öffentlich
)
[29] => Array
(
[object_id] => 10
[id] => 6062
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6062
[datum] => 2023-11-23 19:15:00
[kategorie] => Öffentlich
)
[30] => Array
(
[object_id] => 10
[id] => 6064
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6064
[datum] => 2023-11-30 19:15:00
[kategorie] => Öffentlich
)
[31] => Array
(
[object_id] => 10
[id] => 6066
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6066
[datum] => 2023-12-07 19:15:00
[kategorie] => Öffentlich
)
[32] => Array
(
[object_id] => 10
[id] => 6068
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6068
[datum] => 2023-11-09 19:15:00
[kategorie] => Öffentlich
)
[33] => Array
(
[object_id] => 10
[id] => 6071
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6071
[datum] => 2023-10-26 17:15:00
[kategorie] => Öffentlich
)
[34] => Array
(
[object_id] => 10
[id] => 6073
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6073
[datum] => 2023-11-02 17:15:00
[kategorie] => Öffentlich
)
[35] => Array
(
[object_id] => 10
[id] => 6075
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6075
[datum] => 2023-11-09 17:15:00
[kategorie] => Öffentlich
)
[36] => Array
(
[object_id] => 10
[id] => 6079
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6079
[datum] => 2023-11-16 17:15:00
[kategorie] => Öffentlich
)
[37] => Array
(
[object_id] => 10
[id] => 6081
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6081
[datum] => 2023-11-23 17:15:00
[kategorie] => Öffentlich
)
[38] => Array
(
[object_id] => 10
[id] => 6083
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6083
[datum] => 2023-11-30 17:15:00
[kategorie] => Öffentlich
)
[39] => Array
(
[object_id] => 10
[id] => 6085
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6085
[datum] => 2023-12-07 17:30:00
[kategorie] => Öffentlich
)
[40] => Array
(
[object_id] => 10
[id] => 6087
[post_title] => Konzertprobe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6087
[datum] => 2023-12-15 19:00:00
[kategorie] => Öffentlich
)
[41] => Array
(
[object_id] => 10
[id] => 6089
[post_title] => Proben-Wochenende
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6089
[datum] => 2023-11-03 18:00:00
[kategorie] => Öffentlich
)
)