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`, "/")), "?fac%5B%5D=73") 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-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-21", DATEDIFF(`media`.`mediaCreated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-21", DATEDIFF(`media`.`mediaUpdated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-21", DATEDIFF(`userLastUpdate`, "2019-08-21"), DATEDIFF("2019-08-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-21"), DATEDIFF("2019-08-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `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-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-21", "2018-08-21") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-20", "2019-08-21")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (73) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Spaces & Venues in Kirklees / Spaces / Screen/Projector / 1 to 15 of 68

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 / Screen/Projector / 1 to 15 of 68

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

Bentley Resource Centre

We have a variety of high quality and affordable spaces available to suit your needs. To discuss your specific needs and find the right office space for you get in touch. We have flexible prices for charities, social e.....Read more

Co-working at Doncoplitan HQ

Co-working at Doncoplitan HQ

At Doncopolitan we will provide you with opportunities to join in on events, this could vary from events coming up in the near future or tagging along with already existing events. You’ll have access to a meeting room, w.....Read more

Green Hill Arts

Low-cost, easy in/easy out studios, stand alone workspace and offices for creative industries will soon be available to let at Green Hill Arts, a new, mixed use community development based in the old Moretonhampstead pri.....Read more

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

Hannahs

Hannahs

Hannahs Seale-Hayne is a creative community space. A passion infused social enterpise which creates inspring opportunities for all abilities. With a host of incredible on-site facitlities from Live Music Venue, Music.....Read more

Space - Studios & Rehearsal Spaces

Rehearsal & Performance Studios to Hire Call 01803 847147 to book We have a wide range of studios available for hire for your work. For technical specifications for each studio click on the links below. Rates shown.....Read more

Minehead EYE Exhibition Space

Minehead EYE Exhibition Space

Do you need somewhere to display your artwork? Looking for an exhibition space with a difference? Why not try Minehead EYE. We have loads of wall/exhibition space in our cafe and around the centre. Give Molly a call .....Read more

Minehead EYE Music Venue

Minehead EYE Music Venue

Minehead EYE is a great location for music gigs or performances. The main hall can be reconfigured to provide a 300 capacity venue complete with stage, lighting and PA connections. The cafe area provides a more intimat.....Read more

Minehead EYE Recording Studio

Minehead EYE Recording Studio

State of the Art Recording Studio and Rehearsal Space. Need somewhere for a regular rehearsal? Or just a one off recording session? Why not use the brand new studio at Minehead EYE. Engineer available. Call Joe for .....Read more

The Old Church School

The Old Church School

A workhub in Frome designed specifically for small businesses looking for a creative and innovative environment to work in. You want a work space - without the hassle - so that you can concentrate on the important things.....Read more

The Bagehot Room

The Bagehot Room

Small meeting space perfect for 1:1 meetings. Available to use as a therapy, counselling or interview room, or as a small meeting space. Access to FREE Wi-fi Maximum space available for 4 people...Read more

Riverside Cafe Gallery Space

Riverside Cafe Gallery Space

Our historic warehouse building provides the perfect backdrop for artwork with its tall ceilings and interesting spaces. The Carpenter Room, which houses the Riverside Cafe, has an exposed brick wall, wooden beams and lo.....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

Conference/ Meetings/ Workshop space

Conference/ Meetings/ Workshop space

Space available for meetings, workshops, functions etc We can now offer use of our professional, multipurpose conference room to clubs, societies, tutors, businesses or individuals. It is ideal for anything from traini.....Read more

The Engine Room

The Engine Room

The Engine Room is part of registered charity Somerset Film. Our mission statement is to make film and digital media skills and facilities as widely accessible as possible in Somerset – and to pursue excellence and inno.....Read more

1 / 2 / 3 / 4 / 5 /