Unknown column 'CategoryID' in 'where clause' : Select count(*) from `Shop` where `Active` = '1' and `CategoryID` = '1'

Unknown column 'CategoryID' in 'where clause' : Select count(*) from `Shop` where `Active` = '1' and `CategoryID` = '2'

Unknown column 'CategoryID' in 'where clause' : Select count(*) from `Shop` where `Active` = '1' and `CategoryID` = '3'

Unknown column 'CategoryID' in 'where clause' : Select count(*) from `Shop` where `Active` = '1' and `CategoryID` = '4'