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 = '1658.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
The lovely shop, with the floor made of pine and takamaka wood, offers many souvenirs of good taste, packed with art in the same natural spirit. Nice collection of pareos, shorts, shirts, dockers and t-shirts (with a beautiful cotton of 180 G), sandals with shells, coconut lampshades, soaps with local flavours (lemongrass, ylang-ylang, vanilla...).
Here you are in good company with the friendly designer Nichole-Johnston.
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!!!