select * from dir_cities where state_id= and (listings or legacy_cnt) order by name