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