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`="moon-island"

Moon Island

Moon island is one of those relatively lesser-known spots. trips to moon island is a heart breathing & adventurous. it is located 70kms away from dubai beach, the island looks like a crescent moon shape.

© All rights reserved 2024 Leos yacht.