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(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")) AS `desc`,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("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-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-22", DATEDIFF(`media`.`mediaCreated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-22", DATEDIFF(`media`.`mediaUpdated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-22", DATEDIFF(`userLastUpdate`, "2019-07-22"), DATEDIFF("2019-07-22", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-22", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-22"), DATEDIFF("2019-07-22", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `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`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*s" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (50) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 50;
Spaces & Venues in Kirklees / Spaces / Toilets / S / 1 to 17 of 17 https://www.creativekirklees.com/listings/spaces/?fac%5B0%5D=50&letter=s&view=rss Find a space or venue on Creative Kirklees for your arts or creative event. Or add your own space or venue in Kirklees. Start your venue search here! Sales Opportunity- Pop Up Christmas Gift Shop, Ilminster Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/liz-sparkes/sales-opportunity-pop-up-christmas-gift-shop-ilminster/ Following a successful Somerset Arts Weeks, we have decided to create a pop up Christmas Art & Craft shop within our creative space, Millhouse, at Rose Mills Industrial Estate, Ilminster. We are offering artists and c... Shaptor Studio Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bridget-arnold/creative-textiles-studio/ Shaptor Studio Creative Textiles workshop space With sewing machines available Could be used for small groups for other creative workshops Shared Creative Space in Frome Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/josephinefrom/shared-creative-space-in-frome/ Art, music, film, tech, events & work space for ethical, creative human beings. beinghuman has resolved our planning issues & the Somerset warehouse is ready for rental! We have shared studio space starting from j... Shoebox Theatre Mon, 30 Nov -001 00:00:00 +0000 https://swindondoesarts.co.uk/shoeboxtheatre/shoebox-theatre/ The Shoebox Theatre is a small 50 seat flexible studio space in the heart of Swindon's cultural quarter. The space is managed by Wrong Shoes, who are also the resident theatre company. Working in collaboration with l... Sine FM Radio Station Mon, 30 Nov -001 00:00:00 +0000 https://creativedoncaster.com/higher-rhythm/sine-fm-radio-station/ Sine FM is a licensed FM Radio Station, based in Doncaster, but broadcasting world-wide on-line. Sine is a leading provider of media industry training and volunteering opportunities and the station is entirely mann... Slaithwaite Community Centre - a venue for creative activity! Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/slaithwaite-community-centre/slaithwaite-community-centre-a-venue-for-creative-activity/ With six rooms ranging from small, gathering spaces perfect for your weekly book group or writers group, to a large hall perfect for those wishing for somewhere to gather and dance - the Slaithwaite Community Centre can ... Small Seeds Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/small-seeds/small-seeds/ Huddersfield bar and music venue Soundart Radio 102.5fm Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/soundartradio/soundart-radio-102-5fm/ Our door is open to all at our low key, relaxed broadcast studio. We are based on the Dartington Estate and often make use of the beautiful studio spaces and the grounds to hold events and workshops. We also use Totn... Space - Studios & Rehearsal Spaces Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/thedartingtonhalltrust/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... Studio / Room Hire Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-sarah-taylor-school-of-dance/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 ... Studio Space Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/alison-cosserat/studio-space/ An opportunity to join our creative community. A studio has become available at The Old Brick Workshop, Higher Poole, Wellington, Somerset, TA21 9HW. Wellington is positioned between Bristol and Exeter and is therefo... Studio space available No.11 Mon, 30 Nov -001 00:00:00 +0000 https://creativedoncaster.com/queens-road-design-centre/studio-space-available-no11/ Studio No.11 We have a large light and airy 54.1 square meter room available. This space would work best as a workshop or studio space. Its situated on our first floor at the back of our lovely courtyard. On street busi... Studio Spaces Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/pavilions-teignmouth/studio-spaces/ Available from Spring 2016. There are three Studios spaces which can be hired either individually or as one unit. They are light airy spaces with a sprung floor. They can be used for classes, workshops or meetings. The... Studio to hire, Hertford Theatre Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/hertford-theatre/studio-hire-hertford-theatre/ Hire this flexible space which is perfect for classes, workshops and breakout sessions. It provides a relaxed environment for day time or evening rehearsals and small scale productions. Capacity: 100 (max) Studio/gallery space soon available for rent at Spring Farm Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/anne-farmer/studio-gallery-space-rent-spring-farm/ Spring Farm Arts is a suucessful collaborative group od artists based inthe picturesque Polden Hills village of Moorlinch, near the A39 and the A361. A two-storey space will shortly be available. It is not currently u... Studio/Office to rent in Langport with parking Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/shakspeare-glass/studio-office-to-rent-in-langport-with-parking/ We have two office or studio spaces available to rent. One space has recently been used as an office and is partly furnished with desk etc and is available now. The other overlooks the river and will be available in a fe... Studio/workshop/bench space to rent Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/360trust/studio-workshop-bench-space-rent/ Available from October 1st 2013, a light and bright studio space approx 3.5m x 6m with views over the surrounding countryside in a renovated watermill on the edge of Exmoor. Suitable for artists/crafts people working ...