Broadcast Calendar
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 |
Tuesday, December 17, 2024
There are no high school broadcasts on December 17, 2024.
WordPress database error: [Incorrect DATETIME value: '']SELECT distinct mb.id broadcast_id, mb.external_link, mb.title title, me.title as eventtitle,
mb.aud_vid_type, msasta.name stationname, msasta.logo_filename stationlogo, mb.pin,
mb.start_date_time, mb.end_date_time, mb.broadcast_type_id, ms.id sport,
mt1.sport_id, mg.name gender,
msc1.name homename, month(mb.start_date_time) month, mb.gotw,
DAYOFMONTH(mb.start_date_time) day, YEAR(mb.start_date_time) year, ms.name as sportname
FROM msa_broadcast mb
left join `msa_event` me on me.id = mb.event_id
left join msa_event_team met1 on met1.event_id = me.id and met1.home = 'Y'
left join msa_team mt1 on mt1.id = met1.team_id
left join msa_school msc1 on msc1.id = mt1.school_id
left join msa_gender mg on mg.id = mt1.gender_id
left join msa_sport ms on ms.id = mt1.sport_id
left join msa_station msasta on msasta.id = mb.station_id
WHERE mb.start_date_time <> ''
AND mb.start_date_time IS NOT NULL
AND LEFT(mb.start_date_time, 10) <= NOW()
ORDER BY mb.start_date_time DESC, sportname, mb.aud_vid_type DESC LIMIT 20
Broadcasts
- Loading...