On-Air Sports : WJPA 95.3 FM/1450AM – Music, Sports and News Radio

On-Air Sports

Search WJPA

December 2024

2023 Nov December 2024 Jan 2025

N.	Query	Duration, ms	Row Count
1	SELECT `p`.*, `e`.`post_id`, `i`.`id` AS `instance_id`, `i`.`start` AS `start`, `i`.`end` AS `end`, `e`.`timezone_name` AS `timezone_name`, `e`.`allday` AS `event_allday`, `e`.`recurrence_rules`, `e`.`exception_rules`, `e`.`recurrence_dates`, `e`.`exception_dates`, `e`.`venue`, `e`.`country`, `e`.`address`, `e`.`city`, `e`.`province`, `e`.`postal_code`, `e`.`instant_event`, `e`.`show_map`, `e`.`contact_name`, `e`.`contact_phone`, `e`.`contact_email`, `e`.`contact_url`, `e`.`cost`, `e`.`ticket_url`, `e`.`ical_feed_url`, `e`.`ical_source_url`, `e`.`ical_organizer`, `e`.`ical_contact`, `e`.`ical_uid`, `e`.`longitude`, `e`.`latitude` FROM wp_ai1ec_events e INNER JOIN wp_posts p ON ( `p`.`ID` = `e`.`post_id` ) INNER JOIN wp_ai1ec_event_instances i ON ( `e`.`post_id` = `i`.`post_id` ) LEFT JOIN `wp_term_relationships` AS `term_relationships_events_categories` ON ( `e` . `post_id` = `term_relationships_events_categories` . `object_id` ) LEFT JOIN `wp_term_taxonomy` AS `term_taxonomy_events_categories` ON (`term_relationships_events_categories` . `term_taxonomy_id` = `term_taxonomy_events_categories` . `term_taxonomy_id` AND `term_taxonomy_events_categories` . taxonomy = 'events_categories' ) WHERE post_type = 'ai1ec_event' AND i.end > 1733029200 AND i.start < 1735707600 AND( term_taxonomy_events_categories.term_id IN ( 11 ) ) AND post_status = 'publish' GROUP BY `i`.`id` ORDER BY `e` . `allday` DESC, `i` . `start` ASC, `p` . `post_title` ASC	2.51	13
2	SELECT `term_id`, `term_image`, `term_color` FROM `wp_ai1ec_event_category_meta`	0.13	21
Total time, ms: 2.64

Query

Duration, ms

Row Count

SELECT `p`.*, `e`.`post_id`, `i`.`id` AS `instance_id`, `i`.`start` AS `start`, `i`.`end` AS `end`, `e`.`timezone_name` AS `timezone_name`, `e`.`allday` AS `event_allday`, `e`.`recurrence_rules`, `e`.`exception_rules`, `e`.`recurrence_dates`, `e`.`exception_dates`, `e`.`venue`, `e`.`country`, `e`.`address`, `e`.`city`, `e`.`province`, `e`.`postal_code`, `e`.`instant_event`, `e`.`show_map`, `e`.`contact_name`, `e`.`contact_phone`, `e`.`contact_email`, `e`.`contact_url`, `e`.`cost`, `e`.`ticket_url`, `e`.`ical_feed_url`, `e`.`ical_source_url`, `e`.`ical_organizer`, `e`.`ical_contact`, `e`.`ical_uid`, `e`.`longitude`, `e`.`latitude` FROM wp_ai1ec_events e INNER JOIN wp_posts p ON ( `p`.`ID` = `e`.`post_id` ) INNER JOIN wp_ai1ec_event_instances i ON ( `e`.`post_id` = `i`.`post_id` ) LEFT JOIN `wp_term_relationships` AS `term_relationships_events_categories` ON ( `e` . `post_id` = `term_relationships_events_categories` . `object_id` ) LEFT JOIN `wp_term_taxonomy` AS `term_taxonomy_events_categories` ON (`term_relationships_events_categories` . `term_taxonomy_id` = `term_taxonomy_events_categories` . `term_taxonomy_id` AND `term_taxonomy_events_categories` . taxonomy = 'events_categories' ) WHERE post_type = 'ai1ec_event' AND i.end > 1733029200 AND i.start < 1735707600 AND( term_taxonomy_events_categories.term_id IN ( 11 ) ) AND post_status = 'publish' GROUP BY `i`.`id` ORDER BY `e` . `allday` DESC, `i` . `start` ASC, `p` . `post_title` ASC

2.51

SELECT `term_id`, `term_image`, `term_color` FROM `wp_ai1ec_event_category_meta`

0.13

Total time, ms: 2.64

6

Mountain West Championship: UNLV at Boise St. 7:30 pm

Mountain West Championship: UNLV at Boise St.
Dec 6 @ 7:30 pm

Tickets

7

SEC Championship: #2 Texas vs. #5 Georgia 3:30 pm

SEC Championship: #2 Texas vs. #5 Georgia
Dec 7 @ 3:30 pm

Tickets

14

Army vs. Navy 2:00 pm

Army vs. Navy
Dec 14 @ 2:00 pm

Tickets

Salute to Veterans Bowl: South Alabama vs. Western Michigan 9:00 pm

Salute to Veterans Bowl: South Alabama vs. Western Michigan
Dec 14 @ 9:00 pm

Tickets

17

Frisco Bowl: West Virginia vs. Memphis 9:00 pm

Frisco Bowl: West Virginia vs. Memphis
Dec 17 @ 9:00 pm

Tickets

20

Cure Bowl: Ohio vs. Jacksonville State 12:00 pm

Cure Bowl: Ohio vs. Jacksonville State
Dec 20 @ 12:00 pm

Tickets

Gasparilla Bowl: Florida vs. Tulane 3:30 pm

Gasparilla Bowl: Florida vs. Tulane
Dec 20 @ 3:30 pm

Tickets

23

Myrtle Beach Bowl: Coastal Carolina vs. UT-San Antonio 11:00 am

Myrtle Beach Bowl: Coastal Carolina vs. UT-San Antonio
Dec 23 @ 11:00 am

Tickets

Famous Idaho Potato Bowl: Northern Illinois vs. Fresno State 2:30 pm

Famous Idaho Potato Bowl: Northern Illinois vs. Fresno State
Dec 23 @ 2:30 pm

Tickets

26

GameAbove Sports Bowl: Pitt vs. Toledo 2:00 pm

GameAbove Sports Bowl: Pitt vs. Toledo
Dec 26 @ 2:00 pm

Tickets

27

Armed Forces Bowl: Navy vs. Oklahoma 12:00 pm

Armed Forces Bowl: Navy vs. Oklahoma
Dec 27 @ 12:00 pm

Tickets

Birmingham Bowl: Georgia Tech vs. Vanderbilt 3:30 pm

Birmingham Bowl: Georgia Tech vs. Vanderbilt
Dec 27 @ 3:30 pm

Tickets

31

Texas Bowl: Baylor vs. LSU 3:30 pm

Texas Bowl: Baylor vs. LSU
Dec 31 @ 3:30 pm

Tickets