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&letter=l") 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-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-21", DATEDIFF(`media`.`mediaCreated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-21", DATEDIFF(`media`.`mediaUpdated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-21", DATEDIFF(`userLastUpdate`, "2019-08-21"), DATEDIFF("2019-08-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-21"), DATEDIFF("2019-08-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `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`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*l" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (13) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Music / L / 1 to 15 of 36

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 / L / 1 to 15 of 36

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

Laura Dugmore / Laura Loft Music

Laura Dugmore

Laura Loft Music

South West based artist, Laura Loft exudes charisma as she plays her endearing folk influenced songs with a wistful and nostalgic charm. Having released 3 EPs with her past group The Laura Dugmore Band (J'aime La Vi.....Read more

Laura Stimpson / The Voice of Yesteryear

Laura Stimpson

The Voice of Yesteryear

I am a vintage singer based in Huddersfield singing songs from the 1920s to 1950s including jazz, swing, wartime and musicals. I have performed in many venues across Kirklees and Yorkshire including: The Carding Shed, Hu.....Read more

Laurence Elliott / paintings, drawings etc.

Laurence Elliott

paintings, drawings etc.

I'm an artist who draws, paints, makes prints when I can & make books of photocopied drawings & rants relevant to the body of paintings, songs etc. I'm working on. I try to make one a year. I've always felt that my work .....Read more

Le Chat Noir

Le Chat Noir

Le Chat Noir are Dartmoor-based hard-rocking Transatlantic desperadoes Teddy Hesper (vocals, guitar) and Eileen Spruce (drums, vocals). Since Spruce moved to England in late 2006 from her native Los Angeles, the band ha.....Read more

Le Vendredi Danse / Le Vendredi Danse

Le Vendredi Danse

Le Vendredi Danse

A monthly French social dance session held at Honley Village Hall, Roundway, Honley. Informal, friendly, with full tuition given for beginners. Live music - new musicians welcome...Read more

Lea Singers / Lea Singers

Lea Singers

Lea Singers

The Lea Singers are a Harpenden-based chamber choir of 30 singers. Our aims are to achieve high standards of singing and performance, and to contribute to our local community. Our annual programme typically includes.....Read more

Lechlade Festival / Lechlade Festival 2017

Lechlade Festival

Lechlade Festival 2017

Lechlade Music Festival 26th – 28th May 2017 3 Days, 3 Nights, 3 Stages The beautiful Cotswolds town of Lechlade on Thames plays host once again to the acclaimed 3 day family-friendly music festival over the late Ma.....Read more

Lechlade Festival / Lechlade Music Festival

Lechlade Festival

Lechlade Music Festival

Lechlade Festival Headliners Announced Three iconic 80s bands have been announced as headliners at next month’s Lechlade Music Festival. Punk princess Toyah Willcox will headline on Friday 23rd May, with Dr and the Med.....Read more

Lemonrock / Music Gig Guide

Lemonrock

Music Gig Guide

Lemonrock Gig Guide is an active community of UK bands and venues who list their own live music events, so you can find gigs anywhere! If you're in a band, or run a venue that puts on live music, join Lemonrock and re.....Read more

Leo Brazil and his Twitch / Psychedelic, rock and blues band

Leo Brazil and his Twitch

Psychedelic, rock and blues band

Rocking and original memorable music featuring guitar, bass, drums, trumpet and violin. Available as either full band (guitar, violin, bass and drums) or solo acoustic (and duo/trio) Style: psychedelic, pop, blues, co.....Read more

Letchworth Arcadians / Letchworth Arcadians

Letchworth Arcadians

Letchworth Arcadians

So – you can sing, you’ve always fancied being on stage, maybe do a little bit of acting or dancing and are aged 16 or over, then maybe you’re just the sort of person we’re looking for to join our friendly society. W.....Read more

Letchworth Sinfonia

Letchworth Sinfonia

Letchworth Sinfonia is a friendly amateur chamber orchestra performing twice a year (January and June) at venues in Hertfordshire's first garden city. We rehearse fornightly, under professional leadership, at The Sett.....Read more

Life Care Radio / Who We Are

Life Care Radio

Who We Are

Life Care Radio is a charitable incorporated organisation started, run and maintained solely by volunteers with the aim of providing a high quality, personalised radio service to people in long term care, residential hom.....Read more

Lifemusic / Connecting People to Time!

Lifemusic

Connecting People to Time!

The Lifemusic method uses improvised creative music making for health, wellbeing, community building - and for the pure joy of making music. Using instrumental and vocal 'games' (or 'holding forms'), music makers find t.....Read more

LIGERS

LIGERS

The London music scene is constantly churning out new bands who appear one moment, and disappear the next. One band who may yet to break that cycle are eclectic folk-tinged four-piece Ligers. Formed from the ashes of.....Read more

1 / 2 / 3 /