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 ( 9 ) ) AND post_status = 'publish' GROUP BY `i`.`id` ORDER BY `e` . `allday` DESC, `i` . `start` ASC, `p` . `post_title` ASC	1.52	5
2	SELECT `term_id`, `term_image`, `term_color` FROM `wp_ai1ec_event_category_meta`	0.05	21
Total time, ms: 1.57

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 ( 9 ) ) AND post_status = 'publish' GROUP BY `i`.`id` ORDER BY `e` . `allday` DESC, `i` . `start` ASC, `p` . `post_title` ASC

1.52

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

0.05

Total time, ms: 1.57

1

Steelers @ Cincinnati Bengals 12:00 pm

Steelers @ Cincinnati Bengals
Dec 1 @ 12:00 pm

Tickets

8

Steelers vs. Cleveland Browns 12:00 pm

Steelers vs. Cleveland Browns
Dec 8 @ 12:00 pm

Tickets

15

Steelers @ Philadelphia Eagles 2:25 pm

Steelers @ Philadelphia Eagles
Dec 15 @ 2:25 pm

Tickets

21

Steelers @ Baltimore Ravens 4:00 pm

Steelers @ Baltimore Ravens
Dec 21 @ 4:00 pm

Tickets

25

Steelers vs. Kansas City Chiefs 11:00 am

Steelers vs. Kansas City Chiefs
Dec 25 @ 11:00 am

Tickets