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`, "/")), "?view=list&page=54") AS `href`,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`=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, 15;
Creative Torbay / directory / Profiles / 1 to 15 of 4653

directory

Profiles / 1 to 15 of 4653

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

Julia / www.TheAuthorWithin.co.uk

Julia

www.TheAuthorWithin.co.uk

I want you to WRITE for the pure EXCITEMENT and ENJOYMENT of writing. I believe every story is worth telling. “Let me help you write the stories you love to write & the stories your readers love to read!” – .....Read more

HAFLS / Hertfordshire and Adult Family Learning Service

HAFLS

Hertfordshire and Adult Family Learning Service

Hertfordshire Adult and Family Learning Service is part of the Hertfordshire County Council. We are funded by the Education and Skills Funding Agency and the European Social Fund to provide learning opportunities for adu.....Read more

Doorstep Arts / Participation/Music/Theatre

Doorstep Arts

Participation/Music/Theatre

Doorstep Arts is a non-profit arts education organisation based in Torbay. We run 14 drama groups across Torbay at key doorstep sites – youth clubs, church halls and schools. We are also the creative education company in.....Read more

Christmas By The Sea / 2016

Christmas By The Sea

2016

With FREE events throughout the festive period… you can see, hear, feel and create Christmas. Starting with the Christmas Carnival on Saturday 19th November there will be activities and art throughout the town, with .....Read more

St. Mary's Church, Honley / St. Mary's Honley Organ Restoration Project

St. Mary's Church, Honley

St. Mary's Honley Organ Restoration Project

Honley's hidden heritage urgently needs your help before it is lost for ever. The 100 year old organ of St. Marys Church requires major restoration works in order to ensure its future. The organ at St. Marys was t.....Read more

VIRSA / HARDEEP SAHOTA

VIRSA

HARDEEP SAHOTA

Hardeep Singh Sahota is a leading authority on Bhangra, and has been one of the prominent forces in the UK delivering high quality Bhangra workshops, lectures and seminars over the last two decades. As a secondary school.....Read more

Brixham College Creative & Media

Brixham College Creative & Media

In Development..Read more

Devon Open Studios / Devon Open Studios

Devon Open Studios

Devon Open Studios

Devon Open Studios takes place for two weeks in early September at venues across the county. Participating artists and makers can choose to open for the whole event or selected days of their own choosing. Devon Open .....Read more

Low Carbon Workspaces / energy improvement grants

Low Carbon Workspaces

energy improvement grants

Low Carbon Workspaces offers small and medium-sized businesses in Hertfordshire grants of between £1,000 and £5,000 for making energy improvements eg. LED lighting, heating, insulation, electric vehicles & more. The prog.....Read more

Access North / about-us

Access North

about-us

Access North is a family owned business which started out in 2011 - over the last 8 years, we've grown and are now made up of two business arms: Access North Structures and Access North Build. Access North Structures .....Read more

Upcycle-Devon / Aboutus

Upcycle-Devon

Aboutus

A service catered and inspired by you Turning preloved materials and turning them into quirky, innovative pieces to be proud of. We will work with what you have to reduce, reuse and repurpose materials that would o.....Read more

Doncaster Creates

Doncaster Creates

Doncaster Creates is a program to enable more people to create and for best creation to flourish proving arts led town re-generation as a model for positive transformation and happier people. Everyone Cre-ates. Everyone.....Read more

Fret - Don't Fret / Welcome To Our World

Fret - Don't Fret

Welcome To Our World

Fret - Don't Fret is located in the centre of Doncaster and through this page, we aim to give you a feel for what we offer in our shop, and provide some useful advice and information. Here at FDF, we look forward to ge.....Read more

PURPLE VOUCHERS LTD / PUBLISHING

PURPLE VOUCHERS LTD

PUBLISHING

Purple Vouchers in an annual A6 Pocketbook crammed packed with £thousands worth of local vouchers for only £25 With every book purchased you will receive a free membership card . Register your card to unlock nation.....Read more

Charlotte Roe / Illustrator

Charlotte Roe

Illustrator

Hi, I'm an artist and illustrator based in Huddersfield. I make work concerned with ideas of technology, functionality and the future. This year I'm working on my first graphic novel 'Deadly Nostalgia' - a dystopian.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 11 / / 21 / / 61 / / 111 / / 161 / / 211 / / 261 / / 311 /