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`, "/")), "?disc%5B%5D=10") 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-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-15", DATEDIFF(`media`.`mediaCreated`, "2019-07-15"), DATEDIFF("2019-07-15", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-15", DATEDIFF(`media`.`mediaUpdated`, "2019-07-15"), DATEDIFF("2019-07-15", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-15", DATEDIFF(`userLastUpdate`, "2019-07-15"), DATEDIFF("2019-07-15", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-15", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-15"), DATEDIFF("2019-07-15", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `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`=1 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-15", "2018-07-15") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-14", "2019-07-15")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (10) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Other / 1 to 15 of 354

Directory

A directory of artists, creative organisation and places in Kirklees - covering Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas.

If you're an individual artist, producer, creative organisation, creative business or venue - set up a profile page to showcase your work to others in Kirklees and beyond.  To add a profile, register and log into My Account.

If you're looking for an individual artistcreative business or creative place in Kirklees then search the Creative Directory to find out who's working locally.

Profiles / Other / 1 to 15 of 354

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

Access North / about-us

Access North

about-us

Access North is a family owned business which started out in 2011 - over the last 8 years, we've grown and are now made up of two business arms: Access North Structures and Access North Build. Access North Structures .....Read more

Sarah / Freelancer

Sarah

Freelancer

A Freelancer Providing Music Business Online Training And Consultancy/Mentoring. I am a highly motivated and enthusiastic professional who has spent the best part of thirty years working in the business sector of the Mu.....Read more

Holmfirth Film Festival / Holmfirth Film Festival

Holmfirth Film Festival

Holmfirth Film Festival

Bringing film back to the Holme Valley through our annual film festival and regular monthly screenings at venues across the valley. The festival hosts a wide spectrum of film on the big screen - european and world film,.....Read more

KC Adult & Community Education / Adult and Community Education - Kirklees College

KC Adult & Community Education

Adult and Community Education - Kirklees College

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.....Read more

The Curious Creative Club / The Curious Creative Club

The Curious Creative Club

The Curious Creative Club

Hi there, I set up The Curious Creative Club to encourage people to live a more creative and enriched life and inspire them to just give it a go via weekly Blog content, social media, resources and creative workshops. .....Read more

The Creative Lofts / Livework  Space For Let

The Creative Lofts

Livework Space For Let

The Creative Lofts offer 21 unique and imaginative unfurnished studios, 2 bed and mezzanine apartments, ranging from 546 sq ft to 1620 sq ft, within a Grade II listed building in Huddersfield town centre. Originally a.....Read more

University of Huddersfield / Events

University of Huddersfield

Events

The University of Huddersfield – Inspiring Global Professionals The University of Huddersfield has a growing reputation as an inspiring, innovative provider of higher education of international renown. Recognised as .....Read more

The Holocaust Exhibition / 'Through Our Eyes'

The Holocaust Exhibition

'Through Our Eyes'

‘Through Our Eyes’ is an interactive exhibition following the life and times of a group of Holocaust survivors who as young people and children survived Nazi persecution in the 1930s and 1940s. Each story is different bu.....Read more

HUDDERSFIELD PSYCHOGEOGRAPHY NWK

HUDDS PSYCHOGEOGRAPHY NETWORK

Maybe you know Kirklees pretty well, or hardly at all. Whatever, wouldn’t it be brilliant if you could take that auto-pilot walk to work, that desultory drag round the shops or the routine trip to your Nan’s and turn it .....Read more

Vicky Hannon / Marketing Consultant & wannabe photographer/screen printer!

Vicky Hannon

Marketing Consultant & wannabe photographer/screen printer!

Hello! My name's Vicky & I'm the Creative Marketer/Director of Gingerfizz Marketing, a down to earth marketing company based in Huddersfield, West Yorkshire. I graduated from Huddersfield University in 2003 with a.....Read more

TellingTales / storyteller

TellingTales

storyteller

Once upon a time there was a girl who loved to pull silly faces and tug at peoples heart strings, so she became a storyteller, TellingTales always in her bright red shoes! Susanna Meese is an oral storyteller, animate.....Read more

Jane / Original Art Cards

Jane

Original Art Cards

Fine Art Printing jane@printsandcards.com Based in Mirfield, West Yorkshire. Formed two years ago Jane Young at Original Art Cards has been working to find the best matches for individual works of art. It makes a dif.....Read more

Wild Service

Wild Service

Wild Service is a small business where nothing is wasted. I coppice/sustainably manage local woodlands, lay hedges and produce greenwood craft items from the materials I gather. Neither the product nor the material tra.....Read more

Natalie Deane / Arts Education Consultant

Natalie Deane

Arts Education Consultant

I am currently employed part time as a Specialist Lead Teacher for Art, Craft and Design at Battyeford Primary School in Mirfield, Kirklees. This role has enabled me to create a national profile for art education at Bat.....Read more

John Chamberlain / Artist and Illustrator

John Chamberlain

Artist and Illustrator

Multi tasking Artist and Illustrator who mainly makes work for theatre companies, musicians, magazines and online journals...Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / / 12 / / 14 / / 16 / / 18 / / 20 / / 22 / / 24 /