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