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 = '474.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Kenwynn House | Places of Interest
Monument | 1855
Francis Rachel St - Victoria / Mahe | Mahe
1.0 km from Victoria / 8.8 km from Airport
Renovated french colonial home built from wood in 1855
Historic monument surrounded by a beautiful tropical garden
Souvenirs shop with books, locally made jewellery/craft, fine jewellery
Art gallery for local artists (one different artist every month)
Mon-Fri: 9am-5pm / Sat: 9am-1pm