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 = '365.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Li-al-do Maison | Villas
Info
4 rooms | 0
Anse Takamaka / South West Mahe | Mahe
26.7 km from Victoria / 19.4 km from Airport
Four-bedroom luxury villa overlooking the unspoilt beach of Takamaka bay Elegant style with local and natural objects Infinity pool Dinner upon request Activities can be arranged
