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 = '61.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Beau Sejour Hotel | Guest Houses
Info
- Bel Air - Victoria / Mahe | Mahe
- 2.1 km from Victoria / 10.7 km from Airport
- 9 inviting rooms and escape the stresses of the day
Family run establishment offering bed & breakfast accommodation
Discover a piece of Seychelles paradise
Enjoy the natural cooling and refreshing breeze on the balcony after a long day touring around Mahe
