Database error: Invalid SQL: select distinct SUBSTRING(cityname,1,1) as a from lr_city where countryid='IN' order by cityname ERROR: 1054
MySQL Error: 1054 (Unknown column 'countryid' in 'where clause')
Session halted.