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 = '1105.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Seychelles Commercial Bank / Victoria | Banks
Independence Ave - Victoria / Mahe | Mahe
0.3 km from Victoria / 9.4 km from Airport
Created more than 100 years ago The Government of Seychelles holding the majority of shares All types of commercial banking facilities Internet Banking, SMS/Mobile Banking Mon- Fri: 9am- 4pm / Sat: 9am- 12noon
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!!!