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 = '437.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Anse Grosse Roche-La Digue | Beaches
Walk | Sunrise
Anse Grosse Roche / La Digue | La Digue
2.7 km from Jetty
Sharing the same views of the islands as Anse Gaulettes Named after the massive boulder on the north side Not the best place for a swim Nice place to walk or buy a drink from the small shop behind
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!!!