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`, "/")), "?letter=p&page=3") 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-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` 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]*p" GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 30, 15;
Creative Torbay / directory / Profiles / P / 31 to 45 of 206

directory

Profiles / P / 31 to 45 of 206

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

pat / my naive art

pat

my naive art

MY NAIVE ART if you are looking for original put well priced naïve art paintings then go to my face book like page .....Read more

Pat Fulgoni / singer, promoter, producer, musician

Pat Fulgoni

singer, promoter, producer, musician

Examiner Community Award Winner (Music & Arts), Going Global Awards (Best New Export Initiative). "Fulgoni could sing a pearl from its oyster" (Billboard) ... Pat's sung for labels incl Ram, Hospital, Subliminal (NY.....Read more

Pat Le Mare / Artist

Pat Le Mare

Artist

I am an artist based in Stevenage where I have lived for 40 years, though originally from Lancashire. I have become very involved with pastel drawing in recent years, and also do paintings in acrylics. I like to cover a .....Read more

Patricia Eyre

Recreation and Leisure Leader

Recreation and Leisure Leader at a 60 bed residential/dementia home. I am always looking for quality "acts" to entertain our residents but I am also passionate about bringing as wide a range of experiences to the resi.....Read more

Patrick Jones / Abstract Artist

Patrick Jones

Abstract Artist

Patrick Jones is one of England's foremost and respected abstract painters. His work is characterised by its colour, vibrancy and size. His survey show at the Poussin Gallery entitled 'Reprise' referred to his contin.....Read more

Patrick Joyce / Ceramics

Patrick Joyce

Ceramics

Patrick Joyce is a Hertfordshire based ceramic artist...Read more

paul

freelance architectural modelmaker

I am a Senior Architectural Modelmaker based in Bristol. I have worked in house at some of the top architectural practices in the world including Richard Rogers and Foster + Partners. I also design and make bespoke pro.....Read more

Paul

PAUL ACKERLEY, CREATIVE DIRECTOR, CREATIVES ACROSS SUSSEX

Creative Director, Creatives Across Sussex..Read more

Paul Adrian Rooke / Mr

Paul Adrian Rooke

Mr

Conductor of Hitchin Symphony Orchestra since 1984. HSO was formed by Mary Ibberson in 1929 and gives two concerts per year in St Mary's Church, Hitchin. Conductor of Stevenage Male Voice Choir since 1995. SMVC perf.....Read more

Paul Davies / Music at St John's

Paul Davies

Music at St John's

Music at St John’s is a charitable company which seeks to promote music and the performing arts within the community of Boxmoor and Hemel Hempstead. As well as promoting concerts, recitals and other musical events, incl.....Read more

Paul Dobson

Paul R Dobson - Popart & Retro Design

Torbay Artsbase Award Winner 2008 for Creative Contribution to the Community. The Award was won as a result of a very successful working partnership with Sarah Welsh from Mewstones Ltd. for coordinating "Space Invaders".....Read more

Paul Evans

Projects Officer

Countryside Management Service..Read more

Paul Graham / Photographer

Paul Graham

Photographer

Hello! I'm a photographer working out of West Yorkshire. Specialising in skateboard, studio, landscape and documentary photography. I am currently a studio holder at Creative Arts Hub, Mirfield. My day job consists o.....Read more

Paul Hayes Graphic Design

I am a graphic designer who works for a range of clients across the full business spectrum. I specialise in design and production for most print requirements (leaflets, brochures, packaging, corporate stationery and mag.....Read more

Paul hillary / Creative bod

Paul hillary

Creative bod

Lover of photography, purveyor of graphic design, obsessor and practitioner of fine art...Read more

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