SELECT c.channel_name, c.channel_countries, COUNT(*) AS record_count
                FROM epg_data_3 e
                JOIN chnl_ref c ON e.channel_id = c.channel_id WHERE  (e.prog_st_time >= '2024-09-12 00:00:00' and e.prog_ed_time <= '2024-09-12 23:59:59') and  LOWER(e.prog_title) LIKE '%rugby%' GROUP BY c.channel_name, c.channel_countries