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`=1 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-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-18", DATEDIFF(`media`.`mediaCreated`, "2019-07-18"), DATEDIFF("2019-07-18", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-18", DATEDIFF(`media`.`mediaUpdated`, "2019-07-18"), DATEDIFF("2019-07-18", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-18", DATEDIFF(`userLastUpdate`, "2019-07-18"), DATEDIFF("2019-07-18", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-18", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-18"), DATEDIFF("2019-07-18", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `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(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=1 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` 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`=1 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=4 AND `userNetwork` IN (1) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-18", "2018-07-18") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-17", "2019-07-18")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
Creative Torbay / Main Navigation / Media / Images / Images / 1 to 50 of 7875 https://www.creativetorbay.com/media/images/?network%5B0%5D=1&view=rss St Helen's, Stonegate, York. Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/andrew-lucas/st-helen-s-stonegate-york/ " St Helen's " Stonegate, York, England. Andrew Lucas Watercolour, 27 x 19 cm Personalised Cushions,Bespoke Cushions,Tailor Made Cushions,UK Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/fun-cushions/personalised-cushions-bespoke-cushions-tailor-made-cushions-uk/ Fun Cushions provide personalised luxury embroidered cushions, tailor made cushions, bespoke dog cushions, cushions with messages such as wedding present cushions and personalised birthday cushions to make occasion very ... Monogram light catcher Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/on-glass-co-uk/monogram-light-catcher/ www.onglass.co.uk Fougou Music logo Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/fougoumusic/fougou-music-logo/ Fougou Music logo Cob Horse Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/alainpezard/cob-horse-hatherleigh/ This cob horse was make with the children of the primary school in Hatherleigh over a period of 4 days Cob horse Hatherleigh Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/alainpezard/stoke-road/ This cob sculpture was made a year ago , the cob has been covered with lime rendering " The old pharmacy " Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/andrew-lucas/the-old-pharmacy/ A view of this historic building in Krasnaya Street, Krasnodar, Russia. Compass rose round window Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/on-glass-co-uk/compass-rose-round-window/ Bespoke etched glass designs - www.onglass.co.uk CDSRail Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/cdsrail/ CDSRail is the leading supplier of remote condition monitoring of railway infrastructure. The company has dedicated itself to serving this sector for over 15 years and has developed the tailor-made AssetWatch monitoring ... Centurion Racing Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/centurion-racing/ Centurion Racing was established in August 2005 after seeing the potential of their very first rider for the team, after watching him test. It was decided to establish the team from what it was to what it is now, Centuri... LMB Supplies Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/lmb-supplies/ LMB Supplies is an online shop for purchasing a wide range of environmentally conscious janitorial supplies made by LMB and other suppliers. This fully featured e-commerce system has a large amount of products arranged ... Sharp's Brewery Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/sharp-s-brewery/ Sharp's Brewery is a modern brewer of cask conditioned beer. Since its foundation in 1994 at Rock in Cornwall the Brewery has grown rapidly to become the largest brewer of cask beer in the South West and brewer of Doom B... Devon Classic Cars Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/devon-classic-cars/ Devon Classic Cars provide a complete service in classic and period cars from restoration to sales. Based at Ermington Devon they have a unique selection of classic vehicles ranging from the 1930's to 1980's. Their compr... CRASkit Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/craskit/ Produced for Centurion Risk Assessment Services Ltd. The CRASkit site is designed to promote their range of safety products. Each product has its own microsite which all link back to a contact form, to provide a defined ... Hexydec Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/hexydec/hexydec/ Beach flower Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/tracy-lawrence/beach-flower/ This picture was taken on the beach in Brazil. Christ the redeemer Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/tracy-lawrence/christ-the-redeemer/ Dolphin diving Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/tracy-lawrence/dolphin-diving/ Off the west coast of Australia bristol docks Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/bristol-docks/ bristol_from_cabot_castle Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/bristol-from-cabot-castle/ collage Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/collage/ elephant01 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/elephant01/ trees Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/trees/ Image_01 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-01/ Image_02 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-02/ Image_03 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-03/ Image_04 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-04/ Image_06 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-06/ Image_07 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-07/ Image_08 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-08/ Image_09 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-09/ Image_10 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-10/ Image_12 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-12/ Image_13 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-13/ Image_14 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-14/ Image_16 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-16/ Image_17 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/image-17/ Sweethaven Branding Concepts Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/sweethaven-branding-concepts/ Sweethaven Branding Concepts Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/sweethaven-branding-concepts-1/ Geopark Film Invite Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/geopark-film-invite/ Geopark Film Illustrations Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/geopark-film-illustrations/ Geopark Film Illustrations Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/geopark-film-illustrations-1/ Selected Illustration Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/selected-illustration/ Selected Illustration Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/selected-illustration-1/ Fashion Illustration - Amelia's Magazine Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/fashion-illustration-amelia-s-magazine/ Fashion Illustration - Amelia's Magazine Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/fashion-illustration-amelia-s-magazine-1/ Fashion Illustration Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/bex/fashion-illustration/ BBC - Bag a Bug Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/drewbaker/bbc---bag-bug/ Bag a Bug pac man style video game for CBBC BBC - Bag a Bug slide 2 Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/drewbaker/bbc---bag-bug-slide-2/ Pac man style video game for CBBC slide 2 Nanny McFee mud splat game Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/drewbaker/nanny-mcfee-mud-splat-game/ Working as developer on the project for the esteemed Redberry Digital, we delivered this interactive mud fest