" "
Home » Jobs-by-location
Browse Jobs by City

    Error: SELECT tbl_city.city,tbl_city.cityurl,COUNT( tbl_jobs.city_id ),tbl_jobs.status AS city_id FROM ( tbl_city INNER JOIN tbl_jobs ON tbl_city.city_id = tbl_jobs.city_id ) where tbl_jobs.status=1 GROUP BY city HAVING COUNT( tbl_jobs.city_id ) ORDER BY COUNT( tbl_jobs.city_id) DESC

    Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jobsdikh_main.tbl_city.cityurl' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by