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=40") 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-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-16", DATEDIFF(`media`.`mediaCreated`, "2019-07-16"), DATEDIFF("2019-07-16", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-16", DATEDIFF(`media`.`mediaUpdated`, "2019-07-16"), DATEDIFF("2019-07-16", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-16", DATEDIFF(`userLastUpdate`, "2019-07-16"), DATEDIFF("2019-07-16", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-16", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-16"), DATEDIFF("2019-07-16", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `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-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-16", "2018-07-16") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-15", "2019-07-16")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (13) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 585, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Music / 586 to 600 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 / 586 to 600 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

DanseHerts / Ickleford nr Hitchin

DanseHerts

Ickleford nr Hitchin

DanseHerts is a not for profit venture with the intention of promoting French/Breton traditional music and dance. DanseHerts is not just about dancing, it is also a social gathering aimed at encouraging people to pla.....Read more

30/09/2013 / Salisbury String Quartet

30/09/2013

Salisbury String Quartet

We are an experienced group of professional musicians who provide string quartet music for weddings and other functions. Our repertoire is very large and varied consisting of classical favorites through to the music fro.....Read more

Wyvern Theatre and Arts Centre / Wyvern Theatre and Arts Centre

Wyvern Theatre and Arts Centre

Wyvern Theatre and Arts Centre

We are the Wyvern Theatre and Arts Centre in Swindon. The Wyvern Theatre is a 635 seat venue with every seat designed to be no further than 70ft from the stage. The venue offers a mixed programme of concerts, comedy, dan.....Read more

Singing Aloud / CHOIR

Singing Aloud

CHOIR

We sing because we love it and it's fun! Come and join us and be uplifted by wonderful harmonies to a wide range of song styles, including Pop, traditional, gospel, world music and much more. Everything is taught .....Read more

Tappy Toes / Teeny Toes

Tappy Toes

Teeny Toes

Tappy Toes is a unique and captivating dance/movement class for boys and girls aged 20 months to 4.5 years. It is a fun and educational syllabus designed to stretch their imagination, build confidence and increase rhythm.....Read more

Rhapsode CIC

Based in Letchworth

Rhapsode is a Community Interest Company (social enterprise) and is an arts production company and creative consultancy. It has its own gallery and arts hub called Dot to Dot in Letchworth, it works with schools, runs an.....Read more

Nick

Salsa

Organiser of Salsa and Latin Events in Torbay..Read more

The Black Dog / Welcome

The Black Dog

Welcome

Our venue has two halves and we aim to serve two communities. We cater for the general people of Northgate and Crawley but we also look to work with and develope the arts community. Currently we have live music twi.....Read more

Socani Music & Arts CIC

Supporting Our Community

Socani Music & Arts is a unique social enterprise company which seeks to engage members of the community, through music and arts. Socani Music & Arts provides a wide range of musical and artistic activities which prom.....Read more

Herts Community Youth Choir / About Us

Herts Community Youth Choir

About Us

The Hertfordshire Community Youth Choir (HCYC) is for mixed voices aged 7-21 and is for those that want to have fun and learn new skills at the same time. The rehearsals include popular songs, music from the shows, and m.....Read more

Chris Umney / lighting & sound design / production & technical management

Chris Umney

lighting & sound design / production & technical management

I am a freelance lighting and sound designer with over twenty five years experience working with theatre, dance and circus companies around the world. I also work as a production and technical manager as well as developi.....Read more

John Wiles / Jazz pianist

John Wiles

Jazz pianist

SET the perfect atmosphere on your special day with live background music from me, jazz pianist John Wiles. Whether you're planning a wedding reception, dinner party, or corporate function, a personalised performance .....Read more

kick up the arts / watford creative networking

kick up the arts

watford creative networking

Kick up the Arts is a laid back evening for Watford and nearby creatives to make new friends, drink coffee, exchange ideas, get advice. All levels welcome, pros and hobbyists: filmmakers, musicians, crafters, artists, ph.....Read more

Stevenage Choral Society / Stevenage Choral Society

Stevenage Choral Society

Stevenage Choral Society

We are a mixed voice choir with members of all ages and abilities. No audition is necessary to join and you can receive a warm welcome to our choir or our concerts. Please do contact us, or check out our website for more.....Read more

Alexandra Jones / Vintage Singer and Children's Story Teller

Alexandra Jones

Vintage Singer and Children's Story Teller

Hi I'm Alex and 'alexshows.co.uk' is my very own business. I trained in Musical Theatre from The Brit School of Performing Arts in London, and graduated from Winchester University with a BA(hons) in Performing Arts. .....Read more

/ 1 / / 30 / / 36 / 37 / 38 / 39 / 40 / 41 / 42 / 43 / 44 / / 48 / / 53 /