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%5B0%5D=50&page=7") 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-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-20", DATEDIFF(`media`.`mediaCreated`, "2019-06-20"), DATEDIFF("2019-06-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-20", DATEDIFF(`media`.`mediaUpdated`, "2019-06-20"), DATEDIFF("2019-06-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-20", DATEDIFF(`userLastUpdate`, "2019-06-20"), DATEDIFF("2019-06-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-20"), DATEDIFF("2019-06-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `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-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-20", "2018-06-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-19", "2019-06-20")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (50) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 90, 15;
Spaces & Venues in Kirklees / Spaces / Toilets / 91 to 105 of 181

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 / Toilets / 91 to 105 of 181

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

Creative Arts Hub Studios

Creative Arts Hub Studios

This is my new studio space and a new venue for the Art classes..Read more

The Watershed

The Watershed

A thriving creative mill in Slaithwaite, host venue for a range of creative events and home to three long standing local arts organisations, all working in the local community - together known as the Watershed Arts Pract.....Read more

Studio / Room Hire

Studio / Room Hire

We offer meeting room/studio hire for clubs and meetings. Our venue would suit Karate, Judo, Dance, Zumba, Aerobics, Yoga, Fitness and Exercise classes, also Slimming Clubs, Parent and Toddler classes. Meetings could .....Read more

Dewsbury Town Hall

Dewsbury Town Hall

This fine Victorian Town Hall is situated in the centre of bustling Dewsbury town centre. The venue offers you an intimate 700 seat concert hall, spectacular function and meeting rooms, which are ideal setting for eve.....Read more

Huddersfield Town Hall

Huddersfield Town Hall

This impressive building in the heart of Huddersfield welcomes one and all to its concerts, events, functions and meetings Within Huddersfield Town Hall is a spectacular concert hall which holds up to 1200 people and .....Read more

Cleckheaton Town Hall

Cleckheaton Town Hall

The Town Hall is ideally situated in the centre of Cleckheaton and is a focal point for all of the community. Cleckheaton Town Hall has a 500 seat theatre with a fantastic reputation for hosting local amateur dramatic.....Read more

Batley Town Hall

Batley Town Hall

opened in 1853 and is situated in the centre of Batley overlooking the town's Market Square. This welcoming venue is a popular choice for community groups as it offers a selection of rooms for meetings, dances and ama.....Read more

Dewsbury Town Hall Gallery and Exhibition Space

Dewsbury Town Hall Gallery and Exhibition Space

The newly refurbished ground floor foyer at Dewsbury Town Hall now offers a gallery and exhibition space which is free to hire and is available to local artists, community groups and schools. The gallery space is avai.....Read more

Bagshaw Museum

Bagshaw Museum

Founded by Walter Bagshaw at the beginning of the 20th Century, the museum was created to enable visitors to ‘See the world in a day’ and experience civilisations and cultures from around the world via its exciting expan.....Read more

Large hall

Large hall

Ideal for: Parties, regular activities, courses, classes, conferences, public meetings, any event you wish to hold.Fully equipped new kitchen. Very reasonable rates.Wifi Internet.Marquee and event equipment hire. Discoun.....Read more

Café Ollo

Café Ollo

Huddersfield is home to some great cafés, delis and coffee bars, but we think there’s something pretty special about ours. Café Ollo is a bright space with a fresh, healthy menu to tempt all taste buds, plus delicious.....Read more

The Lounge

The Lounge

Need space to work? Imagine if you could kick-start a new venture, without any office overheads. Or work from a second, alternative space, when you need a little more inspiration to nurture your ideas. Come and inn.....Read more

Conference & Meeting Rooms @ The Media Centre

Conference & Meeting Rooms @ The Media Centre

Your next meeting could lead to a new recruit, a client win, much-needed investment or the perfect collaboration. So don’t overlook the importance of the space you hold it in. With a variety meeting, conference and t.....Read more

Town Centre Office Facilities - To Let

Town Centre Office Facilities - To Let

An office is much more than four walls. It’s a space to create, collaborate and grow. So, you need to look beyond the bare essentials such as high speed broadband and a great location. Your office should allow you to be .....Read more

Batley Art Gallery

Batley Art Gallery

Batley Art Gallery is a contemporary artspace which hosts a continual programme of exhibitions by amateur and professional artists. Situated on the first floor of the impressive Carnegie Library building, in the historic.....Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / / 13 /