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=7") 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-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-24", DATEDIFF(`media`.`mediaCreated`, "2019-06-24"), DATEDIFF("2019-06-24", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-24", DATEDIFF(`media`.`mediaUpdated`, "2019-06-24"), DATEDIFF("2019-06-24", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-24", DATEDIFF(`userLastUpdate`, "2019-06-24"), DATEDIFF("2019-06-24", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-24", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-24"), DATEDIFF("2019-06-24", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `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`=4 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-24", "2018-06-24") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-23", "2019-06-24")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (13) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 90, 15;
Images on Creative Kirklees / Images / Music / 91 to 105 of 247

Images

This section of the site shows all the images added by Creative Directory members. You can also view video or audio by clicking on the link above (left on the grey bar).

Images / Music / 91 to 105 of 247

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

Singing Classes

Singing Classes

A photo from one of our Singing Classes...Read more

Songwriter 2012

Songwriter 2012

Finalists and performers at the Hertfordshire Songwriter 2012 celebration at The Forum Hertfordshire on Sunday 16th December 2012...Read more

String Instrument Tuition with Hertfordshire Music Service

String Instrument Tuition with Hertfordshire Music Service

Tuition on various string instruments is available for young people from Hertfordshire Music Service, from beginners to more experienced players, in schools or our Music Centres around the county. To find your nearest.....Read more

Guitar Tuition with Hertfordshire Music Service

Guitar Tuition with Hertfordshire Music Service

Tuition on classical and electric guitars is available for young people from Hertfordshire Music Service, for beginners to more experienced players, in schools or our Music Centres around the county. To find your near.....Read more

Woodwind Tuition with Hertfordshire Music Service

Woodwind Tuition with Hertfordshire Music Service

Tuition on various woodwind instruments is available for young people from Hertfordshire Music Service, from beginners to more experienced players, in schools or our Music Centres around the county. To find your neare.....Read more

Brass Tuition with Hertfordshire Music Service

Brass Tuition with Hertfordshire Music Service

Tuition on various string instruments is available for young people from Hertfordshire Music Service, from beginners to more experienced players, in schools or our Music Centres around the county. To find your nearest.....Read more

Piano Tuition with Hertfordshire Music Service

Piano Tuition with Hertfordshire Music Service

Piano tuition is available for young people from Hertfordshire Music Service, from beginners to more experienced players, in schools or our Music Centres around the county. To find your nearest music centre, please lo.....Read more

Drum Kit Tuition with Hertfordshire Music Service

Drum Kit Tuition with Hertfordshire Music Service

Drum Kit tuition is available for young people from Hertfordshire Music Service, from beginners to more experienced players, in schools or our Music Centres around the county. To find your nearest music centre, please.....Read more

World Music with Hertfordshire Music Service

World Music with Hertfordshire Music Service

World Music workshops are available for young people, families and groups from Hertfordshire Music Service, in schools or our Music Centres around the county. To find your nearest music centre, please look at our webs.....Read more

The Steam Punk Ball

The Steam Punk Ball

At The Steam Punk Ball @ The Museum of St Albans during MusicCity 2014..Read more

Robbie from UR Crew in the studio

Robbie from UR Crew in the studio

Recording a track at XC Studios..Read more

SAMBUKA

SAMBUKA

SAMBUKA..Read more

Albantide

Albantide

Albantide..Read more

Stevenage Day

Stevenage Day

Stevenage Day..Read more

Stevenage Day Festival

Stevenage Day Festival

Stevenage Day..Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / 12 / / 17 /