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=13") 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 (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 787

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 787

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

VIRSA / HARDEEP SAHOTA

VIRSA

HARDEEP SAHOTA

Hardeep Singh Sahota is a leading authority on Bhangra, and has been one of the prominent forces in the UK delivering high quality Bhangra workshops, lectures and seminars over the last two decades. As a secondary school.....Read more

Fret - Don't Fret / Welcome To Our World

Fret - Don't Fret

Welcome To Our World

Fret - Don't Fret is located in the centre of Doncaster and through this page, we aim to give you a feel for what we offer in our shop, and provide some useful advice and information. Here at FDF, we look forward to ge.....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

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

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

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

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

&Piano / &Piano Music Festival

&Piano

&Piano Music Festival

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

Huddersfield Choral Society / Choral Society

Huddersfield Choral Society

Choral Society

Founded in 1836, the Huddersfield Choral Society has developed an international reputation as one of the UK's leading choral societies. Our Junior Choirs were formed in 1986. The Society's busy schedule is centred on it.....Read more

Hepworth Brass Band / Hepworth Brass Band

Hepworth Brass Band

Hepworth Brass Band

HEPWORTH BAND CHAMPIONSHIP BRASS IN THE HOLME VALLEY Hepworth, the village from which the band takes its name is situated on the edge of the Peak District National Park, close to the ‘Summer Wine’ town of Holmfirth i.....Read more

Cleckheaton Folk Festival / Cleckheaton Folk Festival 2019

Cleckheaton Folk Festival

Cleckheaton Folk Festival 2019

Family friendly folk festival in the heart of West Yorkshire. 5th, 6th & 7th July 2019 Visit our website for further details and ticket pricing Concerts, Ceilidh, Morris Sides, Workshops and Special Events. Street En.....Read more

New Orleans Wiggle / New Orleans Wiggle Jazz Band

New Orleans Wiggle

New Orleans Wiggle Jazz Band

6 piece jazz band playing the music from the early days of New Orleans including standards, ragtime, blues, spiritual for dancing, parties, weddings, festivals, indoors or outside. Our regular friendly monthly venue on.....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

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

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