Java Developer Jobs in Hyderabad

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0,20)' at line 3

(SELECT c1.catg_id, CONCAT('Fresher ', a1.catgName) as catgName, CONCAT(a1.flnm, '-fresher') as flnm, a1.slno, c1.counter, CONCAT('Fresher ', a1.disp_catg_name) as disp_catg_name, d1.state_city_name, d1.disp_name, d1.file_name from category_tbl as a1 inner join fresher_catg_loc_job_counter as c1 on c1.catg_id=a1.slno inner join state_new as d1 on d1.slno=c1.city_state_country WHERE c1.city_state_country IN ('100067') && c1.city_type='1' && c1.catg_id='101744' && a1.catg_type IN ('3','4') && c1.counter>5 && a1.main_catg_status!='1' GROUP BY c1.catg_id ORDER BY c1.counter DESC LIMIT 0,1) UNION (SELECT c1.catg_id, a1.catgName, a1.flnm, a1.slno, c1.counter, a1.disp_catg_name, d1.state_city_name, d1.disp_name, d1.file_name from category_tbl as a1 inner join catg_loc_job_counter as c1 on c1.catg_id=a1.slno inner join state_new d1 on d1.slno=c1.city_state_country WHERE c1.city_state_country IN ('') && c1.city_state_country!='100067' && c1.city_type='1' && c1.catg_id='101744' && a1.catg_type IN ('3','4') && c1.counter>5 && a1.main_catg_status!='1' GROUP BY c1.city_state_country ORDER BY FIELD (c1.city_state_country,) LIMIT 0,20)

[TEP STOP]