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`)>150, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 150), "..."), `media`.`mediaText`), "\r", ""), "\n", " "), "&", "&"), "\"", """), "\'", "'"), "<", "<"), ">", ">")="", "", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>150, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 150), "..."), `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=5&page=4") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=5 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-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-17", DATEDIFF(`media`.`mediaCreated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-17", DATEDIFF(`media`.`mediaUpdated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-17", DATEDIFF(`userLastUpdate`, "2019-07-17"), DATEDIFF("2019-07-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-17"), DATEDIFF("2019-07-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-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(51.013397))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.106869))+SIN(RADIANS(51.013397))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(51.013397))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.106869))+SIN(RADIANS(51.013397))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(51.013397))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.106869))+SIN(RADIANS(51.013397))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=5 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/1957)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/1573)*`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`=5 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=1 AND `userNetwork` IN (5) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-17", "2018-07-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-16", "2019-07-17")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 45, 15;
Creative Somerset / Directory / Profiles / 46 to 60 of 764

Directory

Welcome to our vast directory of creative individuals, businesses, places and projects covering the local arts, cultural and creative industries across Somerset.

To add a profile, simply join our network and login to the Members area of our website. By becoming a Member and setting up a profile as well as listing content you are agreeing to our Terms of Use and Privacy Policy.

Profiles / 46 to 60 of 764

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

Antonia Myatt /  Bank Market

Antonia Myatt

Bank Market

Bank Market..Read more

Marilyn Ewens / Marilyn Ewens

Marilyn Ewens

Marilyn Ewens

Marilyn Ewens lives at the foot of the Quantock Hills from which she gets constant inspiration, landscape being her main subject matter. Her latest ex.....Read more

Melanie Deegan Sculpture / Melanie Deegan - Sculpture

Melanie Deegan Sculpture

Melanie Deegan - Sculpture

The ability to capture movement in any form of art has always interested me and this has been a strong influence in many of the sculptures I create. T.....Read more

Dot Kuzniar - Metal & Light

Artist, Blacksmith and Designer

I am a artist, ornamental blacksmith and and lighting product designer. I use my fine art background and metalworking skills to make sculptures often.....Read more

The Visual Image / Deborah Edwards - The Visual Image

The Visual Image

Deborah Edwards - The Visual Image

The Visual Image is a company delivering top quality graphic design and photography to businesses and individuals in the Southwest. We strive to g.....Read more

Carl Lewis / Graphic Designer & Musician

Carl Lewis

Graphic Designer & Musician

Graphic designer & musician... more to follow!..Read more

martyn lintern / bespoke furniture/sculpture

martyn lintern

bespoke furniture/sculpture

design and make bespoke kitchens,furniture and timber based sculpture,largely from reclaimed or locally sourced timber..Read more

MunnionArt

MunnionArt

I am a full time painter/printmaker working from my studio on the edge of the Brendon Hills, near Wiveliscombe. I sell my work at my own market stand.....Read more

Bill van den Yssel / Artist / Builder

Bill van den Yssel

Artist / Builder

I am an Artist / Film Maker / Builder. Lived and worked in Somerset for 12 years. ..Read more

Flock 92 Productions / Your Story on Film

Flock 92 Productions

Your Story on Film

Flock 92 Productions is a production company supporting South West businesses, not-for-profit, public and charitable sector through the development of.....Read more

Lucy Large/ Artist / Sculptor

Lucy Large/ Artist

Sculptor

I am a sculptor living and working in West Somerset. I graduated from Camberwell College of Art in London in 2001. Current work includes wire mesh sc.....Read more

Esplanade Club / The Esplanade Club Watchet

Esplanade Club

The Esplanade Club Watchet

The Esplanade Club is Watchet's live music venue with live music every weekend and sometimes during the week. We now have a new dance floor and stage .....Read more

Courtyard Framing + Gallery / Giclee Printing

Courtyard Framing + Gallery

Giclee Printing

Courtyard Framing & Gallery, Minehead was established in 1988 by Will Rayner – a Commended Framer with the Fine Art Trade Guild - who still runs the .....Read more

Inky Design / Graphic Design, Web Design and Print

Inky Design

Graphic Design, Web Design and Print

A partnership Graphic Design company, run by graduates of Graphic Design and Fine Art, Ally Roe and Jo Taphouse. Based in Minehead, West Somerset, we .....Read more

Churchgate Gallery / Contempory Art

Churchgate Gallery

Contempory Art

Churchgate Gallery, is curated by Will Rayner and Rachael White.It is situated right next to the church in the centre of Porlock. This spacious gal.....Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 11 / / 16 / / 21 / / 26 / / 31 / / 41 / / 51 /