select `post`.*,`medias`.`m_img`,`categories`.`cat_name`,`cat_b`.`m_img` as `cat_banner` from `post` left join `medias` on `medias`.`i_id`=`post`.`t_img`left join `categories` on `categories`.`id`=`post`.`cat_id` left join `medias` cat_b on `cat_b`.`i_id`=`categories`.`b_img` WHERE `post`.`post_type`="destination" and `post`.`hide_pro`=0 and `post`.`url_name`="atlants-the-palm"
Atlants - The Palm
This is one of dubai's luxurious hotel resort, situated on the heart of palm jumeriah and surrounded by many international hotel chains. palm jumeriah is one of the man made islands in dubai.
+971 52 221 4480
