SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='529'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='530'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='531'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='532'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='533'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='537'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1204'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1205'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1206'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1218'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1238'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1007'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1154'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1155'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1001'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1002'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1005'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1009'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1092'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1011'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1012'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1015'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1016'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1017'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1018'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1019'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1096'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1095'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1093'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1031'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1094'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1033'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1034'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1035'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1036'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1037'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1045'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1044'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1043'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1127'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1097'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1148'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1149'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1150'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1151'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1152'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1153'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1141'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1142'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1143'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1144'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1266'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1344'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1349'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1361'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1362'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1363'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1395'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1396'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1397'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1458'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1561'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1683'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1700'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1733'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1837'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1838'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1898'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='1999'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2116'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2118'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2123'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2289'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2361'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2373'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2374'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2375'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2435'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2440'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2444'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2445'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2480'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2496'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2498'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2500'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2502'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2504'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2506'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2507'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2508'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2509'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2510'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2511'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2512'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2513'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2514'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2515'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2516'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2517'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2518'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2519'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2520'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2521'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2522'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2523'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2524'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2526'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2527'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2528'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2529'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2530'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2531'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2532'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2533'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2534'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2535'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2536'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2553'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2670'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2570'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2621'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2623'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2642'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2719'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2720'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2795'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2768'

SELECT * FROM banner LEFT JOIN banner_category ON banner_category.banner=banner_id LEFT JOIN banner_columnist ON banner_columnist.banner=banner_id WHERE (cat=1 OR cat=-1) AND (col=-1) AND banner_vis=1 AND banner_parent='2777'

Emlak sektöründe çığır açacak - Kıbrıs haberleri Kıbrıs Postası'nda okunur
Ana Sayfa >> EMLAK 1 Kasım 2017, Çarşamba 17:14
Emlak sektöründe çığır açacak
Eurocoast Group ile Creditwest Bank’ın işbirliğinde Kuzey Kıbrıs’ta emlak sektöründe çığır açacak bir döneme giriliyor. Creditwest Bank tarafından yerli ve yabancılara yönelik uzun vadeli konut kredilerinin yanı sıra proje finansman garantisi de sağlanıyor.
Paylaş  
16
23
17
1

Eurocoast Group ile Creditwest Bank’ın işbirliğinde Kuzey Kıbrıs’ta emlak sektöründe çığır açacak bir döneme giriliyor. Creditwest Bank tarafından yerli ve yabancılara yönelik uzun vadeli konut kredilerinin yanı sıra proje finansman garantisi de sağlanıyor.

Emlak sektöründe 15 yıllık deneyimi olan Eurocoast Group, Girne’deki en gözde projesi The V Premium Living Kyrenia rezidans projesi için Creditwest Bank ile işbirliği anlaşması imzaladı. Anlaşma uyarınca Creditwest Bank, Eurocoast Group’un The V Kyrenia projesine finansman garantisi sağlıyor. Creditwest Bank, sadece proje finansman garantisi sağlamakla kalmayıp The V Kyrenia’nın satışına da destek olarak çok özel koşullarda konut kredileri sağlıyor. Credithome ve Credithome Mortgage adı altında hem yerli hem yabancılara yönelik sunulan ev kredileri ile The V Kyrenia’dan ev sahibi olmak isteyenlere 180 aya varan vadelerle projeye özel kredilendirme olanağı sağlanıyor.

İlk kez lüks segmentte bir rezidans projesine finansman garantisi sağlanmasına ek olarak, yerli halkın yanı sıra özellikle yabancılara konut kredisi imkanı sunan söz konusu işbirliği anlaşmasına ilişkin detaylar ise, önümüzdeki günlerde düzenlenecek bir lansman etkinliği ile kamuoyuna duyurulacak.

FRİEDMAN: “KUZEY KIBRIS İÇİN İDEAL BİR MODEL OLAN BU İŞBİRLİĞİ, SEKTÖRÜN TÜMÜNE FAYDA SAĞLAYACAK”

‘‘Kişisel Bir Dokunuşla Mükemmellik’’ sloganına sahip ödüllü bir inşaat ve turizm şirketi olan Eurocoast Group’un CEO’su Benzion Friedman, Kuzey Kıbrıs’ta bir ilki gerçekleştirerek Girne’nin kalbinde gerçek lüks deneyimini sunacak olan The V Kyrenia için Creditwest Bank ile yaptıkları bu önemli işbirliği sayesinde hem yatırımcı, hem müşteri, hem de banka olarak tüm paydaşları garanti altına alan ideal bir model yaratıldığının altını çizerek, bu yeni modelin emlak sektöründe çığır açacak potansiyele sahip olduğunu belirtti. Friedman ayrıca, Girne’nin artan konaklama ihtiyaçlarına çözüm olarak üretilen kısa dönemli kiralama modelleriyle, The V Kyrenia’nın yatırımı yüksek oranda müşteriye geri kazandırma potansiyeline sahip olduğunu ve Kuzey Kıbrıs’ın en lüks konut projesini ulaşılabilir kıldıklarını vurguladı.

ZAHEER: “BAŞARILI BANKACILIK FAALİYETLERİMİZE BİR YENİSİNİ DAHA EKLEDİK”

Konu ile ilgili bilgi veren Creditwest Bank Genel Müdürü Mazher Zaheer, mükemmelliğe adanmış dünya standartlarında bir banka olma ve müşterilerin beklentilerini aşma vizyonu ile başarılı bankacılık faaliyetlerine bir yenisini daha eklediklerini kaydetti. Tüm paydaşları garanti altına alan yeni bir model geliştirdiklerini belirten Zaheer, bu ideal modelin sektöre yön vereceğinden şüphesi olmadığının altını çizdi. Zaheer: “Girne’de çok özel ve lüks bir proje olan The V Kyrenia için yoğun çalışmalar sonucunda hazırladığımız proje finansman garantisi anlaşması ile hem bireysel ve kurumsal müşterilerimizin ihtiyaçlarına daha iyi çözümler üretmeyi, hem de emlak sektörünün önünü açabilmeyi hedefliyoruz” dedi.

THE V KYRENİA GİRNE’DE HAYAT BULUYOR

Girne’nin kalbinde, Semih Sancar Caddesi üzerinde hayat bulacak The V Kyrenia, estetik, teknoloji ve modern hizmet anlayışının tek çatı altında toplandığı adanın bugüne kadarki en lüks rezidans projesi olmaya aday gösteriliyor. Eurocoast Group’un hayata geçirdiği The V Kyrenia, 5 bin metrekarelik bir alanda yükselen 8 kattan oluşuyor. Tam hizmet yönetmeliği kapsamında, sürdürülebilirlik, konfor, aydınlık ve ferahlığın mükemmel bir uyumla sağlandığı 51 rezidans daire, farklı tercihlere hitap eden 1+1, 2+1, 3+1 ve Penthouse konut seçenekleriyle sahiplerini bekliyor.

The V’de ‘‘Smart Home’’ teknolojisi ile planlanmış daireler içerisinde kullanılan beyaz eşyalar ve teknolojik ürünler lider markaların imzasını taşıyor. Proje, rezidans sahiplerine açık ve ısıtma sistemli kapalı yüzme havuzu, fitness spor salonu, sauna ve buhar odası ile sağlıklı yaşam alanları sunarken, 24 saat konsiyerj ve misafir resepsiyonu, 7X24 güvenlik hizmeti, akıllı giriş teknolojisi gibi hizmet ve teknolojilerle güvenliği garanti altına alıyor. Isıtma ve soğutma sistemleri, her odaya yayılmış Wi - Fi ve TV sistemleri, akıllı güneşlikler gibi çözümler, konforlu bir yaşam alanı sağlıyor. The V, şehir hayatının en büyük sorunları arasında yer alan otopark sorununa ise güvenli yeraltı otopark alanı ve her daireye özel olarak ayrılan depolama alanları ile çözüm getiriyor.

The V Kyrenia’da teslimler Ağustos 2019 tarihinde gerçekleşecek. Projeyle ilgili detaylı bilgi için www.thevkyrenia.com adresi ziyaret edilebilir veya App Store’dan “Eurocoast Group: The V” uygulaması indirilebilir. Creditwest Bank’ın The V Kyrenia özelinde sunduğu konut kredileri ile ilgili detaylı bilgiye ise (0392) 444 93 78’den ulaşılabilir.


Bu İçeriğe Emoji İle Tepki Ver
3
 
0
 
0
 
0
 
1
 
1
 
0
 
Lefke Güzelyurt Alayköy Lapta Alsancak Girne Dikmen Çatalköy Gönyeli Lefkoşa Akıncılar Vadili Esentepe Tatlısu Değirmenlik Serdarlı Paşaköy Akdoğan Beyarmudu Mağusa İnönü Yeniboğaziçi Geçitkale Ískele Büyükkonuk Mehmetçik Yenierenköy Dipkarpaz

YORUMLAR
1
ONAY BEKLEYENLER
0
1 Kasım 2017, Çarşamba
Ata         - Magusa
8 katmis,icine ettiniz Girne'nin ama allah razi olsun izin verenlere.Girne hizli bir sekil de bosaliyor ,herkes Magusa'ya kaciyor.

İnşaat sektöründe mevsimsel uyumlu üretim euro bölgesinde yüzde 0,5 arttı
Avrupa Birliği İstatistik Dairesi Eurostat tarafından açıklanan verilere göre, Ekim 2017 ile karşılaştırıldığında Kasım 2017’de inşaat sektöründe mevsimsel uyumlu üretim euro bölgesinde EA19 yüzde 0,5 ve AB28’de yüzde...
Kıbrıs Town Houses avlusunda ilk buluşma
Kıbrıs Developments’in yeni projesi Kıbrıs Town Houses, geçtiğimiz hafta sonu gerçekleştirdiği ‘‘Avluda Sıcak Şarap’’ etkinliği ile örnek evlerini tanıttı. Etkinliğe, sektörün önde gelen yatırımcıları, çözüm ortakları...
Caddemm'den yeni yıla özel dev kampanya!
Mağusa'nın ilk ve tek özel caddesi; Caddemm