场地及酒店搜索

SELECT DISTINCT CASE mcou.charsetid WHEN 1 THEN companynameen WHEN 2 THEN companynametc ELSE companynamesc END companyname, CASE mcou.charsetid WHEN 1 THEN companyprofileen WHEN 2 THEN companyprofiletc ELSE companyprofilesc END companyprofile, CASE mcou.charsetid WHEN 1 THEN address1en WHEN 2 THEN address1tc ELSE address1sc END address1, CASE mcou.charsetid WHEN 1 THEN address2en WHEN 2 THEN address2tc ELSE address2sc END address2, mloc.text, ci.text, mcou.text, telephone1Country, telephone1area, telephone1, telephone2Country, telephone2area, telephone2, fax1Country, fax1area, fax1, fax2Country, fax2area, fax2, email1, email2, email3, website1, website2, website3, mtr.text, latitude, longitude, orderno, CASE mcou.charsetid WHEN 1 THEN howtogetthereen WHEN 2 THEN howtogettheretc ELSE howtogettheresc END howtogetthere, CASE mcou.charsetid WHEN 1 THEN venuenameen WHEN 2 THEN venuenametc ELSE venuenamesc END venuename, CASE mcou.charsetid WHEN 1 THEN locationen WHEN 2 THEN locationtc ELSE locationsc END location, dimensionlength, dimensionwidth, cap_theatre, cap_classroom, cap_banquet, cap_cocktail, cap_boardroom, ceilingheight FROM v_mehk_company com LEFT JOIN (SELECT * FROM v_mehk_city WHERE charsetid = 3) ci ON (com.citycode = ci.value) LEFT JOIN v_mehk_mtr mtr ON com.nearestmtrcode = mtr.value AND mtr.charsetid = 3 LEFT JOIN v_mehk_country mcou ON com.countrycode = mcou.value AND mcou.charsetid = 3 LEFT JOIN v_mehk_location mloc ON com.locationcode = mloc.value AND mloc.charsetid = 3 where companyid = 34089 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 34089

创新中心-香港科技园公司

Equipped with 2,400 square metres of multi-functional exhibition space and state-of-the art facilities, InnoCentre is able to host a variety of local and international design-focused events, conferences and seminars, providing the invaluable opportunity for designers to showcase their works and network with industry veterans.
基本资料
地址 : 香港九龙九龙塘达之路72号创新中心
电话 : +852 26296773
电邮 : info@innocentre.org.hk
网址 : http://www.hkstp.org/en-US/Facilities/InnoCentre/MICE-Venues/Overview.aspx
最近的港铁站 : 九龙塘
会议,展览及宴会设施
场地名称 位置 尺寸(米) TA CR BQ CT BR 天花高度
100
400
180
150
30
30
15
30
SELECT DISTINCT fbo.fboutletid, fbo.outletnameen, fbo.outletnametc, fbo.outletnamesc, fbo.capacity, fbo.remarken, fbo.remarktc, fbo.remarksc FROM v_mehk_fboutlet fbo, v_mehk_fboutletcuisinetype fboct WHERE fbo.fboutletid = fboct.fboutletid AND fbo.companyid = 34089 ORDER BY outletnameen
餐饮场所
场所编号 场所名称 容纳人数 美食种类 备注
2719 Pacific Coffee SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 3 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 2719 咖啡店
其他设施

无障碍设施

无障碍食肆 , 无障碍会议室 , 无障碍泊车位置

一般设施及客房服务

停车场 , 咖啡室 , 会议设施 , 相连房间 , 非吸烟客房

平面图