Broadcast Calendar
Monday, September 2, 2024
There are no high school broadcasts on September 2, 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...