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/0)*IF(`userTotalItems`>0, 0, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/504)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/225)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings` 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`=1 AND `userNetwork` IN (9) AND IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*p" GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 50;
Directory of artists and creative organisation in Kirklees / Profiles / P / 1 to 18 of 18 https://www.creativekirklees.com/directory/?network%5B0%5D=9&letter=p&view=rss Creative Kirklees has an extensive directory of artists, creative organisations and places. Take a look at who’s working locally in Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas. &Piano / &Piano Music Festival Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/piano/ &Piano is a celebration of collaborative piano - music performed by singers and instrumentalists accompanied by piano. It aims to share and guide people around some of the most amazing music, performed by young and estab... Paddock Community Trust / Paddock Community Trust Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/simon-ashbee/ Paddock Community Trust is a registered charity delivering a range of community services throughout Kirklees. These include adult learning, employment support, environmental projects and providing training for young peo... Pageturners Festival / Children's Reading Festival Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pageturners-festival/ An exciting line-up of authors, illustrators, storytellers and arts events for children and families across Kirklees. This year's festival finale takes place on Saturday 22nd April and is headlined by popular chuildre... PANDA-Performing Arts Network / PANDA Performing Arts Network & Develpt Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/panda-performing-arts-network/ PANDA (Performing Arts Network & Development Agency) is a membership network and support organisation focussing on the North of England. Our mission is to proactively support a vibrant enterprise culture by nurturing tal... Park Lea Design Agency Ltd / Kirsty McDonald (Freelance Footwear & Fashion Designer) Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/park-lea-design-agency-ltd/ Hello, I am Kirsty McDonald and I am the Owner & Freelance Designer & Creative Director of Park Lea Design based in Huddersfield. Professional & Experienced Freelance Footwear Designer, Global Freelance Design, Develo... Parley / @byparley Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/parley/ Parley creates spaces, projects and programmes to encourage arts and cultural conversation, connection, learning and development. Our services focus on: Artist Development Audience Development Space and Place. ... Pat Fulgoni / singer, promoter, producer, musician Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pat-fulgoni/ Examiner Community Award Winner (Music & Arts), Going Global Awards (Best New Export Initiative). "Fulgoni could sing a pearl from its oyster" (Billboard) ... Pat's sung for labels incl Ram, Hospital, Subliminal (NY... Paul Graham / Photographer Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/paulgraham/ Hello! I'm a photographer working out of West Yorkshire. Specialising in skateboard, studio, landscape and documentary photography. I am currently a studio holder at Creative Arts Hub, Mirfield. My day job consists o... Pierrot Players / Amateur Dramatics Group Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pierrot-players/ The Pierrot Players are an amateur dramatic society formed in 1981 in the villages of Shepley and Shelley near Huddersfield in West Yorkshire. With few exceptions, we have performed two plays each year since then, drawin... Pikcells / Pikcells Ltd Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pikcells/ We are Pikcells, a design driven digital studio founded in Huddersfield in 2003. The focus of our work is making extremely good looking CGI and really useful Interactive solutions for large and small clients. Each projec... PiPtoGrowStrong / Natasha McCreesh Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/piptogrowstrong/ My name is Natasha, to sum myself up - I believe in growing strong and only doing work that brings me joy. I'm Mum to Maia. A Cultural Explorer. I share jȏʏ reflections. I'm a Co-Conspirator, Collaborator, Coach, Mentor.... Pixel Press / Graphic Design // Web // Print Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pixel-press/ We are a small design company based in Meltham, Huddersfield. We are specialise in graphic design, website design and print. Positive Earth Designs / Artist Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/positive-earth-designs/ Hi, I'm Jac - a pyrography artist specifically working with recycled wood. Inspired by nature and organic forms, I use the natural grains and defects in the wood to add character to each piece. I am passionate about re... PriestleysCafeBar / Main Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/priestleyscafebar/ Priestley’s Café-Bar is Birstall’s premium location for live bands, live DJs and live sports. Owned and managed by Birstall locals. Priestley’s is a community venue and the home of Birstall Victoria Rugby Club. C... Proper Job Theatre / Theatre and Creative Community Engagement Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/proper-job-theatre/ Proper Job Theatre Company, based in Huddersfield, create and tour new work and produce large-scale theatre events. We also train and support individuals from the local community through our projects delivered across Yo... Pure Elegance Carnival / Pure Elegance Carnival Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pure-elegance-carnival/ Pure Elegance is a carnival group which was established by an elder of the Caribbean Community in Huddersfield in 2001. We are a highly reliable and experienced group of individual volunteers who have come together withi... Pure Heart Centre / holistic health & creativity Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pure-heart-centre/ The Pure Heart Centre opened May 21st 2016 and is ever evolving in how to serve the community with health and creativity at the core coupled with personal development and inward journeys for soothing self & soul. It is l... Pyjama Drama / Pyjama Drama Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/pyjama-drama/ Drama and play for everyday. Pyjama Drama works with children & families, nurseries & schools! Having fun is what we do! Every day it's a new adventure with Pyjama Drama - the babies might be stamping their feet wit...