Venue & Hotel Search

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 = 1) ci ON (com.citycode = ci.value) LEFT JOIN v_mehk_mtr mtr ON com.nearestmtrcode = mtr.value AND mtr.charsetid = 1 LEFT JOIN v_mehk_country mcou ON com.countrycode = mcou.value AND mcou.charsetid = 1 LEFT JOIN v_mehk_location mloc ON com.locationcode = mloc.value AND mloc.charsetid = 1 where companyid = 78236 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 78236

Freespace

Freespace – Hong Kong’s new centre for contemporary performance in the heart of the West Kowloon Art Park – presents multi-genre performances and events, produces boundary-pushing collaborations, and promotes new ways of seeing and experiencing performance.

The Box: The largest blackbox theatre in Hong Kong, The Box is a highly flexible space fully adaptable for small- to medium-sized performances of experimental theatre, dance, multimedia shows and music events, as well as exhibitions.
Capacity: around 900 people standing, 450 seated

The Room: The Room is a spacious multi-purpose venue designed for creative exchanges, exhibitions and workshops, as well as professional and private meetings and gatherings.

The Studio: Slightly smaller than The Room, The Studio is a bright, airy space designed for rehearsals, meetings, workshops and small-scale symposiums.
General Information
Address : West Kowloon Cultural District, No. 18 Museum Drive,
Tsim Sha Tsui,
Kowloon,
Hong Kong
Tel : +852 22000217
Email : venuehire@wkcda.hk
Website : https://www.westkowloon.hk/en/freespace
Nearest MTR station : Kowloon
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 = 78236 ORDER BY outletnameen