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=7&page=32") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=7 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-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-27", DATEDIFF(`media`.`mediaCreated`, "2019-06-27"), DATEDIFF("2019-06-27", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-27", DATEDIFF(`media`.`mediaUpdated`, "2019-06-27"), DATEDIFF("2019-06-27", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-27", DATEDIFF(`userLastUpdate`, "2019-06-27"), DATEDIFF("2019-06-27", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-27", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-27"), DATEDIFF("2019-06-27", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `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(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=7 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/665)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/665)*`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`.`mediaChecked`=0 OR `media`.`mediaApproved`=1) AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=7 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=4 AND `userNetwork` IN (7) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-27", "2018-06-27") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-26", "2019-06-27")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 465, 15;
Creative Hertfordshire / Media / Images / Images / 466 to 480 of 784

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 / 466 to 480 of 784

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

Our Place / Your Place

Our Place / Your Place

Sculpture and drawings produced for and during a three month residency with Brent Museum and Archives November 2011-January 2012. Alex McIntyre worked in collaboration with poet Vicky Wilson. Using their art works to .....Read more

Our Place / Your Place2

Our Place / Your Place2

Sculpture and drawings produce for and during a three month residency with Brent Museum and Archives November 2011-January 2012. Alex McIntyre worked in collaboration with poet Vicky Wilson. Using their art works to s.....Read more

Our Place / Your Place3

Our Place / Your Place3

Sculpture and drawings produced for and during a three month residency with Brent Museum and Archives November 2011-January 2012. Alex McIntyre worked in collaboration with poet Vicky Wilson. Using their art works to.....Read more

Our Place / Your Place 4

Our Place / Your Place 4

Drawing and sculpture produced for and during a three month residency with Brent Museum and Archives November 2011-January 2012. Alex McIntyre worked in collaboration with poet Vicky Wilson. Using their art works to s.....Read more

Our Place / Your Place 5

Our Place / Your Place 5

Drawings and sculpture produced for and during a three month residency with Brent Museum and Archives November 2011-January 2012. Alex McIntyre worked in collaboration with poet Vicky Wilson. Using their art works to .....Read more

A Different Voice

A Different Voice

Drawings produced for Nothingness, an exhibition at Parndon Mill in August 2014 with artists Ella Carty, Hideki Arichi, Jo Howe and Will White...Read more

Leap of Faith

Leap of Faith

Drawings produced for Nothingness, an exhibition at Parndon Mill Gallery in August 2014 with Ella Carty, Hideki Arichi, Jo Howe and Will White...Read more

With the Tide

With the Tide

Drawings produced for Line and Location, an exhibition at Space 2 Gallery with Ross Loveday in September - October 2014...Read more

Point in Time

Point in Time

Drawing produced for Line and Location, an exhibition at Space2 Gallery, Watford Museum with Ross Loveday in September - October 2014...Read more

Against the Grain

Against the Grain

Drawing produced for Line and Location, an exhibition at Space2 Gallery, Watford Museum with Ross Loveday in September- October 2014...Read more

Leap of Faith I

Leap of Faith I

Drawing produced for Line and Location, an exhibition at Space2 Gallery, Watford Museum with Ross Loveday in September- October 2014...Read more

sji design.

sji design.

Our creative and technical expertise helped SJI Design solve a global problem for an African client ensuring that their client had the right image for their business. Specialisms : Image creation Sector : Creative..Read more

phillips plastics.

phillips plastics.

Our specialist branding expertise is helping Phillips Plastics Ltd deliver a distinctively innovative brand experience for The Design Library, establishing the right foundation to grow the service. Specialisms : Bran.....Read more

Grounds at West Clayton

Grounds at West Clayton

Acrylic paint on 300 year old panels..Read more

Artist at work for Panel3

Artist at work for Panel3

Artist at work for Panel3..Read more

/ 1 / / 20 / / 28 / 29 / 30 / 31 / 32 / 33 / 34 / 35 / 36 / / 43 / / 53 /