Anwesenheitsplanung

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] => 6305
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6305
[datum] => 2024-03-07 19:15:00
[kategorie] => Probe
)

[1] => Array
(
[object_id] => 8
[id] => 6307
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6307
[datum] => 2024-03-14 19:15:00
[kategorie] => Probe
)

[2] => Array
(
[object_id] => 8
[id] => 6311
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6311
[datum] => 2024-03-28 19:15:00
[kategorie] => Probe
)

[3] => 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
)

[4] => Array
(
[object_id] => 8
[id] => 6353
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6353
[datum] => 2024-04-11 17:00:00
[kategorie] => Probe
)

[5] => Array
(
[object_id] => 8
[id] => 6355
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6355
[datum] => 2024-04-18 17:00:00
[kategorie] => Probe
)

[6] => Array
(
[object_id] => 8
[id] => 6357
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6357
[datum] => 2024-03-07 17:00:00
[kategorie] => Probe
)

[7] => Array
(
[object_id] => 8
[id] => 6359
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6359
[datum] => 2024-03-14 17:00:00
[kategorie] => Probe
)

[8] => Array
(
[object_id] => 8
[id] => 6361
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6361
[datum] => 2024-04-25 17:00:00
[kategorie] => Probe
)

[9] => Array
(
[object_id] => 8
[id] => 6365
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6365
[datum] => 2024-04-04 19:15:00
[kategorie] => Probe
)

[10] => Array
(
[object_id] => 8
[id] => 6367
[post_title] => Öffentliche Stimmgruppen-Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6367
[datum] => 2024-04-11 19:15:00
[kategorie] => Probe
)

[11] => Array
(
[object_id] => 8
[id] => 6369
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6369
[datum] => 2024-04-18 19:15:00
[kategorie] => Probe
)

[12] => Array
(
[object_id] => 8
[id] => 6371
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6371
[datum] => 2024-04-25 19:15:00
[kategorie] => Probe
)

[13] => 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
)

[14] => Array
(
[object_id] => 9
[id] => 6303
[post_title] => Konzert Rehaklinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6303
[datum] => 2024-02-29 19:00:00
[kategorie] => Auftritt
)

[15] => Array
(
[object_id] => 9
[id] => 6309
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6309
[datum] => 2024-03-21 19:00:00
[kategorie] => Auftritt
)

[16] => 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
)

[17] => 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
)

[18] => 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
)

[19] => 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
)

[20] => 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
)

[21] => 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
)

[22] => 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
)

[23] => Array
(
[object_id] => 10
[id] => 6303
[post_title] => Konzert Rehaklinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6303
[datum] => 2024-02-29 19:00:00
[kategorie] => Öffentlich
)

[24] => Array
(
[object_id] => 10
[id] => 6305
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6305
[datum] => 2024-03-07 19:15:00
[kategorie] => Öffentlich
)

[25] => Array
(
[object_id] => 10
[id] => 6307
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6307
[datum] => 2024-03-14 19:15:00
[kategorie] => Öffentlich
)

[26] => Array
(
[object_id] => 10
[id] => 6309
[post_title] => Konzert Reha-Klinik Hetzdorf
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6309
[datum] => 2024-03-21 19:00:00
[kategorie] => Öffentlich
)

[27] => Array
(
[object_id] => 10
[id] => 6311
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6311
[datum] => 2024-03-28 19:15:00
[kategorie] => Öffentlich
)

[28] => 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
)

[29] => 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
)

[30] => 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
)

[31] => 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
)

[32] => 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
)

[33] => 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
)

[34] => 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
)

[35] => 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
)

[36] => Array
(
[object_id] => 10
[id] => 6353
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6353
[datum] => 2024-04-11 17:00:00
[kategorie] => Öffentlich
)

[37] => Array
(
[object_id] => 10
[id] => 6355
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6355
[datum] => 2024-04-18 17:00:00
[kategorie] => Öffentlich
)

[38] => Array
(
[object_id] => 10
[id] => 6357
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6357
[datum] => 2024-03-07 17:00:00
[kategorie] => Öffentlich
)

[39] => Array
(
[object_id] => 10
[id] => 6359
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6359
[datum] => 2024-03-14 17:00:00
[kategorie] => Öffentlich
)

[40] => Array
(
[object_id] => 10
[id] => 6361
[post_title] => Probe chOHRwürmer
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6361
[datum] => 2024-04-25 17:00:00
[kategorie] => Öffentlich
)

[41] => Array
(
[object_id] => 10
[id] => 6365
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6365
[datum] => 2024-04-04 19:15:00
[kategorie] => Öffentlich
)

[42] => Array
(
[object_id] => 10
[id] => 6367
[post_title] => Öffentliche Stimmgruppen-Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6367
[datum] => 2024-04-11 19:15:00
[kategorie] => Öffentlich
)

[43] => Array
(
[object_id] => 10
[id] => 6369
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6369
[datum] => 2024-04-18 19:15:00
[kategorie] => Öffentlich
)

[44] => Array
(
[object_id] => 10
[id] => 6371
[post_title] => Öffentliche Probe
[guid] => http://www.chor-hetzdorf.de/?post_type=tribe_events&p=6371
[datum] => 2024-04-25 19:15:00
[kategorie] => Öffentlich
)

[45] => 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
)

)