Query body: WHERE a.published = 1 AND a.is_status = 5 AND a.salaries = 31 AND ( (a.name LIKE '%%') OR (b.company_name LIKE '%%') OR (a.alias LIKE '%%') )

SELECT id,name FROM fs_cities WHERE  published = 1  ORDER BY  ordering ASC