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=38") 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-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-15", DATEDIFF(`media`.`mediaCreated`, "2019-07-15"), DATEDIFF("2019-07-15", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-15", DATEDIFF(`media`.`mediaUpdated`, "2019-07-15"), DATEDIFF("2019-07-15", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-15", DATEDIFF(`userLastUpdate`, "2019-07-15"), DATEDIFF("2019-07-15", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-15", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-15"), DATEDIFF("2019-07-15", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `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-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-15", "2018-07-15") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-14", "2019-07-15")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (38) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Spaces & Venues in Kirklees / Spaces / Other / 1 to 15 of 50

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 / Other / 1 to 15 of 50

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

Loft 14: Large studio apartment  (Ideal studio / office space)

Loft 14: Large studio apartment (Ideal studio / office space)

A spacious unfurnished large studio apartment, ideal for office or studio space or professionals for residential or live/work purposes Monthly rental = £1052.27 Loft 14 is located on the 1st floor of the Grade II l.....Read more

Loft 7: Studio apartment  (Ideal studio / office space)

Loft 7: Studio apartment (Ideal studio / office space)

A spacious unfurnished studio apartment, ideal for professionals or for live/work purposes Rental £660.75 per month Loft 7 is located on the 1st floor of the Grade II listed Creative lofts building and accessed by .....Read more

Loft 21: Top floor studio apartment  (Ideal live / studio space)

Loft 21: Top floor studio apartment (Ideal live / studio space)

A spacious top floor unfurnished studio apartment, ideal for professionals or for live/work purposes Monthly rental = £521.95 Loft 21 is located on the 2nd and top floor of the Grade II listed Creative lofts buildi.....Read more

Occombe Farm Event Space

Occombe Farm Event Space

Occombe Farm are delighted to offer our café and farmyard for all kinds of events! The café has been recently refurbished with an outdoor balcony overlooking the farmyard. The yard has been recently concreted to make the.....Read more

Workshop

Workshop

All framing is bespoke and is completed on the premises. Selecting the right frame and mount is crucial in enhancing the overall effect of the picture and how it compliments its surroundings. We hold a vast selection of .....Read more

Machine Wilderness Exhibition

Machine Wilderness Exhibition

West Country Artist Anna Keleher and New Mexican Artist Claire Coté are to show an interactive audio installation in "Machine Wilderness" , ISEA12 in New Mexico MACHINE WILDERNESS at 516 ARTS Albuquerque, ISEA2012.....Read more

Creative Workshop Space for Hire, Southampton

Creative Workshop Space for Hire, Southampton

Artswork has a new creative workshop/ training space available for hire at Unit 26, Bargate Centre, Southampton- right in the centre of the city. The space is ideal for small- medium sized workshops- maximum capacity .....Read more

South West Music School

South West Music School

Musical Excellence in the South West South West Music School is a music charity working with talented young instrumentalists, singers and composers aged 8-18yrs in the South West. Due to the geographical nature of.....Read more

Devon Art and Display Stands

Devon Art and Display Stands

Portable display stands for artists. Available for hire or sale! We specialize in providing quality, affordable, display stands and table-top displays primarily for artists but also for general display purposes. Apart.....Read more

Husbands N Knives - Bandcamp

Husbands N Knives - Bandcamp

Here you can listen to both our albums and order Cds and merch !..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

Vibrant Space Available for Creative Startups

Vibrant Space Available for Creative Startups

PAPER Artistic Development CIC PAPER Arts is a social enterprise providing opportunities for young people and entreprenurs to make an income from being creative. We now have a space available for a start-up business w.....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 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 Levels Hub Space

The Levels Hub Space

The Levels Hub is a fantastic place to bring your work and get away from it all at the wonderful location of Great Bow Wharf. With views out over the River Parrett and beyond, the beautiful views of the heart of Somer.....Read more

1 / 2 / 3 / 4 /