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%5B%5D=45") 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/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`=7 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=3 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")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (45) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / Events / Events / Visual Arts / Upcoming / 1 to 15 of 89

Events

Find out about arts, cultural and creative events across Hertfordshire.

To find events near you, select map view from the left hand menu and enter your postcode. Events are regularly featured in the newsletter and via our social media channels which reach thousands of local individuals and businesses.

To add an event, join our network and login to your Member profile, alternatively refer to our User Guides. .

Events / Visual Arts / Upcoming / 1 to 15 of 89

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

Out of Hours: 'Sedibeng, it comes with the rain' and 'Iris'.

Thu 22 Aug 2019

Out of Hours: 'Sedibeng, it comes with the rain' and 'Iris'.

Thanks to our special relationship with Towner, we are pleased to be able to enjoy an exclusive out of hours viewing of Towner’s current exhibitions, Dineo Seshee Bopape: Sedibeng, it comes with the rain and Phoebe Unwin.....Read more

Vessel, Sophie Hulf

Fri 02 to Sun 25 Aug 2019 (3 weeks)

Vessel, Sophie Hulf

Sophie Hulf explores biology, psychology and how these elements interact in this collection of work that spans a year in residency at the Phoenix. We are all a body with a voice inside. It is the matter that connects us,.....Read more

He may kill me: Robert Meldrum Paintings & Installation

Sat 10 Aug to Sun 08 Sep 2019 (1 month)

He may kill me: Robert Meldrum Paintings & Installation

Influences from Neo Dada and Modernism are rearranged in an art practice that is mostly very playful but also on occasion almost cynical. With references to outer space, Chess and a strained relationship to nature, it fo.....Read more

Chroma City

Thu 08 Aug to Sun 15 Sep 2019 (1 month)

Chroma City

Paintings by Debbie Ayles Ceramics by Michele Connell Debbie Ayles presents a painterly exploration of the myriad patterns found in architectural landscapes. Her paintings include all the shadows, reflections, sunbur.....Read more

Lewes Artwave: Venue 49 Jevington Open Studios

Sat 17 Aug to Sun 01 Sep 2019 (2 weeks)

Lewes Artwave: Venue 49 Jevington Open Studios

An exhibition featuring the work of the Artists:- Charlotte Matthews - Printmaker Ian O'Halloran - Printmaker Ian Seccombe - Printmaker and Photographer Work inspired by the landscape and the natural world.....Read more

Changing Skies: Alexander James Gordon

Thu 25 Jul to Fri 30 Aug 2019 (1 month)

Changing Skies: Alexander James Gordon

Changing Skies - abstract landscape paintings 25th July - 30th August 2019 Open Monday - Friday 10am - 4pm Free entry Based in North London, Alexander creates paintings that depict abstract landscapes, using oils a.....Read more

Wednesdays at Phoenix : Art Quiz

Wed 04 Sep 2019

Wednesdays at Phoenix : Art Quiz

A quiz night for the creatively curious. Test your knowledge on all things arts related among fellow art enthusiasts. A casual head - to- head like no other in the heart of the city’s largest creative hub. Open to all (e.....Read more

MARSWORTH FLOWER FESTIVAL AND OPEN PRINT STUDIO

Sat 24 to Mon 26 Aug 2019 (3 days)

MARSWORTH FLOWER FESTIVAL AND OPEN PRINT STUDIO

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

Coastal Currents

Sat 31 Aug to Sun 08 Sep 2019 (1 week)

Coastal Currents

Ian O'Halloran Open Studio An exhibition of work exploring the mystery of the landscape & natural world represented through the medium of printmaking. Artists:- Ian O'Halloran and Charlotte Matthews Opening times: .....Read more

LISTEN

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

LISTEN

Black Swan Arts is hosting an ambitious programme of beautiful and intriguing art that is inspired by and uses sound in many forms. LISTEN will take place in and around Black Swan Arts and in other public and private s.....Read more

Gaye Daniels Art (HVA Open Studios)

Mon 09 to Fri 27 Sep 2019 (3 weeks)

Gaye Daniels Art (HVA Open Studios)

Gaye Daniels Gaye Daniels Art (HVA Open Studios) 9 - 27 September 2019 As part of the annual Herts Visual Arts Open Studios programme, Artistsmeet are supporting as a host venue and are delighted to display the work.....Read more

Creative Resilience Programme

Thu 22 Aug 2019

Creative Resilience Programme

We know how difficult it is to sustain a career in the arts; especially socially engaged arts. Our approach uses evidence-based research and best practice to explore themes of Self-Awareness, Diversity and the impact of .....Read more

Gaye Daniels Art : Opening Reception and Drop-ins

Wed 11 to Mon 23 Sep 2019 (2 weeks)

Gaye Daniels Art : Opening Reception and Drop-ins

Opening Reception Wednesday 11 September 2019 6pm - 8pm You are warmly invited to join us at Artistsmeet to celebrate the opening of this colourful exhibition! Meet the artist whilst enjoying drinks and nibbles i.....Read more

Open Studios - Solo exhibition - Artistsmeet at Watersmeet

Mon 09 to Fri 27 Sep 2019 (3 weeks)

Open Studios - Solo exhibition - Artistsmeet at Watersmeet

Contemporary, abstract, Impressionistic paintings inspired by landscapes and nature. Open Studios - Solo exhibition - Artistsmeet at Watersmeet 9th to 27 September 2019 Open Monday to Friday 10am to 4pm or by appoi.....Read more

CALL FOR ARTISTS - Home

Sun 21 Jul to Sat 31 Aug 2019 (1 month)

CALL FOR ARTISTS - Home

We invite artists in all creative media to submit work for our forthcoming exhibition celebrating the theme of ‘home.’ We welcome wall-hung paintings, drawing, prints, mixed media, textiles, plus 3D work including wood, .....Read more

1 / 2 / 3 / 4 / 5 / 6 /