Error:[SELECT bif.`pref_code` AS 'pref_code' ,COUNT(DISTINCT(bif.`scode`)) AS 'scnums' FROM `base_info` AS bif LEFT JOIN `flags` AS flg ON flg.`scode` = bif.`scode` LEFT JOIN `pref_list` AS prf ON prf.`code` = bif.`pref_code` LEFT JOIN `sponser` AS spr ON spr.`code` = bif.`sponser_code` LEFT JOIN `city_codes` AS ctc ON ctc.`city_code` = bif.`city_code` LEFT JOIN `div` AS dvm ON dvm.`scode` = bif.`scode` LEFT JOIN `div_info` AS dvi ON dvi.`scode` = bif.`scode` LEFT JOIN `senmon_sp` AS ssp ON ssp.`scode` = bif.`scode` LEFT JOIN `src_keywords` AS skw ON skw.`scode` = bif.`scode` LEFT JOIN `guidebook_info` AS gbi ON gbi.`scode` = bif.`scode` LEFT JOIN `menu_flags` AS mnf ON mnf.`scode` = bif.`scode` LEFT JOIN `postit` AS pit ON pit.`scode` = bif.`scode` LEFT JOIN `sen_sps` AS sps ON sps.`scode` = bif.`scode` WHERE bif.`assortment_code` = '4' AND flg.`view_flag` = 1 AND flg.`test_flag` = 0 AND ssp.`ky_bny_` = '1' GROUP BY bif.`pref_code` ] Unknown column 'ssp.ky_bny_' in 'where clause'