SELECT id_franchise FROM bm_franchises WHERE url LIKE 'reds.bwisl.ca%' LIMIT 1