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`="the-world-islands"

The World Islands

This is an archipelago of small man made islands located in the water of arabian gulf. it is 4 kilometers off the coast of dubai and there are only 2 or 3 of the dubai world islands that are completely functional.

© All rights reserved 2024 Leos yacht.