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`, "/")), "?network%5B0%5D=9&page=33") 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/0)*IF(`userTotalItems`>0, 0, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/569)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/232)*`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`.`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")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 480, 15;
Directory of artists and creative organisation in Kirklees / Profiles / 481 to 495 of 563

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 / 481 to 495 of 563

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

Dan Summers Web Design / Dan Summers

Dan Summers Web Design

Dan Summers

HI, I am a Web Designer based in Golcar, Huddersfield. I specialise in affordable, modern, responsive websites that look great on any device. I also offer logo design and any print requirements such as flyers and b.....Read more

Hepworth Parish Church / Hepworth Village

Hepworth Parish Church

Hepworth Village

Hepworth Parish Church in the Holme Valley not only serves as a place of worship for the three villages of Jackson Bridge, Scholes and Hepworth, it is also the venue for events such as exhibitions, concerts and even a fa.....Read more

Breaking Free Design / Breaking Free Design

Breaking Free Design

Breaking Free Design

Breaking Free Design are a creative design and print organisation based in Huddersfield, our main aim is to make business beautiful, we take your passion and convert that into a visual representation for your business...Read more

Slaithwaite Guitar School / THE place in Huddersfield to learn to play guitar

Slaithwaite Guitar School

THE place in Huddersfield to learn to play guitar

Slaithwaite Guitar School was established by David Whitaker in 2005 to offer quality tailor made lessons in a friendly and relaxed environment for all ages and abilities. ​ Learn what you want at your own pace; lessons.....Read more

Sakura Community Music Therapy / Sakura Community Music Therapy

Sakura Community Music Therapy

Sakura Community Music Therapy

Sakura is a Music Therapy service providing individual and group sessions to individuals and organisations across Kirklees and the surrounding areas. Run by Rebecca, a qualified and HCPC registered Music Therapist...Read more

hellomint / socialmedia

hellomint

socialmedia

hellomint is a creatively minded digital marketing agency in Huddersfield. Specialising in social media management, the firm can also provide website design services, content marketing, SEO, PPC and graphic design...Read more

Enj-Eye Creations / Enj-Eye

Enj-Eye Creations

Enj-Eye

Creator of Bottle Dolls custom made to look like you and yours. Upcycled bottles and recycled materials as much as possible. Hand painyed. Hand crafted. Unique, bespoke, gifts, centre pieces. Creator of Feel Good.....Read more

Colne Valley Male Voice Choir / Colne Valley Male Voice Choir

Colne Valley Male Voice Choir

Colne Valley Male Voice Choir

One of the best Male Voice Choirs in the country, Colne Valley Male Voice Choir welcomes ordinary guys who love singing and together we make great music. With the patient leadership of our terrific Musical Directo.....Read more

The Base Collective / Designers and Arti

The Base Collective

Designers and Arti

The BASE Collective is inhabiting the top floor of Bates Mill. We are all freelancers running our own businesses. Our strength lies in collaborating on projects where they share ideas and clients. This is a great adv.....Read more

The Welcome Centre / Marshfest

The Welcome Centre

Marshfest

We are Huddersfield's largest food bank and a registered charity providing support, advice and basic essentials to local people in need. Every year Marsh Blues Club holds an amazing family festival to raise money for o.....Read more

Mirfield Arts Festival / Mirfield Arts Festival

Mirfield Arts Festival

Mirfield Arts Festival

An annual celebration of the arts held in mid-July, offering a wide range of arts and crafts activities, performances, film screenings & concerts. Partner venues include Mirfield Library, Creative Arts Hub, West Yorkshir.....Read more

The Parish / ParishBarsLtd

The Parish

ParishBarsLtd

Parish Bars Ltd is a company trading over 3 sites in Huddersfield Town Centre & a promotions company running events all over the UK The Parish // 28 Kirkgate // HD11QQ The Parish is a Live Music Venue & Public Hous.....Read more

TB Productions / TB Productions

TB Productions

TB Productions

TB Productions specialise in live events and technical production. We're experienced in providing PA systems, lighting, video, and staging equipment to the events industry. We offer a full production service complete wit.....Read more

Red Cape / We're Just a bit #Roarsome

Red Cape

We're Just a bit #Roarsome

From event planning, through to recap and evalution, we're a one stop shop for the event you're planning to put on... We've worked with multi-million pound shopping centres & film productions as well as sole operator tra.....Read more

Mahmud / Mahmud Manning

Mahmud

Mahmud Manning

I deliver creative workshops for all ranges of people, especially focused towards young men of 16 years plus. I teach creative geometry, which is both 2D & 3D. I am DBS Checked. I trained in London & Istanbul and teac.....Read more

/ 1 / / 20 / / 29 / 30 / 31 / 32 / 33 / 34 / 35 / 36 / 37 / 38 /