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-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-24", DATEDIFF(`media`.`mediaCreated`, "2019-06-24"), DATEDIFF("2019-06-24", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-24", DATEDIFF(`media`.`mediaUpdated`, "2019-06-24"), DATEDIFF("2019-06-24", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-24", DATEDIFF(`userLastUpdate`, "2019-06-24"), DATEDIFF("2019-06-24", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-24", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-24"), DATEDIFF("2019-06-24", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `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`, `mediarefinements` 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`=1 AND IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*o" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (5) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 50;
Creative Network / directory / Profiles / Arts and Crafts / O / 1 to 17 of 17 https://www.creativetorbay.com/directory/?disc%5B0%5D=5&letter=o&view=rss Creative Torbay a state of the art directory for creative, arts, cultural people, places and businesses to showcase their work (events, news, jobs, video, images etc) and connect with each other and audiences. Oglee Poglee / Creative workshops and parties for children Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/oglee-poglee/ Oglee Poglee offers creative workshops and parties full of messy fun and adventure. Weekly workshops in Berkhamsted are aimed at the under 5's and focus on letting children explore different creative techniques and mate... Oil Paintings UK / Oil Paintings UK: Modern British Paintings, Victorian Paintings Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/oil-paintings-uk/ The gallery stocks oil paintings from £1,000 to £100,000 including modern British paintings, Victorian paintings, European paintings, Marine Paintings, post impressionist, impressionist Paintings, Barbizon Paintings to N... Old Paignton Antiques / Old Paignton Antiques Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/old-paignton-antiques/ A new arrival to the historic old quarter of Paignton's Winner Street offering quality period antiques , furniture, ceramics, bronzes, paintings and decorative arts to suit all budgets and taste. Old Paignton Antique... OliHillAcrylicArtist / Oli Hill Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/olihillacrylicartist/ About I am a Somerset based artist who specialises in acrylic on canvas paintings. I also undertake commissioned graphics work, tattoo design, customised greetings cards, website building, wall murals for homes and bu... One Craft Gallery / Cooperative Gallery - Shepton Mallet Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/one-craft-gallery/ One Craft Gallery is different from most other shops and galleries that you will find on the high street. It is a cooperative, stocked, staffed and run by a group of now 17 local craftspeople - including 6 jewellers, ar... Opal / Opal Seabrook at Starburst Glass Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/opal-1/ An artist for over 20 years, working specifically in glass for more than 10, I merge traditional stained glass methods and modern fusion and screen printing methods, incorporating materials such as wood and metal to crea... Open Door / Community Space, Berkhamsted Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/open-door/ We are a Creative Community Space in Berkhamsted, run entirely by volunteers for The Way Inn Christian Centre Trust. We run exhibitions and offer space for artists, courses for adults and children, and venue for hire fo... Orchard Learning Studios / Orchard Learning Studios Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/orchard-learning-studios/ Fully equipped Studio on the Devon/Cornwall border, offering a huge range of courses and workshops in Cookery, Craft and Leisure activities. We love to create a family atmosphere, encouraging generations to come and l... Otter Bookbinding / Designer Bookbinders Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/otter-bookbinding/ Imaginative, beautifully executed designer bookbindings. Marysa de Veer, the owner of the Otter Bindery, specialises in innovative contemporary work, bringing her skills as a designer, and enthusiasm for her craft t... Otter Gallery / Art Space Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/wwwchiacukottergallery/ The Otter Gallery is an art space that encourages engagement, discussion and participation with visual art. It is a public gallery with free admission, supported by the University of Chichester and based at the Chicheste... Otterton Mill / Habit Art Otterton Mill Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/otterton-mill/ An innovative exhibition by established and emerging Devon based artists to highlight the important debates about our environment. Local artists Bob Budd and Emma Brogan are showing alongside students Cleo Heard, Hilary... OurGlass / OurGlass Studio Glassblowers Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/ourglass/ OurGlass design and produce an innovative range of studio glassware using traditional glassblowing techniques. Situated within the original stableyard adjacent to Cockington Court, the OurGlass studio is open every day, ... Out of Hours / About Out of Hours Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/out-of-hours/ Out of Hours is a multi-disciplinary artist collective based in Huddersfield, West Yorkshire. This group of like minded individuals was brought together in 2012 by a shared interest in making things happen, with the purp... Outside In / Opportunities for artists to exhibit works Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/outside-in/ Set up in 2006, Outside In's purpose is to showcase and give opportunity to artists who would otherwise be excluded from the cultural life of their community. Outside In has no set creative criteria, boundary in art proc... Owls Go Hoot / graphic design, paper goods and textiles Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/owls-go-hoot/ Owls Go Hoot is a small paper goods and textiles business run by me, Natalie Jones. I draw, design and print a selection of greetings cards and postcards as well as my own bags and textile goods. I also work as a graphi... Oxhey Woods Sculpture Trail / South Oxhey Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/oxhey-woods-sculpture-trail/ Oxhey Woods Sculpture Trail, a hidden gem Oxhey Woods Local Nature Reserve in South Oxhey, Watford, consists of approximately 100 hectares of principally, ancient semi-natural woodland, much of which has been wooded s... Oyster Cove / Oyster Cove Handmade Soaps, Candles and Other Nice Things! Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/oyster-cove/ Situated in Torbay we create handmade indulgent delights such as Soap, Bath Bombs, Bath Truffles, Shell Candles, Fabulous Scented Candles etc. We can be found all around Torbay and further afield at different Art and Cra...