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(IF(CHAR_LENGTH(`media`.`mediaText`)>150, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 150), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>150, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 150), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")) AS `desc`,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("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-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-26", DATEDIFF(`media`.`mediaCreated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-26", DATEDIFF(`media`.`mediaUpdated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-26", DATEDIFF(`userLastUpdate`, "2019-06-26"), DATEDIFF("2019-06-26", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-26", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-26"), DATEDIFF("2019-06-26", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `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`=3 AND DATE_FORMAT(`media`.`mediaDate`, '%Y%m') = 201911 GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
Creative Network / events / Events / November 2019 / 1 to 35 of 35 What's on in South Devon - Arts Events and all sorts of Stuff! The Carpenters Experience Fri, 15 Nov 2019 00:00:00 +0000 The Carpenters Experience present a fantastic tribute to Richard & Karen Carpenter, capturing all the mannerisms and vocal similarities in this unique... Dick Whittington - Adult Pantomime Fri, 22 Nov 2019 00:00:00 +0000 The production will feature a hilarious cast of five principal performers (all with extensive previous pantomime experience and credits to their name)... The Elvis Years Thu, 07 Nov 2019 00:00:00 +0000 The Elvis Years is an outstanding musical production which brings to the stage the incredible and compelling story of the ‘king of rock and roll’ - El... Roy Hemmings Hits of Motown & Philadelphia Fri, 29 Nov 2019 00:00:00 +0000 Original Drifters member Roy G Hemming’s brings together the sound of three of America’s iconic Labels Motown, the Sound of Philadelphia and Stax Atla... Ed Gamble Blizzard Extension Sat, 02 Nov 2019 00:00:00 +0000 After a sellout national tour in Spring 2019, Ed Gamble’s tour has been extended. Live at The Apollo (BBC2) Off of Mock the Week (BBC2), The Russell H... Willow Basketmaking for Beginners Sat, 09 Nov 2019 00:00:00 +0000 Tutor- Paul Tuck or Jonathan Coate. This workshop will teach you the basic techniques to create a simple round basket, which you can take home at t... Ben Elton Sat, 16 Nov 2019 00:00:00 +0000 More than 30 years ago, Ben Elton exploded into the national consciousness hosting Channel 4’s ground breaking Saturday Live. Now, after a 15 year abs... Fastlove Thu, 21 Nov 2019 00:00:00 +0000 Direct from London’s West End and returning to Watford Colosseum for 2019, Fastlove is the world’s favourite George Michael tribute show. Get ready... The Magic of Motown 2019 Wed, 27 Nov 2019 00:00:00 +0000 Music fans are invited to the biggest party of the year as the unstoppable Magic of Motown show steams into town! Seen by over a million people, it's ... Jools Holland And His Rhythm and Blues Orchestra Fri, 08 Nov 2019 00:00:00 +0000 Musical virtuoso Jools Holland and his distinguished Rhythm & Blues Orchestra have announced dates and special guests for their well-renowned autumn/w... Ben Fogle - Tales From The Wilderness Sun, 10 Nov 2019 00:00:00 +0000 Thrilling tales from a modern day explorer. From crossing Antarctica to conquering Everest, Ben will take the audience on an inspiring adventure. ... Stewart Francis: Into the Punset Fri, 22 Nov 2019 00:00:00 +0000 The star of ‘Mock the Week’, ‘Live at the Apollo’ and ‘Crackerjack’ embarks on a brand-new show, in this, his last tour EVER!!! See him before he head... Luther Fri, 29 Nov 2019 00:00:00 +0000 Luther is the world’s premier show in celebration of The Velvet Voice. Experience all the hits from Luther Vandross's amazing career, culminating over... Forbidden Nights Fri, 15 Nov 2019 00:00:00 +0000 Forbidden Nights is a full production male variety show combining superlative circus and acrobatic skills with finely honed physiques. This unrivalled... Frank Skinner: Showbiz Sun, 17 Nov 2019 00:00:00 +0000 Frank Skinner: Showbiz An unmissable opportunity to see comic legend Frank Skinner perform brand new stand-up in an intimate space. ‘Provocative... OMD 40 years - Greatest Hits Wed, 13 Nov 2019 00:00:00 +0000 Orchestral Manoeuvres In The Dark continue their 40th anniversary celebrations with the announcement of a special world tour. The band were formed ... Watford Philharmonic Society: A Box Of Delights Sun, 03 Nov 2019 00:00:00 +0000 Michael Cayton conducts Watford Philharmonic Choir and Orchestra in Faure: Cantique de Jean Racine, Puccini: Messe Di Gloria and together with talente... An Evening with Jimmy White Sat, 09 Nov 2019 00:00:00 +0000 Join BBC Radio journalist Alex Belfield in conversation with one of the most colourful characters, not just in snooker, but in the whole world of spor... The Ronnie Scott’s All Stars Wed, 20 Nov 2019 00:00:00 +0000 In this, the 60th Anniversary of one of the world’s most iconic music venues, the Ronnie Scott’s All Stars take to the road to celebrate the ‘Ronnie S... Free A Cappella Choral Concert in Dunster Sun, 17 Nov 2019 00:00:00 +0000 A concert of choral singing with an Advent theme, singing Sacred Music including Christmas Motets and Advent Music, performed by the choir from the Ya... Lunchtime Talks with Tricia Thompson Thu, 28 Nov 2019 00:00:00 +0000 HE'S BEHIND YOU!: A HISTORY OF THE PANTOMIME The Pantomime, a bizarre medley of fairy story, dance, jokes, songs and cross dressing, whether it's a... Ed Byrne: If I'm Honest Thu, 21 Nov 2019 00:00:00 +0000 Join Ed as he takes a long hard look at himself and tries to decide if he has ANY traits that are worth passing on to his children. Ed Byrne presen... Bassoon, Oboe and Harpsichord Wed, 13 Nov 2019 00:00:00 +0000 Opera North Wind Principals Richard Hewitt and Adam Mackenzie make a welcome return to the season, joined by Catherine Lowe, also from Opera North's W... Orchestra of Opera North: Bluebeard's Castle Thu, 28 Nov 2019 00:00:00 +0000 Colossal orchestral scores and sensational vocals will make this an unforgettable concert performance. THE MUSIC… Towering fanfares sandwich J... Organ Concert: Gordon Stewart - 4 November Mon, 04 Nov 2019 00:00:00 +0000 This programme includes music from France, Germany, Austria and America. The final piece is Leo Sowerby's pedal showpiece which was premiered by the I... Organ Concert: Gordon Stewart - 11 November Mon, 11 Nov 2019 00:00:00 +0000 A bird theme flutters through the first half of the concert. The opening piece may be familiar for those who remember BBC's Going for a Song. Rare del... Acrylic Painting Workshop for Beginners Sun, 24 Nov 2019 00:00:00 +0000 Acrylic Painting Workshop for Beginners Subject matter - Carnival cat - Sunday 24th November 10.30am - 3.30pm Learn how to paint with acryli... Festive Lino Printing Workshop at Holmfirth Tech, 13/11/19 7-9 Wed, 13 Nov 2019 00:00:00 +0000 This workshop is perfect for anyone who likes drawing and print making. Get a head start on your Christmas cards and design your own! Lino has a reall... Poured Candles Workshop at Holmfirth Tech, 20/11/19 7-9 Wed, 20 Nov 2019 00:00:00 +0000 Create your own poured candles using all natural soy wax, essential oils and scents, decoration, jam jars, vintage tea cups and more. You'll learn how... Denby Dale Ladies' Choir, Christmas Lights Switch-on Sat, 30 Nov 2019 00:00:00 +0000 Denby Dale Ladies' Choir will be performing a medley of carols and seasonal pieces outside the White Hart Pub, during the Denby Dale Christmas lights ... Peasant Pastimes? The Art of Pieter Bruegel the Elder Thu, 21 Nov 2019 00:00:00 +0000 Lecture by Sophie Oosterwijk at 7.30pm. (Doors open 7.00pm) The year 2019 marks 450 years since the death of Pieter Bruegel the Elder in 1569. This F... Britten & Mozart Fri, 01 Nov 2019 00:00:00 +0000 We open our 2019 / 2020 season with what some would describe as Mozart's greatest work - Mozart C Minor Mass and follow it with Britten's dramatic St ... A Cappella Choral Singing Weekend Fri, 15 Nov 2019 00:00:00 +0000 A choral singing weekend with a Christmas theme, led by Ian Chesworth who has tutored our choral workshops for over 12 years.Ian has many years of exp... hcmf// 2019 Fri, 15 Nov 2019 00:00:00 +0000 The UK’s largest international festival of new and experimental music will return for its 42nd year, running from Friday 15 - Sunday 24 November 2019.... Sands Road Framing Shop/Gallery Features Sarah Woolfenden In Nov Fri, 01 Nov 2019 00:00:00 +0000 Fine Detailed Pen Drawings