Query body: WHERE a.published = 1 AND a.is_status = 5 AND DATEDIFF(NOW(), a.created_time) <= (1 * 7) 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