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`="ain-dubai"

Ain Dubai

The worlds tallest ferris wheel situated on blue waters island at dubai marina, the wheel will be able to carry up to 1400 passengers, in it's 48 capsules and provide views of dubai marina, burj al arab, palm jumeriah & burj khalifa.

© All rights reserved 2024 Leos yacht.