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%5B0%5D=13&page=1") 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-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-25", DATEDIFF(`media`.`mediaCreated`, "2019-06-25"), DATEDIFF("2019-06-25", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-25", DATEDIFF(`media`.`mediaUpdated`, "2019-06-25"), DATEDIFF("2019-06-25", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-25", DATEDIFF(`userLastUpdate`, "2019-06-25"), DATEDIFF("2019-06-25", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-25", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-25"), DATEDIFF("2019-06-25", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `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-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-25", "2018-06-25") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-24", "2019-06-25")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (13) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Music / 1 to 15 of 785

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 / Music / 1 to 15 of 785

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

ICA-Perform / Hall Cross Academy

ICA-Perform

Hall Cross Academy

ICA-Perform is a venture that formalises the outstanding range and quality of Performing Arts on offer at Hall Cross Academy. It defines an enhanced entitlement for students and broadens the curriculum offer in and aroun.....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

Mirfield Choral Society / Choral Society

Mirfield Choral Society

Choral Society

Although Mirfield is known to have had a Choral Society in the late 1800's which disbanded after the turn of the century, it was reformed in 1940 firstly as The Glee Choir, then The Vocal Society and eventually in 1974 a.....Read more

Love4Music Festival / Love4Music

Love4Music Festival

Love4Music

The LOVE 4 MUSIC FESTIVAL returns for the 2nd year, following the success of the 2018 inaugural event, on Bank Holiday Sunday 26th May Love 4 Music 2019 is set to deliver a bigger and better experience, showcasing an ex.....Read more

Dewsbury Arts Group / Dewsbury Arts Group

Dewsbury Arts Group

Dewsbury Arts Group

Community Arts Organisation presenting a full season of plays, musicals and youth productions plus two Annual Art Exhibitions and regular in house exhibitions. The group has its own premises and theatre at Lower Peel St.....Read more

Marshfest 2019 / Marshfest 2019

Marshfest 2019

Marshfest 2019

Marsh Blues Club in association with The Welcome Centre proudly presents Marshfest 2019, July 19th - 20th. This family friendly music festival is held within the stunning grounds of the Ukraine Club, Huddersfield and .....Read more

Small Seeds / smallseedstalltrees

Small Seeds

smallseedstalltrees

An indoor woodland music venue and bar programming music events such as... 'The Acoustic Club' - A weekly Open-Mic night now it its 17th year with musicians, poets and quiz. (Every Tuesday - Free entry) 'Friday Ni.....Read more

Kirklees Concert Season / 2019-20

Kirklees Concert Season

2019-20

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

hcmf// / Huddersfield Contemporary Music Festival

hcmf//

Huddersfield Contemporary Music Festival

Huddersfield Contemporary Music Festival (hcmf//) is an annual international festival of contemporary and new music that takes place over 10 days each November consisting of approximately 50 events, including concerts, m.....Read more

Denby Dale Ladies' Choir

Denby Dale Ladies Choir

Denby Dale Ladies’ Choir is a three-part ensemble of around 40 voices. Our varied repertoire is always growing and includes classical, traditional, jazz, showtime and modern pieces. We love singing and our track record o.....Read more

Dex Hannon / 4 artists, one mind

Dex Hannon

4 artists, one mind

I make and use sounds. I paint abstract paintings and sometimes remix them to create new digital interpretations. I sometimes take photos. I also shape sentences into interesting stories. I go where the idea tak.....Read more

Musica Kirklees / Music Education for All

Musica Kirklees

Music Education for All

Musica Kirklees provide instrumental lessons and ensemble experiences for children and adults throughout Kirklees. We also deliver workshops for community groups and whole class/Whole Class Ensemble Tuition (WCET) in .....Read more

Thornhill Parish Church / Listed church

Thornhill Parish Church

Listed church

A superb Grade 1 Listed building in the heart of the THORNHILL CONSERVATION AREA in Dewsbury Now fully restored and conserved for use by the wider community in the 21st century. Full disabled facilities. As well as a .....Read more

Doncaster Music Education Hub / Youth Music

Doncaster Music Education Hub

Youth Music

Doncaster Music Education Hub is a collection of partners working together to provide every child in Doncaster the opportunity to sing and learn a musical instrument, and to perform as an ensemble regardless of race or g.....Read more

Manasamitra / South Asian arts organisation re-imagines...

Manasamitra

South Asian arts organisation re-imagines...

Manasamitra is a Yorkshire based arts organisation delivering a range of South Asian arts and cultural experiences in traditional and innovative ways. The company’s work is stimulated by ideas, forms and aesthetics from .....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 13 / / 18 / / 23 / / 28 / / 33 / / 38 / / 43 / / 48 / / 53 /