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 = '400.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Glacis Beach | Beaches
View | Fishermen
Glacis Beach / North Mahe | Mahe
9.1 km from Victoria / 18.3 km from Airport
Lovely small beach shaded by pine trees and Takamaka trees Local fishermen each morning before dawn View on the west coast of Mahe, Silhouette and North Island Difficult swimming due to rocks in the wate
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!!!