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-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`=2 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 (14) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
Creative Network / knowledge hub / News / Performing Arts / 1 to 26 of 26 https://www.creativetorbay.com/news/?disc%5B0%5D=14&view=rss Don Juan makes fleeting visit to Holmfirth! Thu, 11 Jul 2019 00:00:00 +0100 https://creativekirklees.com/access-north/don-juan-makes-fleeting-visit-to-holmfirth/ As a company, Access North actively supports culture and the arts as part of our CSR programme. Business development director, Daniel Northcott has a ... Get Read for The HIDDEN VICTORIAN MUSLIMS Thu, 27 Jun 2019 00:00:00 +0100 https://creativekirklees.com/chris-longden/booksready/ What's All This ... About These Victorian Muslims? My two new books are nearly ready! A historical biography PLUS a work of creative fiction abo... New Creatives Wed, 22 May 2019 00:00:00 +0100 https://creativetorbay.com/callingtheshots/new-creatives/ New Creatives is an exciting talent development scheme that offers commissioning opportunities for emerging artists to create new work in film, audio ... Ebb tide- a collection of three duets for clarinet and bassoon Wed, 19 Sep 2018 00:00:00 +0100 https://creativetorbay.com/mark-whitefield/https-fortonmusic-co-uk-product-ebb-tide/ Ebbtide is a collection of three duets for clarinet and bassoon which explores the symbolism of an ever-changing coastline as a metaphor for half-forg... Dance Artist Call Out | Reckless Sleepers 'Take a Seat' Tue, 02 Apr 2019 00:00:00 +0100 https://creativetorbay.com/danceindevon/dance-artist-call-out-reckless-sleepers-take-a-seat/ Call out for dance artist residency with Reckless Sleepers May/June 2019 A collaboration between Reckless Sleepers, Dance in Devon and you? We ar... Performance and Micro Commission Opportunity Thu, 25 Oct 2018 00:00:00 +0100 https://creativetorbay.com/danceindevon/performance-and-micro-commission-opportunity/ Performance Opportunity Dance in Devon is delighted to invite Devon dance artists to apply to take part in our seventh edition of Watch This Space. E... U.Dance SW Regional Platform Thu, 25 Oct 2018 00:00:00 +0100 https://creativetorbay.com/danceindevon/u-dance-regional-platform/ Dance in Devon is excited to announce that we will be hosting the U.Dance 2019 Regional Platform for the South West at Dartington on Sunday 14th April... Dance and Fitness classes Sun, 18 Nov 2018 00:00:00 +0000 https://creativetorbay.com/eadance/https-elizabethannedance-wordpress-com-classes-and-workshops/ Elizabeth is running taster classes at Pyramid Studios in Torquay starting on the 25th of November to create interest in regular weekly classes Th... Three Women. One War. And a Ton of TNT Mon, 15 Oct 2018 00:00:00 +0100 https://creativetorbay.com/the-beehive/the-beehive/ Celebrate and commemorate the lives of Britain's unsung war heroes; The Canary Girls at The Beehive in Honiton on Friday 9 Nov 2018 at 7:30pm. Meet... Centre of excellence initiative to pilot in Yorkshire Thu, 04 Oct 2018 00:00:00 +0100 https://creativekirklees.com/creative-kirklees/centre-of-excellence-initiative-to-pilot-in-yorkshire/ A ground-breaking initiative to establish a network of centres of excellence for film and television in the nations and regions will be piloted in Yor... Cleckheaton Announces Artist Line-up Tue, 08 Jan 2019 00:00:00 +0000 https://creativekirklees.com/cleckheaton-folk-festival/cleckheaton-announces-artist-line-up/ Following our recent successful Advent Calendar Artist announcements we are pleased to list our artists on our website. The list includes Jon Boden & ... Marshfest 2018 ...latest news Thu, 26 Jul 2018 00:00:00 +0100 https://creativekirklees.com/marshfest2019/marshfest-2018-latest-news/ So you fancy trying a family festival? Marshfest fits the bill at only a fiver a ticket and kids go free! There are hundreds if not thousands of f... Marshfest 2018 PRIZE DRAW! Fri, 03 Aug 2018 00:00:00 +0100 https://creativekirklees.com/marshfest2019/marshfest-2018-prize-draw/ The Marshfest PRIZE DRAW is running on Facebook. Please Like AND Share the post to be in with a chance of winning. https://www.facebook.com/marshf... Line-Up and times for Marshfest 2018 Wed, 15 Aug 2018 00:00:00 +0100 https://creativekirklees.com/marshfest2019/line-up-and-times-for-marshfest-2018/ See poster for times of bands performing at Marshfest 2018 Dewsbury Lunchtime Concerts are back with Bite-Sized G&S Sun, 09 Sep 2018 00:00:00 +0100 https://creativekirklees.com/kirklees-concert-season/dewsbury-lunchtime-concerts-are-back-with-bite-sized-g-s/ Jeremy Peaker (Chorus of Opera North and formerly D’Oyly Carte) returns to Dewsbury Town Hall for the third year running to open the Lunchtime Chamber... Huddersfield premiere for Opera North's Armistice commemoration Mon, 05 Nov 2018 00:00:00 +0000 https://creativekirklees.com/kirklees-concert-season/songs-of-war/ Opera North’s Orchestra, Youth Chorus, Young Voices and Children’s Chorus are preparing to join forces for the premiere of a specially commissioned wo... Creative & Commerce Thu, 11 Apr 2019 00:00:00 +0100 https://creativedoncaster.com/emmagullon/creative-commerce/ So pleased I can now reveal I'm hosting my first ever networking event! Creative and Commerce is an opputunity for artistic businesses to mix and... ‘I love screaming on the mic’: On the road with hcmf// radio Tue, 19 Mar 2019 00:00:00 +0000 https://creativekirklees.com/hcmf/hcmfvanradio/ It seemed like a hair-brained idea: taking a 45-year-old Classic Campervan called Betsy and turning it into a mobile radio, one that would tour Kirkle... Plan a Fun Palaces event in 2019 Fri, 26 Apr 2019 00:00:00 +0100 https://creativedoncaster.com/doncaster-art-gallery/plan-a-fun-palaces-event-in-2019/ Fun Palaces - a campaign celebrating community at the heart of Culture - will see a weekend of creative action (created by, for and with local people... ALICE’S ADVENTURES IN WONDERLAND Thu, 09 Aug 2018 00:00:00 +0100 https://creativekirklees.com/oakwell-hall/alice-s-adventures-in-wonderland/ ALICE’S ADVENTURES IN WONDERLAND A Chapterhouse Theatre presentation in the walled gardens Oakwell Hall, Nova Lane, Birstall WF17 9LG, tel: 01924 32... Your chance to perform in stories of Hope Bank Pleasure Grounds Mon, 03 Sep 2018 00:00:00 +0100 https://creativekirklees.com/holme-valley-sharing-memories/158-dunford-road/ Would you like the opportunity to take part in a short performance as part of Honley Feast on Saturday 22nd September? Local arts organisations, Ho... Poetry at the Pudding Stop 6/3/19 Sat, 23 Feb 2019 00:00:00 +0000 https://creativehertfordshire.com/simon-cockle/poetry-at-the-pudding-stop-6-3-19/ I'll be reading (along with several other Ver poets) at the Pudding Stop in St. Albans on Wednesday 6th March. Come along and eat pudding/listen to p... The Flint Street Nativity Mon, 24 Sep 2018 00:00:00 +0100 https://creativekirklees.com/huddersfield-thespians-1/the-flint-street-nativity/ From the author of Calendar Girls and The Band comes a play of festive cheer and humour. The second play of our Season is The Flint Street Nativity by... The History Boys by Alan Bennett Mon, 24 Sep 2018 00:00:00 +0100 https://creativekirklees.com/huddersfield-thespians-1/huddersfieldthespians-co-uk/ The first play of the new Season is Alan Bennett's much acclaimed The History Boys. This will be performed in the Lawrence Batley Theatre (LBT) from T... Unrivaled acting classes available for teens in Hertfordshire as Tue, 22 Jan 2019 00:00:00 +0000 https://creativehertfordshire.com/master-craft/unrivaled-acting-classes-available-for-teens-in-hertfordshire-as/ Master-Craft Theatre school courses, based at The Elstree UTC, aims to provide high quality professional actor training for young people aged 14 to 21... Opportunities to engage with local secondary schools Thu, 10 Jan 2019 00:00:00 +0000 https://creativehertfordshire.com/sarah-bennett/opportunities-to-engage-with-local-secondary-schools/ Would you, or your business, like to work with a secondary school in Hertfordshire to enable its students to make better informed decisions about futu...