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`, "/")), "") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=7 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-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-20", DATEDIFF(`media`.`mediaCreated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-20", DATEDIFF(`media`.`mediaUpdated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-20", DATEDIFF(`userLastUpdate`, "2019-08-20"), DATEDIFF("2019-08-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-20"), DATEDIFF("2019-08-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-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(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=7 AND `userElevation`>0, (`userElevation`)*`weightingSpecial`, 0))+(IF(`weightingTotalitems`>0 AND `userTotalItems`>0, ((100/0)*IF(`userTotalItems`>0, 0, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/767)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/767)*`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`=7 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=2 AND `userNetwork` IN (7) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-20", "2018-08-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-19", "2019-08-20")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / News / News / 1 to 15 of 44

News

The latest arts and creative news from members of the Creative Hertfordshire directory.

News posted on the site is regularly featured in the newsletter and our social media, which reach thousands of local individuals and businesses.

To share your news, register and log in to My Account.

News / 1 to 15 of 44

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

Small-Scale Development Programme (Arts Marketing Association)

Thu 15 Aug 2019

Small-Scale Development Programme (Arts Marketing Association)

The Small-Scale Development Programme is designed specifically for leaders of small-scale cultural organisations. You’re likely to have many competing demands on your time and this programme will support you in your .....Read more

Open Studios at Gallery@8

Thu 15 Aug 2019

Open Studios at Gallery@8

Along with 4 other artists I will be exhibiting at this shop (oppositie Waitrose). Come along to view some brilliant art, see a demonstration, or call in for a chat! Painting using Brusho Crystal Pigments, I will .....Read more

Solo exhibition at Artistsmeet @ Watersmeet, Rickmansworth

Thu 15 Aug 2019

Solo exhibition at Artistsmeet @ Watersmeet, Rickmansworth

GAYE DANIELS Art (solo exhibition) - part of Open Studios 2019 Contemporary, abstract, Impressionistic paintings inspired by landscapes and nature. 9th – 27th September 2019 Open Monday to Friday - Free entry 1.....Read more

My Story – co-production at its very best

Wed 10 Jul 2019

My Story – co-production at its very best

Funded by Arts Council England and Hertfordshire County Council Hertfordshire Libraries , YC Hertfordshire and Nysa Projects presents My Story - Aged 16+ and interested in developing artistic skills in, drama,music, pai.....Read more

OPEN STUDIO -  24th - 26th August 2019

Wed 10 Jul 2019

OPEN STUDIO - 24th - 26th August 2019

AUGUST 24 - 26TH 2019 This is the weekend that All Saints' Church, Marsworth celebrates its Flower Festival - this year the theme is 'Time for a Rhyme'. The church will be filled with over 25 stunning flower arrangem.....Read more

The Big Art Fair

Wed 10 Jul 2019

The Big Art Fair

In it's 3rd year, the Herts Visual Arts Big Art Fair is the venue to visit! I shall be putting on display a new series of work around famous icons - singers, musicians and actors and actresses - Ziggy Stardust and Harry .....Read more

Big Art Fair Preview Night: awards + Open Studios Launch

Tue 09 Jul 2019

Big Art Fair Preview Night: awards + Open Studios Launch

Join our celebration on Friday 12th July 7pm-9pm Our Friday Preview Night is our official opening and sees the launch of our 2019 Open Studios brochure, as well as Big Art Fair Sponsors Choice Award certificates. With.....Read more

Teach Music in Hertfordshire - Herts Music Service

Thu 13 Jun 2019

Teach Music in Hertfordshire - Herts Music Service

Come and use your skills! Hertfordshire Music Service want teachers to deliver one-to-one and small group lessons in our schools and music centres — could this be you? Music Graduates starting salary is £22-23,000.....Read more

LOCAL MAESTRO BOWS OUT WITH FINAL CONCERT

Thu 04 Oct 2018

LOCAL MAESTRO BOWS OUT WITH FINAL CONCERT

Thomas Loten – a major figure in Hertfordshire’s music community over the past half century – will lead his orchestra for a final concert to remember this October. This will be the final concert for the Dacorum Symph.....Read more

Watford Young Filmmakers Festival 2019 - Submissions now open!

Wed 10 Oct 2018

Watford Young Filmmakers Festival 2019 - Submissions now open!

Are you a budding director, screen actor, or have a film you want to present on Watford’s only town centre cinema screen? We are looking for young filmmakers to submit new films or existing content no older than one .....Read more

Fundraising Update

Mon 22 Oct 2018

Fundraising Update

Small Grants Small Grants uses Lottery funding to make awards of between £300 and £10,000 to not-for-profit organisations to help more people play sport. Application deadline: Ongoing https://www.sportengland.org/fun.....Read more

Watford Palace Theatre's 110th Birthday!

Mon 22 Oct 2018

Watford Palace Theatre's 110th Birthday!

To celebrate the theatre's 110th birthday, WPT have created a series of podcasts covering the past eleven decades. The third instalment is read by actor, Assad Zaman, who you might remember from 2016's Arms and the M.....Read more

Do you work with adults who are lonely or isolated?

Mon 25 Feb 2019

Do you work with adults who are lonely or isolated?

If you do, would you share some details to be part of a countywide strategy to tackle loneliness? Hertfordshire County Council is joining up examples of existing work or activities around the county that target people.....Read more

Herts Open Studios 2019 Call for Artists

Tue 16 Apr 2019

Herts Open Studios 2019 Call for Artists

PRESS RELEASE: Herts Open Studios 2019 Our annual Call for Artists and Venues is now open, with registration from 2nd April - 30th April 2019. From 7th-29th September 2019, Herts Open Studios again brings artists, .....Read more

Open Studios Deadline extended

Wed 01 May 2019

Open Studios Deadline extended

Thanks to some lovely features in our new web site, we've been able to extend our Open Studios registration deadline until Monday 6th May - please tag and share with all your arty friends - and go see our lovely new web .....Read more

1 / 2 / 3 /