SELECT m.id, name_pic Name,thumbnail_name thumbnail,img_name picture, m.id mediaID, m.status, m.title, c.id clientID,m.position_order positionOrder, m.promo Promo
FROM clients c
LEFT JOIN medias m ON c.user_id = m.user_id
WHERE c.id = '382.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Anse Forbans | Beaches
Swimming | Sunshine
Anse Forbans / South East Mahe | Mahe
23.7 km from Victoria / 14.4 km from Airport
Half km long and narrow stretch of soft sand beach with coral stones Accessible to the public like all Seychelles beaches Safe for swimming, except for the Southern part Beautiful sunshine, azure colors by sunny time Historical bay discovered by the legendary pirate, La Buse
By creating seychellespromo.com, our primary goal is to build a platform that will allow all users to find the information they are looking for within 3 clicks.
As a second step, our target is to bring a real contribution to the development of Seychelles tourism at a national and international level.
Because locals and visitors deserve it...
A Multimedia (SEYCHELLES) initiative!!!