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`, "/")), "?network%5B0%5D=9&page=4") 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-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-17", DATEDIFF(`media`.`mediaCreated`, "2019-08-17"), DATEDIFF("2019-08-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-17", DATEDIFF(`media`.`mediaUpdated`, "2019-08-17"), DATEDIFF("2019-08-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-17", DATEDIFF(`userLastUpdate`, "2019-08-17"), DATEDIFF("2019-08-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-17"), DATEDIFF("2019-08-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `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/0)*IF(`userTotalItems`>0, 0, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/344)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/178)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings` 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 `userNetwork` IN (9) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-17", "2018-08-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-16", "2019-08-17")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 45, 15;
Images on Creative Kirklees / Images / 46 to 60 of 450

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 / 46 to 60 of 450

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

Workshop:  Part of the World Congress of Psychogeography

Workshop: Part of the World Congress of Psychogeography

This Pick Your Own Landscape workshop is part of the World Congress of Psychogeography taking place in Huddersfield on Friday and Saturday this week. Two perfomances at 14.00 and 15.15 By: Vicky Ola & Anzir Boodoo .....Read more

Batley Festival 2018

Batley Festival 2018

Batley Festival takes place in September each year to transform the centre of Batley for a family day out. Experience something different with the sights and sounds of high quality arts and street theatre, from some of .....Read more

Globe Arts Courses and Workshops

Globe Arts Courses and Workshops

Globe Arts in Slaithwaite have a great selection of workshops and courses coming up including this Saturday morning Watercolour course (6 October) with Ross Moore who will guide you through the basics skills to get the m.....Read more

Marsden Jazz Festival 12 - 14 October 2018

Marsden Jazz Festival 12 - 14 October 2018

Marsden Jazz Festival is recognised as being one of the UK’s longest-established jazz festivals. This year's festival has a packed programme of over 800 performers, 250 of which will be young musicians. As well as tic.....Read more

Hallowe'en Themed Organ Concert

Hallowe'en Themed Organ Concert

The Halloween concert at Huddersfield Town Hall on Monday 29 October gives the Town Hall’s Technicians a chance to show off their lighting effects for the Lunchtime audiences! Although some of the pieces appear regularl.....Read more

Image from Standedge Spooktacular Disco

Image from Standedge Spooktacular Disco

Image from Standedge Tunnel haunted Halloween party. Find out more at www.creativekirklees.com/a-piper/https-canalrivertrust-org-uk-enjoy-the-waterways-events-2018-1/..Read more

Market Showcase - Henry Morris Felt & Textile Artist

Market Showcase - Henry Morris Felt & Textile Artist

Felt and textile artist, Henry Morris, will be exhibiting his work as part of Temporary Contemporary's Market Showcase in Queensgate Market from Wednesday 31 October to Friday 14 December. Henry will be using one of t.....Read more

hcmf 2018

hcmf 2018

Huddersfield Contemporary Music Festival (hcmf//) is the UK’s largest international festival of new and experimental music and takes place in Huddersfield each year in November. The 2018 festival runs from Friday 16 to .....Read more

Canopy of Voices

Canopy of Voices

Canopy of Voices is the world premiere of Composer Supriya Nagarajan’s Pleiades Ne Maia, presented alongside a performance by four local choirs. (Saturday 24 November) Pleiades Ne Maia is inspired by the luminous seve.....Read more

WinterSongs in Slaithwaite

WinterSongs in Slaithwaite

Image from Jenny Goodman - In Good Voice - who runs singing workshops in Kirklees. This image is from her WinterSongs workshop in Slaithwaite on Saturday 8 December. For more information about the workshop and how to.....Read more

Brass Band Spectaculars: Kirklees Concert Season

Brass Band Spectaculars: Kirklees Concert Season

The ever-popular Christmas Brass Band Spectaculars return to Huddersfield and Dewsbury Town Hall with an abundance of festive favourites that are sure to get you in the seasonal spirit. A joyful sleigh-ride through h.....Read more

'Twas The Night Before Christmas at the LBT

'Twas The Night Before Christmas at the LBT

Image from the Lawrence Batley Theatre show ‘Twas The Night Before Christmas, presented by Front Room Productions. A show of music, poetry and a whole lot of festive fun for all the family on Sat 22 December 2018. For .....Read more

The Viennese Whirl

The Viennese Whirl

See out the old year and welcome in the new with a celebratory concert from the Orchestra of Opera North, with conductor Christopher Bell guiding you through this annual foray into one of the most musically significant c.....Read more

The Vinyl Fad

The Vinyl Fad

Adam Stroyan (aka thevinylfad) has worked at Vinyl Tap Records in Huddersfield for around 14 years. During that time he has built up a vast and diverse music knowledge and passion for new music as well as a decent record.....Read more

David Speight Photography

David Speight Photography

David Speight offers Yorkshire photography workshops for beginners. One is being held tomorrow (Weds 16 Jan). Although you may have missed this one, three more workshops are planned for February and one for March!..Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / / 12 / / 14 / 15 / / 20 / / 25 / / 30 /