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`="burj-al-arab"

Burj Al Arab

A most famous tourist attractions in dubai. it is one of the tallest hotels in the world, the shape of the structure is designed to resemble the sail of a ship situated at jumeriah beach, it's a symbol of modern dubai.

© All rights reserved 2024 Leos yacht.