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`, "/")), "?postcode=&q=&network%255B0%255D=1&network%255B1%255D=7&network%255B2%255D=9&network%255B3%255D=5&network%255B4%255D=2&network%255B5%255D=6&view=list") 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-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-20", DATEDIFF(`media`.`mediaCreated`, "2019-07-20"), DATEDIFF("2019-07-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-20", DATEDIFF(`media`.`mediaUpdated`, "2019-07-20"), DATEDIFF("2019-07-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-20", DATEDIFF(`userLastUpdate`, "2019-07-20"), DATEDIFF("2019-07-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-20"), DATEDIFF("2019-07-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `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`=6 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-20", "2018-07-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-19", "2019-07-20")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / jobs / Opportunities / Upcoming / 1 to 15 of 52

jobs

All the latest arts jobs, commissions  and voluntary opportunities in the Arts and Cultural sector. In order to advertise a position or  opportunity you must first be registered in the directory.

Opportunities / Upcoming / 1 to 15 of 52

Upcoming / Today / Jul / Aug / Sep / Oct / Nov / Dec / Jan / Feb / Mar / Apr / May / Jun / Archive

Thu 25 Jul 2019

Big Line Drawing Open Call

Background Doncaster wants to create the biggest painted line drawing ever in Yorkshire, as part of the international Big Draw festival to coincide.....Read more

Ceramics Tutor - 1 evening per week

Wed 31 Jul 2019

Ceramics Tutor - 1 evening per week

We're seeking a tutor for one of our popular Ceramics weekly evening classes in Hertford. The role entails teaching 7.30-9.30pm each Wednesday dur.....Read more

Crowdfunding – its free money right? (webinar)

Thu 01 Aug 2019

Crowdfunding – its free money right? (webinar)

What is it about? Have you witnessed a great project get let down because the crowdfunding campaign was put online and left waiting for the money t.....Read more

Technician

Mon 29 Jul 2019

Technician

We’re a relatively small team looking for a fun, hard working technician to help make the art and presentations at PDSW as fabulous as possible. We’ll.....Read more

Casual - Duty House Manager

Sat 31 Aug 2019

Casual - Duty House Manager

We are looking to recruit an experienced Duty House Manager for our venue The Weston Auditorium and other external venues. Responsibilities will inclu.....Read more

Artist in Residence 2019

Fri 02 Aug 2019

Artist in Residence 2019

We are delighted to invite artists' applications for our annual 4-week residency at Courtyard Arts, Hertford, 17th Sep – 12th Oct 2019. *please not.....Read more

Arts Marketing Manager

Sun 22 Sep 2019

Arts Marketing Manager

We are looking for a passionate and agile marketeer with experience in the arts, culture or heritage sectors to join our small, committed creative tea.....Read more

Arts Marketing & Design Assistant

Sun 29 Sep 2019

Arts Marketing & Design Assistant

As an integral member of a small team, the Arts Marketing & Design Assistant will support marketing and communications activities across all artforms......Read more

Digital Enterprise Programme - Phase 2

Sat 31 Aug 2019

Digital Enterprise Programme - Phase 2

In September, phase two of the Digital Enterprise programme (DE 2.0) will launch, offering an enhanced programme of support for SMEs in the Leeds City.....Read more

UK Theatres Small Grants Scheme Accepting Applications

Mon 02 Sep 2019

UK Theatres Small Grants Scheme Accepting Applications

Capital-improvement grants of up to £5,000 are available to charities’ and not-for-profit groups that run theatres in the UK. Provided by the Theat.....Read more

First Call for Projects to develop Yorkshire & Humber

Tue 01 Oct 2019

First Call for Projects to develop Yorkshire & Humber

XR Stories, the new R&D partnership for the Yorkshire and Humber screen industries has announced the structure for its new research and development fu.....Read more

Creative Facilitation for Young People

Tue 24 Sep 2019

Creative Facilitation for Young People

This one-day course provides an introduction to a creative approach to group facilitation. It aims to encourage, develop and inspire those with respon.....Read more

The National Arts Fundraising School: fundraising success

Fri 01 Nov 2019

The National Arts Fundraising School: fundraising success

31 theatres on the at risk register 2019 urgently need funding. 64 museums have closed since 2010, according to research by the Museums Association – .....Read more

Music for All – Music in the Community

Wed 01 Jul 2020

Music for All – Music in the Community

Grants are available to UK based community groups that aim to bring musical projects to their local communities. The grants programme aims to give .....Read more

Let June Make A Difference, funding for North Kirklees children

Sun 18 Aug 2019

Let June Make A Difference, funding for North Kirklees children

Let June Make A Difference exists to enhance the lives of children in North Kirklees between the ages of 7 and 17. Read the information below about w.....Read more

1 / 2 / 3 / 4 /