SELECT SQL_CALC_FOUND_ROWS SQL_NO_CACHE `mediatypes`.`mtID` AS `mediaTypeID`,IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) AS `name`,`media`.`mediaTitle` AS `title`,`users`.`userDisplayName` AS `displayname`,`mediatypes`.`mtCode` AS `media`,IF(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " "), "&", "&"), "\"", """), "\'", "'"), "<", "<"), ">", ">")="", "", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " "), "&", "&"), "\"", """), "\'", "'"), "<", "<"), ">", ">")) AS `text`,IF(`media`.`mediaFile`!="" AND `mediatypes`.`mtImage`+`mediatypes`.`mtVideo`!=0, CONCAT("media/", `networkAlias`, "/", `mediatypes`.`mtCode`, "/", IF(`mediatypes`.`mtVideo`=1, SUBSTRING(`media`.`mediaFile`, 1, LOCATE(".", `media`.`mediaFile`)-1), `media`.`mediaFile`)), (SELECT IF(`avatar`.`mediaFile`!="", CONCAT("media/", `networkAlias`, "/", `avatarmt`.`mtCode`, "/", `avatar`.`mediaFile`), "") FROM `media` AS `avatar`, `mediatypes` AS `avatarmt` WHERE `avatar`.`mediaUser`=`media`.`mediaUser` AND `avatar`.`mediaType`=`avatarmt`.`mtID` AND `avatarmt`.`mtCode`="profiles" LIMIT 1)) AS `image`,CONCAT("/", `users`.`userSeoName`, "/") AS `pubHref`,CONCAT("/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/")), "?vt%5B%5D=36") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=9 AND `users`.`userElevation`>=99 THEN "special" WHEN `mediatypes`.`mtCode` IS NULL OR `mediatypes`.`mtCode`="profiles" THEN `users`.`userType` ELSE `mediatypes`.`mtCode` END AS `class`,IF(`mediatypes`.`mtDate`=1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`=`media`.`mediaDate`, DATE_FORMAT(`media`.`mediaDate`, "%a %d %b %Y"), CONCAT(DATE_FORMAT(`media`.`mediaDate`, CASE WHEN DATE_FORMAT(`media`.`mediaDate`, "%Y%m")=DATE_FORMAT(`media`.`mediaDateEnd`, "%Y%m") THEN "%a %d" WHEN DATE_FORMAT(`media`.`mediaDate`, "%Y")=DATE_FORMAT(`media`.`mediaDateEnd`, "%Y") THEN "%a %d %b" ELSE "%a %d %b %Y" END), " to ", DATE_FORMAT(`media`.`mediaDateEnd`, "%a %d %b %Y"), " (", CASE WHEN DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<7 THEN CONCAT(DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1, " days") WHEN DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<=28 THEN CONCAT(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/7), IF(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/7)=1, " week", " weeks")) WHEN DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<365 THEN CONCAT(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/30.417), IF(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/30.417)=1, " month", " months")) ELSE CONCAT(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/365), IF(DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<730, " year", " years")) END, ")")), "") AS `date`,`media`.`mediaDate` AS `rssdate`,DATE_FORMAT(`media`.`mediaDate`, "%Y-%m-%dT%TZ") AS `isodate`,IF(`mediatypes`.`mtCode`="profiles", CONCAT(UPPER(SUBSTRING(`userType`, 1, 1)), SUBSTRING(`userType`, 2)), `mediatypes`.`mtName`) AS `type`,((IF(`weightingCreated`>0 AND `media`.`mediaCreated`!="0000-00-00" AND `media`.`mediaCreated` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-19", DATEDIFF(`media`.`mediaCreated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-19", DATEDIFF(`media`.`mediaUpdated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-19", DATEDIFF(`userLastUpdate`, "2019-07-19"), DATEDIFF("2019-07-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-19"), DATEDIFF("2019-07-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))))))))*`weightingDate`, 0))+(IF(`weightingDuration`>0 AND `mediatypes`.`mtDate`=1 AND `mediatypes`.`mtDateEnd`=1 AND IF(`mtFuture`=1, DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`), DATEDIFF(`media`.`mediaDate`, `media`.`mediaDateEnd`)) BETWEEN 0 AND 365, (100-((100/365)*IF(`mtFuture`=1, DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`), DATEDIFF(`media`.`mediaDate`, `media`.`mediaDateEnd`))))*`weightingDuration`, 0))+(IF(`weightingProximity`>0 AND (3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=9 AND `userElevation`>0, (`userElevation`)*`weightingSpecial`, 0))+(IF(`weightingTotalitems`>0 AND `userTotalItems`>0, ((100/11)*IF(`userTotalItems`>11, 11, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/25351)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/2605)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings`, `mediarefinements` WHERE `media`.`mediaActive`=1 AND `media`.`mediaEncoding`=0 AND `media`.`mediaApproved`=1 AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=9 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=9 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-19", "2018-07-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-18", "2019-07-19")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (36) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Spaces & Venues in Kirklees / Spaces / Theatre / 1 to 15 of 38

Spaces

Promote your creative space here - it could be a studio, gallery or exhibition space, music venue or rehearsal space, meeting or community rooms.  We'll promote your space via the newsletter and social media.

To list your space, register and log in to My Account.

Spaces / Theatre / 1 to 15 of 38

Show All / A / B / C / D / E / F / G / H / I / J / K / L / M / N / O / P / Q / R / S / T / U / V / W / X / Y / Z

Gallery space at the Blue Walnut Cafe

Gallery space at the Blue Walnut Cafe

Each month we display and sell artwork from a chosen local artist. The Cafe is clean and well lit with magnolia walls, a professional hanging system and space for up to 10 pieces. The Cafe is open to the public 6 days .....Read more

Bridgwater schools for businesses & community to hire

Bridgwater schools for businesses & community to hire

In Bridgwater there are 3 amazing schools that have been built in the last couple of years: • Chilton Trinity School • Robert Blake Science College • Elmwood School Bridgwater YMCA want to make the most of these.....Read more

New Theatre

New Theatre

The NEW THEATRE is a flexible performance space and will s eat approx 100 people. The playing space is approx 10 mtrs x 7 mtrs New Theatre welcomes visiting theatre companies and small groups with acoustic music to p.....Read more

The Commonweal School

Back in September 2014, The Commonweal School was delighted to open its sixth form building known as the C6. This new building offers excellent facilities which include a 250 seated auditorium, café space, Apple Mac suit.....Read more

Shoebox Theatre - Space for Hire

FEES We have a simple fee structure*, with a minimum booking period of 4 hours: Evening / Afternoon/ Morning rate (4 hours): £25 1 Full Day (9am – 11pm): £45 1 Week: £200 The Shoebox is currently available to .....Read more

Arts Lounge

Arts Lounge

Experience fresh art every week in the Arts Lounge. Open Tues-Sat, 10am-3pm. Our newly refurbished space offers a warm, welcoming environment where you can enjoy the latest exhibits. All of the work is by establishe.....Read more

The Princess Theatre and Arts Centre

The Princess Theatre and Arts Centre

The Princess Theatre and Arts Centre has a flexible, traditional, proscenium arch, theatre space that can cater for all types of events such as plays, musicals, dance, concerts, comedy and more. The flexible auditorium.....Read more

All Saints Church

All Saints Church

All Saints church is a 15th century grade 1 listed building. We are the New Saints, and we are a group of local young volunteers who are regenerating the building with new community uses. We want you to use our buildin.....Read more

Trestle for Functions and Events

Trestle for Functions and Events

Trestle Arts Base is an ideal place to hold your function whatever the occasion. Whether you’re planning a children’s party, an award ceremony or a fundraising event. Trestle Arts Base offers stunning contemporary des.....Read more

Trestle for Wedding Receptions and After Parties

Trestle for Wedding Receptions and After Parties

At Trestle we know just how important it is for you to find the perfect venue for your special day. With our extensive theatrical experience and unique site (a former chapel) we believe we can offer you just that. Tr.....Read more

Trestle for Classes and Workshops

Trestle for Classes and Workshops

We know how important it is to find the right place to hold your classes and with our theatrical experience in our unique building (a former chapel) we believe we have something unusual to offer. We are proud of our .....Read more

Trestle for Business

Trestle for Business

We know how important it is to find the right venue for your business event. Whether you are planning a seminar, conference or meeting, Trestle Arts Base is the ideal setting. A unique chapel conversion situated in the t.....Read more

CICCIC Cafe and Gallery Open 9.30-4pm Taunton

CICCIC Cafe and Gallery Open 9.30-4pm Taunton

Soft Launch of CICCIC Daytime Cafe We are pleased to announce that we are open during the day for coffee, tea, hot chocolate, paninis, cakes at CICCIC, and what a great place to relax and enjoy a cuppa with our amazing .....Read more

Maltings Arts'  Theatre

Maltings Arts' Theatre

As well as a small but perfectly formed working theatre (seating 140) we have a great bar area, a comfortable meeting room and a balcony with one of the best views in Hertfordshire. We're right in the centre of the lo.....Read more

The Old Town Hall, Hemel Hempstead

The Old Town Hall, Hemel Hempstead

The Old Town Hall is a buzzing arts space full of entertainment for everyone. The Old Town Hall Theatre, Gallery Bar and The Cellar are also available for private functions and performances. Charity discounts are avail.....Read more

1 / 2 / 3 /