场地及酒店搜索

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 = 344 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 344

九龙湾国际展贸中心

基本资料
地址 : 香港九龙九龙湾展贸径1号
电话 : +852 26202222
传真 : +852 26202818
电邮 : salesmgr@kitec.com.hk
网址 : www.kitec.com.hk
最近的港铁站 : 九龙湾

    点选以下方格,查看附近还有什么:

  • 景点
  • 购物
  • 美食
  • 酒店
会议,展览及宴会设施
场地名称 位置 尺寸(米) TA CR BQ CT BR 天花高度
Rotunda 2 3/F 1600 1000 1200 5.3
Star Hall 3/F & 5/F 72.8 X 40 3600 1020 2040 500
Rotunda 3 6/F 1600 1000 1200 5.3
Meeting Room 601 6/F 8.25 X 13.8 120 54 36 2.2
Meeting Room 602 6/F 8.25 X 13.8 120 54 36 2.2
Meeting Room 1 7/F 10.4 X 7.4 80 45 48 2.3
Meeting Room 2 7/F 12.5 X 8.1 100 65 60 2.3
Meeting Room 3 7/F 10.4 X 7.4 80 45 48 2.3
Meeting Room 4 7/F 12.5 X 8.1 100 65 60 2.3
Meeting Room 5 7/F 10 X 7.7 80 50 36 2.3
Meeting Room 6 7/F 10 X 7.7 80 50 36 2.3
Meeting Room 7 7/F 6 X 7.7 45 30 24 2.3
Meeting Room 8 7/F 10.2 X 11 2
Meeting Room 9 7/F 9 X 7.8 70 50 36 2.3
Meeting Room 10 7/F 10.3 X 7.8 70 55 36 2.3
Meeting Room 11 7/F 9 X 8.1 70 50 36 2.3
Meeting Room 12 7/F 10.1 X 8.1 70 45 36 2.3
Meeting Room 13 7/F 8.9 X 8 70 35 36 2.3
Meeting Room 14 7/F 10 X 8.1 70 45 36 2.3
Meeting Room 15 7/F 10.3 X 8 70 45 36 2.3
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 = 344 ORDER BY outletnameen
餐饮场所
场所编号 场所名称 容纳人数 美食种类 备注
553 Xi Shan 400 SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 3 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 553 中菜(广东菜) Chinese