SELECT CompanySlug, CategorySlug, CitySlug, EmploymentType, count(*) as Total FROM wp_wms_jobs WHERE IsClone = 'No' GROUP BY CompanySlug, CategorySlug, CitySlug,EmploymentType<br>-----------------<br>