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-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-24", DATEDIFF(`media`.`mediaCreated`, "2019-07-24"), DATEDIFF("2019-07-24", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-24", DATEDIFF(`media`.`mediaUpdated`, "2019-07-24"), DATEDIFF("2019-07-24", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-24", DATEDIFF(`userLastUpdate`, "2019-07-24"), DATEDIFF("2019-07-24", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-24", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-24"), DATEDIFF("2019-07-24", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `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]*a" 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 / A / 1 to 8 of 8 https://www.creativekirklees.com/listings/spaces/?fac%5B0%5D=50&letter=a&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! Agatha's Closet : A place for all things needlecraft. Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/agatha-s-closet/agatha-s-closet-a-place-for-all-things-needlecraft/ Agatha's Closet have opened a new space at 45 Hyde Road, Paignton, Devon. As a fashion and needlecraft project we needed a space that allowed us to develop a retail arm as well as spaces for workshops and events. ... AMANARTIS - office/workspace/studio Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/amma-gyan/amanartis/ This beautiful grade II listed building is the site for a new exciting centre for creativity and design in Watford. The space is aimed at anyone who is looking for a serious space to work from to develop there creative b... Arcade Coffee & Food - Byram Arcade Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-parish/arcade-coffee-food-byram-arcade/ Cafe & Bar serving fresh, locally sourced food, coffee & beer. We have access to the ground floor area of the Byram Arcade and can provide production and tech for any event. We try to run events every friday & satur... Art Parties & Private Workshops Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/globe-arts-studio/art-parties-private-workshops/ Enjoy exclusive use of our Studio space, along with an art or craft activity of your choice. Suitable for children, teens, adults and groups. A great opportunity for friends and family to get together and create toge... Artizan Gallery Events Venue Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/artizan/artizan-gallery/ Artizan's exhibitions make it an attractive location for events and performances, and is available for evening hire. From music, to meetings, to formal functions, the gallery and café provide the necessary facilities for... Arts Lounge Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/princess-theatre-and-arts-centre/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... Auditorium and Stage Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/pavilions-teignmouth/auditorium-and-stage/ Available Spring 2016. There are a variety of rooms available for hire; all flexible spaces which, together with the bar and restaurant, provide the perfect venue for a wide variety of events, ranging from conferences an... Auditorium, Hertford Theatre Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/hertford-theatre/auditorium-hertford-theatre/ Auditorium A versatile space with retractable seating ideal for meetings, performances and presentations. With a state-of-the-art sound and lighting system, nothing beats seeing your PowerPoint presentation or co...