select a.* from rynacons_craig1.hockey_camps a where a.assoc_id=40 and a.active='Y' and reg_type='P' order by start_date, league_name