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 = '409.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Sunset Beach | Beaches
Swimming | Sunset
Sunset Beach / North Mahe | Mahe
7.5 km from Victoria / 16.7 km from Airport
Small beach closed to the Sunset Beach Hotel Access by taking a path from the main Rd or by the hotel car park Swimming, good snorkelling along the rocks Very relaxing under the palm trees Breathtaking sunsets, waves during certain periods
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!!!