SELECT * FROM framework_entries WHERE company_id = 186 AND file_name = '/Promotions/Movember/'SELECT a.*, b.* FROM framework_entries a, landing_pages b WHERE a.file_name = b.path AND b.path = '/Promotions/Movember/' AND a.company_id = b.store_id AND a.company_id = 186 Swift Current Broncos | It's About Passion...

SELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/' OR a.file_name = '/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/News/%' OR a.file_name = '/News/%%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/' OR a.file_name = '/TEAM/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/Roster/%' OR a.file_name = '/TEAM/Roster/%%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/Board_of_Directors/' OR a.file_name = '/TEAM/Board_of_Directors/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/Hockey_Staff/' OR a.file_name = '/TEAM/Hockey_Staff/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/Scouting_Staff/' OR a.file_name = '/TEAM/Scouting_Staff/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/Office_Staff/' OR a.file_name = '/TEAM/Office_Staff/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TEAM/Other_Staff_and_Volunteers/' OR a.file_name = '/TEAM/Other_Staff_and_Volunteers/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/History/' OR a.file_name = '/History/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/History/Hall_of_Fame/' OR a.file_name = '/History/Hall_of_Fame/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/History/Hall_of_Fame/198889_Memorial_Cup_Team/' OR a.file_name = '/History/Hall_of_Fame/198889_Memorial_Cup_Team/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/History/Bronco_History/' OR a.file_name = '/History/Bronco_History/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/History/4_Broncos_Memorial/' OR a.file_name = '/History/4_Broncos_Memorial/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Schedule/%' OR a.file_name = '/Schedule/%%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/STATISTICS/' OR a.file_name = '/STATISTICS/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/STATISTICS/Bronco_Record_Book/' OR a.file_name = '/STATISTICS/Bronco_Record_Book/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/STATISTICS/Drafted_Broncos/' OR a.file_name = '/STATISTICS/Drafted_Broncos/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/STATISTICS/Bronco_Statistics/' OR a.file_name = '/STATISTICS/Bronco_Statistics/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/STATISTICS/WHL_Statistics/' OR a.file_name = '/STATISTICS/WHL_Statistics/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/' OR a.file_name = '/Multimedia/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/gallery/%' OR a.file_name = '/Multimedia/gallery/%%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Listen_Live/' OR a.file_name = '/Multimedia/Listen_Live/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Awards_Banquet/' OR a.file_name = '/Multimedia/Awards_Banquet/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Breast_Cancer_Jersey_Auction/' OR a.file_name = '/Multimedia/Breast_Cancer_Jersey_Auction/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Trivia_Draw/' OR a.file_name = '/Multimedia/Trivia_Draw/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Broncos_on_Twitter/' OR a.file_name = '/Multimedia/Broncos_on_Twitter/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Mikd_Up_with_Jon_Keen/' OR a.file_name = '/Multimedia/Mikd_Up_with_Jon_Keen/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Rink_Rat_Report/' OR a.file_name = '/Multimedia/Rink_Rat_Report/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/VIP_of_the_Game/%' OR a.file_name = '/Multimedia/VIP_of_the_Game/%%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Press_Roundup/' OR a.file_name = '/Multimedia/Press_Roundup/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/' OR a.file_name = '/TICKETS/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Single_Game_Tickets/' OR a.file_name = '/TICKETS/Single_Game_Tickets/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Season_Tickets/' OR a.file_name = '/TICKETS/Season_Tickets/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/ProRated_Season_Tickets/' OR a.file_name = '/TICKETS/ProRated_Season_Tickets/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Corporate_Suite_Rental/' OR a.file_name = '/TICKETS/Corporate_Suite_Rental/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Flex_Packs/' OR a.file_name = '/TICKETS/Flex_Packs/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Mini__Themed_Packs/' OR a.file_name = '/TICKETS/Mini__Themed_Packs/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Groups_and_Birthdays/' OR a.file_name = '/TICKETS/Groups_and_Birthdays/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Arena_Map/' OR a.file_name = '/TICKETS/Arena_Map/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/TICKETS/Fundraising_Opportunties/' OR a.file_name = '/TICKETS/Fundraising_Opportunties/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/' OR a.file_name = '/Promotions/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/Game_Night_Promotions/' OR a.file_name = '/Promotions/Game_Night_Promotions/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/5050_Winners/' OR a.file_name = '/Promotions/5050_Winners/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/Movember/' OR a.file_name = '/Promotions/Movember/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/Lottery_Calendar/' OR a.file_name = '/Promotions/Lottery_Calendar/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/Lottery_Calendar/Lottery_Winners/' OR a.file_name = '/Promotions/Lottery_Calendar/Lottery_Winners/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Multimedia/Kids_Zone/' OR a.file_name = '/Multimedia/Kids_Zone/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/Promotions/Donation_Requests/' OR a.file_name = '/Promotions/Donation_Requests/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/CORPORATE/' OR a.file_name = '/CORPORATE/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/CORPORATE/Sponsors/' OR a.file_name = '/CORPORATE/Sponsors/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/CORPORATE/Marketing_Opportunities/' OR a.file_name = '/CORPORATE/Marketing_Opportunities/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/CORPORATE/Employment_Opportunity/' OR a.file_name = '/CORPORATE/Employment_Opportunity/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT b.*, c.link, c.target FROM framework_entries a, framework_entries b LEFT OUTER JOIN external c ON (c.path = b.file_name AND c.store_id = b.company_id) WHERE (a.file_name = '/CORPORATE/Contact/' OR a.file_name = '/CORPORATE/Contact/%') AND a.company_id = b.company_id AND a.entry_id = b.parent_id AND b.exclude_navigation = 'N' AND a.company_id = 186 AND (b.release_date < now() or b.release_date = '0000-00-00' or b.release_date is null) AND (b.end_date > now() or b.end_date = '0000-00-00' or b.end_date is null)ORDER BY b.sort_orderSELECT * FROM framework_entries WHERE company_id = 186 AND file_name = '/' HOME NEWS TEAM HISTORY SCHEDULE STATISTICS FAN ZONE TICKETS PROMOTIONS CORPORATE THE STABLE

Movember

Movember is Male Cancer Awareness Month

During November, the Broncos raised awareness for all forms of male cancer by growing moustaches for the entire month to support the cause.

The total donation made to the Canadian Cancer Society from the Broncos for Movember was $2905.00.

Check the Broncos website link below for weekly Moustache pictures.

http://www.scbroncos.com/Multimedia/gallery/CategoryShow/?gallery_id=1&category_id=246