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%5B0%5D=8&page=8") 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-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.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`.`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 (8) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 105, 15;
Creative Torbay / directory / Profiles / Creative Organisations / 106 to 120 of 813

directory

Profiles / Creative Organisations / 106 to 120 of 813

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

Paignton Community College Drama

Paignton Community & Sports College

The Creative & Expressive Arts Faculty are coordinating Performing Arts projects in Torbay. From Drama workshops for Gifted and Talented students at Torbay schools, to Roadshow performances touring the Primary Schools an.....Read more

Torbay Youth Theatre Group

Tytg

Torbay Youth Theatre Group (TYTG)..Read more

Flashing Blades Sword Dancers

The Flashing Blades sword dancers

Available for medieval, renaissance and fantasy fayres across Britain and the European Union, as well as carnivals, fetes, cabaret, and any other event where you may desire our appearance. Reasonable and negotiable rate.....Read more

Tribe Of Mog

Sadie Shrub

Sadie Shrub (from artist collective Tribe Of Mog), self-employed Environmental Artist and Educator, working in various natural and recycled mediums to create sculpture, crafts, performance work as well as education throu.....Read more

T.R.A.I.L.2009

Trail Recycled Art In Landscape

T.R.A.I.L. is an Artists led organisation exploring the themes of recycling and the environment through an annual gallery exhibition and sculpture trail (with sculptures made from materials destined for landfill sites )i.....Read more

Amanda Buckley

Independent Film Producer

Hi, I'm Amanda Buckley and based here in the South West in Plymouth. I've been an independent film producer for 4 years now, and currently studying for a BA in Film Art at Plymouth College of Art. As well as making short.....Read more

Madeleine Vose

Event Creation, Training and Management.

Madeleine Vose was the founder and Artistic Director of Devon's only pub theatre - Theatre Upstairs at the Globe - until February 2009 when she ceased the event to concentrate on new projects. Madeleine is now Artistic D.....Read more

Maria Selley / Lulahbubb Photography

Maria Selley

Lulahbubb Photography

A portfolio of my favourite images, which i have worked hard for over the last few Years,with enthusiasm and encouragement from Family and Friends, I wait for the weekends to come around so i can go out and enjoy the s.....Read more

Claire Honey

Creative Agent - Real Ideas Organisation

We are a pioneering social enterprise which helps young people around the world realise their potential and make change happen. We work with a wide range of clients, from government departments and local authorities to p.....Read more

Ian Blackwell - consultant / Red Hen Consultancy

Ian Blackwell - consultant

Red Hen Consultancy

Experienced consultancy working in the environment, education, heritage, arts and cultural sectors, mainly in the South West but also nationally. We focus on strategic planning, project management, organisational change,.....Read more

Plymouth College of Art / Plymouth College of Art

Plymouth College of Art

Plymouth College of Art

Plymouth College of Art is a specialist independent Higher Education Institution (HEI) run by artists for artists. Founded in 1856, the college, which is a Founding Associate of Tate Exchange, offers a range of Under.....Read more

Promenade Promotions / Promenade Promotions

Promenade Promotions

Promenade Promotions

Welcome to Prom Prom! Prom-Prom specialises in developing British popular entertainment with acts, projects, workshops, consultancy and research. Whether you are interested in booking an act, commissioning a projec.....Read more

Torbay Guild of Artists / Torbay Guild of Artists

Torbay Guild of Artists

Torbay Guild of Artists

Torbay Guild of Artists is an organisation for artists. It is based in Torbay but members are accepted from other areas of Devon. Our members comprise of both professional and amateur Artists. We also have sculptors.....Read more

Found Space

Found Space

Found Space works with unconventional exhibition venues and artists who want to show in them. Our current project HEIST, developed as a response to the visit of British Art Show 7 to the South West, culminates in an e.....Read more

Play Torbay

Play Torbay

Play Torbay is an incorporated charity launching on 7 October 2010. Our aim is to improve the quality and quantity of play provision for children and young people living in Torbay and raise awareness about the importance.....Read more

/ 1 / 2 / / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / 12 / / 15 / / 55 /