UAE

Post an Ad

2017-05-23 05:49:06

-----SELECT a1.ad_id, `ad_title`, `ad_price`, `ad_main_photo`, `category_id`, `ad_date`, `main_photo_status`, `ad_photo_1`, `photo_1_status`, `ad_photo_2`, `photo_2_status`, `user_id`, `city`, `land_mark`, `ad_photo_3`, `photo_3_status`, `ad_photo_4`, `photo_4_status`, `ad_photo_5`, `photo_5_status`, `ad_photo_6`, `photo_6_status`, `ad_photo_7`, `photo_7_status`, `ad_photo_8`, `photo_8_status`, `ad_photo_9`, `photo_9_status`,`bedroom`,`bathroom`,`area`,`seller_type` FROM `tbl_ad` a1, tbl_ad_field a2 WHERE a1.city='Fujairah' AND a1.ad_featured=0 AND a1.ad_status=1 AND a1.category_id in (1754,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1830) AND a1.ad_id = a2.ad_id group by a1.ad_id ORDER BY a1.ad_id DESC limit 0, 20

0 ads for Job in Fujairah

Featured Ad not Available.

No Ads Found