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(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")) AS `desc`,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("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-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-20", DATEDIFF(`media`.`mediaCreated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-20", DATEDIFF(`media`.`mediaUpdated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-20", DATEDIFF(`userLastUpdate`, "2019-08-20"), DATEDIFF("2019-08-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-20"), DATEDIFF("2019-08-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `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`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*g" 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, 50;
Images on Creative Kirklees / Images / Music / G / 1 to 9 of 9 https://www.creativekirklees.com/directory/images/?disc%5B0%5D=13&letter=g&view=rss Images from artists and creatives on Creative Kirklees. There’s some amazing work on show so take a look and see what is being produced by artists in our Creative Directory. Gabriel and the hip-hopping heavenly host in AlterNativity Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/alternativity-musical/gabriel-hip-hopping-heavenly-host-alternativity/ Photo of the angels in AlterNativity, performed by the OVOTeens at the Maltings Arts Theatre, St Albans, Christmas 2012 Gordon Stewart Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-concert-season/gordon-stewart/ Gordon Stewart sat at the Father Willis Organ, Huddersfield Town Hall Greneway Choir at Royston Arts Festival 2016 Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/creative-royston/greneway-choir-at-royston-arts-festival-2016/ Image copyright Terry Hartga 2016 Group Recording Sessions Mon, 30 Nov -001 00:00:00 +0000 https://creativedoncaster.com/rob-pearson/group-recording-sessions/ Record your group with our mobile recording studio. Guitar Lessons Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/strumanddrum/guitar-lessons/ Focused guitar tuition Guitar Tuition with Hertfordshire Music Service Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/hertfordshire-music-service/guitar-tuition-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... Guy Johnston, Esther Hoppe, Alasdair Beatson, Hatfield House Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/hatfield-house-music-festival/guy-johnston-esther-hoppe-alasdair-beatson-hatfield-house/ Guy Johnston, Esther Hoppe, Alasdair Beatson, Hatfield House Chamber Music Festival Guy Johnston, Hatfield House Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/hatfield-house-music-festival/guy-johnston-hatfield-house/ Guy Johnston, Artistic Director of the Hatfield House Chamber Music Festival Gypsy Switch @ Dromos, Coombes Farm 2012 Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/dromosfestival/gypsy-switch-dromos-coombes-farm-2012/ Gypsy Switch @ Dromos, Coombes Farm 2012