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`, "/")), "?disc%5B%5D=11") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=2 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-30" AND "2019-10-15", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-23", DATEDIFF(`media`.`mediaCreated`, "2019-07-23"), DATEDIFF("2019-07-23", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-30" AND "2019-10-15", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-23", DATEDIFF(`media`.`mediaUpdated`, "2019-07-23"), DATEDIFF("2019-07-23", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-30" AND "2019-10-15", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-23", DATEDIFF(`userLastUpdate`, "2019-07-23"), DATEDIFF("2019-07-23", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-30" AND "2019-10-15", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-23", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-23"), DATEDIFF("2019-07-23", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `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.960251))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.461586))+SIN(RADIANS(50.960251))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(50.960251))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.461586))+SIN(RADIANS(50.960251))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(50.960251))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.461586))+SIN(RADIANS(50.960251))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=2 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`=2 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=1 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-23", "2018-07-23") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-22", "2019-07-23")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (11) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creatives Across Sussex / Directory / Profiles / Web Design / Development / 1 to 15 of 227

Directory

A growing directory of individuals, businesses, places and projects from across the local arts, cultural and creative industries. 

To add a listing, register and log into My Space.

Profiles / Web Design / Development / 1 to 15 of 227

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

Kontrolit.net / Kontrolit

Kontrolit.net

Kontrolit

Kontrolit is an experienced web design, development and digital marketing company based in Yeovil, Somerset. Customers are supported through every stage of a new website, from planning, design and development, through to.....Read more

Union 10 Design / Branding / Web Design / Print

Union 10 Design

Branding / Web Design / Print

Union 10 Design is a full-service design agency, providing brand, digital and print services to a diverse collection of clients and brands. Our approach balances technology with creativity. By bringing craftsmanship, .....Read more

Aye Agency / webdesignhuddersfield

Aye Agency

webdesignhuddersfield

We’re a Yorkshire based branding and digital design agency that uses creative thinking to help ambitious businesses, who want to disrupt and make a difference...Read more

Hexydec Ltd / Web Development Agency

Hexydec Ltd

Web Development Agency

We are Hexydec Ltd, one of Devon’s most innovative and experienced Website Design and Development Agencies. We also develop a suite of web applications and frameworks to enable us to rapidly deliver high quality, well.....Read more

moretonday

Digital Content Development Manager

I work in my shed producing websites, and shoehorning words and pictures out of books and into digital formats...Read more

MILK&TWO graphic design

MILK&TWO design for print and web

MILK&TWO are a small design studio based in Torquay over looking the harbour. Sometimes we wish that we could train the seagulls to make us coffee instead of just standing at our studio window squawking nosily at us. We.....Read more

People's Republic of South Devon

arts, the environment, current affairs

• latest news: Torquay Town Hall could be the Bay's new arts centre for more read: www.peoplesrepublicofsouthdevon.co.uk The People's Republic of South Devon has been covering arts, the environment and current affairs s.....Read more

News and Media Republic

content and communcation

News and Media Republic is a content, communication and publishing social enterprise. Search engines, customers and the general public are hungry for new content, and as publishers ourselves, producing websites, print p.....Read more

B. Creative //

Graphic Designer // Visual Communicator // Print // Web //

Belinda Turner is a fully qualified Graphic & Web Designer. Currently employed as Design Manager for a South West based Design Company, specialising in bespoke gifts for commercial & retail markets. Managing a creative t.....Read more

Leah Amir / Visual Artist

Leah Amir

Visual Artist

I have always enjoyed being creative. I love to illustrate nature and in particular wildlife. I am currently working using solely pen but also enjoy a range of other media. I have a degree in Visual Studies from Plymo.....Read more

Spoton Corporation

Websites, Graphic Design, Marketing, Exhibition and Print

Based in Union Street Torquay, Spoton specialises in websites, print, design, exhibition equipment, marketing and branding. Spoton has an enviable reputation, producing marketing and promotional materials for businesses.....Read more

Deirdre Makepeace

Deirdre Makepeace

I am a freelance marketer operating out of South Devon but working for clients, around the region and beyond, on a wide range of activities from promotional campaigns to marketing strategies. Can plan and deliver busines.....Read more

Lee Ward

1

1..Read more

Jana Sebastian / Web Design and Photography

Jana Sebastian

Web Design and Photography

A Website Designer based in Torquay, I work with small business and projects in Torbay, Devon, and further afield. Services to you include a custom built website, photography, ongoing SEO and promotion strategy, and opti.....Read more

Assembly Studios / Matt Fairman CEO

Assembly Studios

Matt Fairman CEO

Leads Assembly Studios: creative agency that specialises in real-estate and construction sectors; Marcomms/business strategist; Client relations; Entrepreneur; sports junkie and proud father. ..Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / / 12 / / 14 / / 16 /