CFHT: comparison to SDSS, SN vs mag