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-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-22", DATEDIFF(`media`.`mediaCreated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-22", DATEDIFF(`media`.`mediaUpdated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-22", DATEDIFF(`userLastUpdate`, "2019-07-22"), DATEDIFF("2019-07-22", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-22", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-22"), DATEDIFF("2019-07-22", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `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/504)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/225)*`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`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*o" 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 / O / 1 to 18 of 18 https://www.creativekirklees.com/directory/images/?network%5B0%5D=9&letter=o&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. Oak and porcelain ceiling light Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/ammie-flexen/lighting-panels/ Oak and porcelain lighting installation. Collaboration with John Flexen On the hillside Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/gemma-shearing-felt-artist/on-the-hillside/ Lush green fields and tree lined hills. On your doorstep... Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/enjoy-art/on-your-doorstep/ You'll find us conveniently located between Manchester and Leeds, and within a 5min walk from Marsden train station – and spitting distance from the legendary Riverhead pub! Our lovely contemporary gallery is in the cent... Opera North Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-concert-season/opera-north/ In Concert at Huddersfield Town Hall Opera North opens 2018-19 Kirklees Concert Season Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/kirklees-concert-season/opera-north-opens-2018-19-kirklees-concert-season/ The Orchestra of Opera North will open this year’s Kirklees Concert Season in a burst of Caledonian colour, with works by Malcolm Arnold, Debussy and Mendelssohn hand-picked by Scottish conductor Garry Walker to summon t... Orangebox Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/splitpixel/orangebox/ Orangebox Responsive Website - an amazing young people's centre with rooftop skate park, recording studio, bouldering tunnel to name a few. The response to the new site has been brilliant, so they've tweeted! Oriental Tree Scape Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/gemma-shearing-felt-artist/oriental-tree-scape/ This oriental tree scape was created for a client with a swanky bachelor pad, with a monochrome theme throughout. Original Painting Framed in an Artists Tray by English Framing Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/english-framing-co/original-oil-painting-framed-in-an-artists-tray-by-english-frami/ Original Oil Painting Framed in an Artists Tray by English Framing Co Our stall Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/stall-19/our-stall/ Our stall has changed appearance again! Our Work - Balance Accountants Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-engine-room-design/our-work-balance-accountants/ With no clear belief in the products or services they were selling, no plan to target specific opportunities and no proposition to market the business on, management was ready for a change. The company had a strong desir... Our Work - GRAFT Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-engine-room-design/our-work-graft/ Having developed an innovative new technology in one product category, Polyseam was keen to develop its own brand to bring this technology to market, calling the finished product ‘IPT’. They approached The Engine Room fo... Our Work - Mach Aire Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-engine-room-design/our-work-mach-aire/ Mach-Aire is a traditional engineering company with over 20 years’ presence and experience in their sector, specialising in containment, circulation and airflow technology. Being one of the first businesses in this secto... Our Work - Relative Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-engine-room-design/our-work-relative/ As a start-up business, Relative was keen to take a different approach to accountancy compared to the traditional route. A consultancy-led process fitted with its strategic vision, and the directors were in search of a b... Our Work - Sandwich King Brand Project Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-engine-room-design/our-work-sandwich-king-brand-project/ Sandwich King already had an admirable reputation as a food supplier to multiple industries including schools, universities, food distribution and retail. The brand and its communications were insufficient for the ever-g... Our Work - Xercise4Less Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-engine-room-design/our-work-xercise4less/ Xercise4Less provide some of the largest and most up-to-date fitness facilities on the market at the lowest membership prices. The original identity and communications strategy had served to get the business up and runni... owl Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/terriiiii/owl/ owl a4 art print Owl and Pussycat Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/frances-noon/owl-and-pussycat/ Made in wood, copper & brass. Ozzbest Marshfest 2019 Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/marshfest2019/ozzbest-marshfest-2019/ marshfest.net