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-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-21", DATEDIFF(`media`.`mediaCreated`, "2019-07-21"), DATEDIFF("2019-07-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-21", DATEDIFF(`media`.`mediaUpdated`, "2019-07-21"), DATEDIFF("2019-07-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-21", DATEDIFF(`userLastUpdate`, "2019-07-21"), DATEDIFF("2019-07-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-21"), DATEDIFF("2019-07-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `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]*k" 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 / K / 1 to 22 of 22 https://www.creativekirklees.com/directory/?network%5B0%5D=9&letter=k&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. Karen Howarth Ceramics / Ceramic Artist Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/karen-howarth-ceramics/ I make handmade ceramic wall pieces and tiles which explore an ongoing interest in mark-making and texture. Inspiration is drawn from the natural and man-made landscape. Working directly onto the clay the surface is dev... Karen Naylor / Festival Director, Cleckheaton Literature Festival Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/karen-naylor/ Writer who set up and runs the Cleckheaton Writer's Group and the Cleckheaton Literature Festival. I write several genres, short stories, novels, plays, radio plays, poetry, articles, proof read/edit and freelance. I hav... Karen Stansfield / Kaboodle Design Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/karen-stansfield/ My artistic discipline is in mixed media and printmaking, I am an emotive artist and I explore many mediums to create my work, working on both paper and material. I am based at the West Yorkshire Print Workshop in Mirfie... Karin freelance / Marketing & Digital Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/karin-freelance/ karinduboiscreative@gmail.com 0753 012 9997 Widespread experience in marketing / communications / media / digital, and I offer the following services with a focused practical approach - specialising in start ups and ... Kate Morton / Theatre Designer Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kate-morton/ Set and Costume Designer, Scenic Artist, Propmaker and Puppet Maker. I am a set and costume designer with a degree in Theatre Design and experience working in a variety of theatres and companies ranging from small-sca... Kate Thornton Design / Kate Thornton Design Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kate-thornton-design/ Kate Thornton Design is an independent art and design business producing original art work, greetings cards and prints. Inspired by my love of the natural world, particularly birds! All designs are based on my hand-c... Katherine / Stefanescu Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/katherine-1/ Design and Architecture Katy Jane Measures / Artist / Tutor Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/katy-measures/ 2D & 3D Illustrations, Ceramics and Textiles. Shop owner of MadeByKatyJane. I am also a qualified Art Teacher in the Lifelong Learning Sector. I offer private tuition for writing dissertations within the arts/teachin... KayJD / 1972 Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kayjd/ Kay Janette Dawson. Watercolour and mixed media experimental artist. Milliner and accessories designer. Currently based at the Creative Arts Hub , Mirfield. Kayleigh Wright / Artist and Community Worker Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kayleigh-wright/ Having recently completed my Contemporary Art and Illustration degree at University of Huddersfield I am currently seeking new voluntary and paid opportunities to broaden my experience in the arts and art community. ... KC Adult & Community Education / Adult and Community Education - Kirklees College Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kc-adult-community-education/ Kirklees College offers a wide range of courses and projects to engage adults and families across its local community. Our vision is to change the lives of people who need it most through accessing learning opportunit... KC Communications / Marketing Consultancy Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kc-communications/ We’re a marketing agency who offer a flexible solution to both businesses who don’t have an in-house resource and those who require expert support to support internal departments. We offer everything from developing y... Kirklees College / Huddersfield and Dewsbury Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-college-1/ Kirklees College came into being in August 2008 through a merger between Dewsbury College and Huddersfield Technical College. Both Dewsbury College and Huddersfield Technical College have an illustrious past and, thro... Kirklees Comms Team / content team Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-comms-team/ We are the council's communications team Kirklees Concert Season / 2019-20 Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-concert-season/ The 2019/20 Kirklees Concert Season is extra special as it marks the first season in our journey towards the Year of Music 2023 which will put Kirklees and our partners firmly on the musical map and will establish Kirkle... KIRKLEES FILMMAKERS / Film/ New Media/Digital and Urban Arts Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-filmmakers/ We support and encourage filmmaking and use of New Media and Digital and Urban Arts concepts in the Kirklees area and run projects and workshops throughout Kirklees. We support, encourage and work with a large variety o... Kirklees Libraries / Libraries Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-libraries/ A profile for creative workshops and events in libraries across Kirklees. Kirklees Libraries host a variety of creative events and groups aimed at all ages, from reading groups and author events, to craft workshops a... Kirklees Local TV / Kirklees Local TV Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-local-tv/ Founded in 2011 and based in Huddersfield West Yorkshire, Kirklees Local TV is a video production company who are passionate about film, business and people. We provide high-quality bespoke video productions for local an... Kirklees Town Halls / Town Hall Venues Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirkleestownhalls/ Kirklees Town Halls are perfect venues for celebrating, meeting and enjoying top quality entertainment. Situated in central locations in the heart of Batley, Cleckheaton, Dewsbury and Huddersfield, Kirklees Town Hall... knitandnatter / weekly knitting group Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/knitandnatter/ WEEKLY KNITTING GROUP EVERY FRIDAY 1:00 – 3:00pm COMMUNITY CHURCH, JUBILEE CENTRE, MARKET STREET PADDOCK, HUDERSFIELD HD1 4SH BUS 356 (LONGWOOD) BAY X EVERY QUARTER TO & QUARTER PAST THE HOUR TEL: 01484 551... knitandnatter / weekly knitting group Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/knitandnatter-1/ AT A LOOSE END BORED, WANT TO GET OUT OF THE HOUSE COME ALONG TO OUR FAB FRIENDLY WEEKLY KNITTING GROUP HAVE A NATTER AND RELAX WITH A CUPPA. ABSOLUTE BEGINNERS TO EXPERIENCED MAKES NO DIFFERENCE. JOIN US KNITTI... KnitYourselfFree / DanceYourselfHappy/PaintYourselfLively Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/knityourselffree/ Judy Hinchliffe is an artist and workshop leader who is passionate about exploring the possibilities of colour and who uses vibrant colour and texture combinations with the aim of conveying light and energy. Her enjoymen...