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`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `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`=9 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-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-18", DATEDIFF(`media`.`mediaCreated`, "2019-07-18"), DATEDIFF("2019-07-18", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-18", DATEDIFF(`media`.`mediaUpdated`, "2019-07-18"), DATEDIFF("2019-07-18", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-18", DATEDIFF(`userLastUpdate`, "2019-07-18"), DATEDIFF("2019-07-18", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-18", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-18"), DATEDIFF("2019-07-18", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `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(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=9 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`.`mediaApproved`=1 AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=9 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=1 AND IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*t" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (20) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 50;
Directory of artists and creative organisation in Kirklees / Profiles / Film and Video / T / 1 to 24 of 24 https://www.creativekirklees.com/directory/?disc%5B0%5D=20&letter=t&view=rss Creative Kirklees has an extensive directory of artists, creative organisations and places. Take a look at who’s working locally in Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas. Take One Productions (UK) Ltd / Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/take-one-productions-uk-ltd/ Established in 1996, Take One Productions are one of the leading creative video and multimedia production companies in London and the South East - providing clients a reliable and cost-effective option when looking for v... The Alban Arena / Hertfordshire's Premier Entertainment Venue Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/the-alban-arena/ The Alban Arena is a well established entertainment venue with a busy programme of National Touring Shows, Rock and Pop Concerts, Comedy, Films, Exhibitions and the region’s most popular Christmas Pantomime. Civic Cen... The Amity Cinema / Film Screenings Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/the-amity-cinema/ Based at the Holmfirth Civic Hall, The Amity Cinema holds monthly screenings of films from every genre and decade. For more information visit www.facebook.com\theamitycinema The Beehive / Arts and Community Centre Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/the-beehive/ A purpose built venue with a 300 seat auditorium for music, theatre, comedy, dance and cinema and space for community activities, exhibitions and workshops in Honiton with regular dance and arts and craft sessions, films... The Capitol / The Capitol Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/the-capitol/ Theatre and Cinema The Creative Herts Show / The Creative Herts Show Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/the-creative-herts-show/ Creative Herts is a YouTube video series and social media network for Hertfordshire creatives. Writers, artists, performers, musicians, photographers, copywriters, designers, marketing, PR – whatever your creative dis... The Haphazard Organization / The Haphazard Organization Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/the-haphazard-organization/ I'm a local filmmaker making low budget, but professional short films. Our next project is Host Familie. It deals with a German undergraduate who comes to stay with a Torquay family, with darkly comic consequences. This ... THE RUNNER MOVIE / THE RUNNER MOVIE Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/therunnerfilm/ The Runner came about when director John Tomkins saw a production of Individual Theatres’ The Tempest in the spring of 2014. After the show, John met with the lead actor, Ben Gilbert, to discuss showreel material. John ... The South Devon Players / The South Devon Players Theatre & Film Company Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/the-south-devon-players/ We are an award winning, family-friendly, theatre and film company, from the beautiful fishing port of Brixham; Devon (in South West England). We perform theatre shows in Brixham, around Torbay, and South Devon, based on... The South Hams Arts Collective / The South Hams Arts Collective Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/the-south-hams-arts-collective/ WHO ARE WE? A collective of professional theatre makers which include actors, directors, musicians, writers & dancers who are working in the arts. We work together to create and stimulate artistic experiences for young p... Theatre Melange / professional arts organisation Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/theatre-melange/ Theatre Mélange create participatory events & performances designed for specific places or to tour nationally in the UK and abroad. Our latest venture, Out of the Mouth of the Parrett, is a partnership with Somerset ... Theatreink / About Us Mon, 30 Nov -001 00:00:00 +0000 https://swindondoesarts.co.uk/theatreink/ Theatre Ink formed January 2008 in Swindon, the conception of a local thespian with passion and experience in producing, directing and acting in both local and professional drama organisations.   Theatre Ink aims to b... Think About It Films / creative & strategic short films Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/think-about-it-films/ Creative & strategically driven short films for the business, statutory & voluntary sectors. Clients include NHS, Clements of Watford, St Albans District & Watford Borough Councils, Hertfordshire Community Foundation and... TIGER MONKEY UK LTD / DIRECTOR EMMA GHAFUR Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/tiger-monkey-uk-ltd/ Tiger Monkey UK Limited is based in Enfield North London and specialises in mixed media arts programmes and training with children and young people aged 5-25 years and the adults who work with them. Tiger Monkey is arts... tilby / artist and production designer Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/tilby/ in mixed media on a wide variety of projects both small and large - film, opera and theatre productions as a costume and set designer. Past projects include Spitting Image, Julian Clary, Father Ted and opera for Cove... Toby Ellis Music / Music Composer Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/toby-ellis-music/ Epic, Emotive and Immersive Audio for Film, TV & Games. Aiming to provide you with unique music for your projects. Toby comes from a background of drumming from the age of 11, instantly falling for the art and going ... tobz / Toby (events) Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/tobz/ mock the buzzcocks. 10th July Collaton st mary. (collaton parish hall) First show: 6.00pm - 7.00pm second show: 8.00pm- 9.00pm To purchase tickets: email: Tobymartin11@hotmail.co.uk or search 'toby martin' on bebo, fa... Tony FullCircle / Film Maker Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/tony-fullcircle/ I am a freelance videographer/film maker. I currently run FullCIrcleTV a video production company producing online videos for business and individuals to use. I have a passion for film and I am looking to connect with cr... Torbay Film Club / Torbay Film Club Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/torbayfilmclub/ Torbay Film Club is a not-for-profit group run by volunteers who are passionate about film and want to see the finest independent and world cinema in Torbay. Films are shown on a monthly basis and are open to members ... Torbay Youth Offending Service / Torbay YOT Art Project - Encouraging young people to be creative Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/torbay-youth-offending-service/ We are a multi agency team who work with young people aged between 10-17 who offend and are made the subject of a court order. Holistic risk led programmes of support aim to tackle young people's offending behaviour and ... TouchPoint productions / Phoenix Performing Arts Trust Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/touchpoint/ TouchPoint's vision is to create and perform quality, original, relevant and redemptive productions, impacting society and culture by the powerful media of theatre, physical theatre and narrative film. ​ Serving the co... Tracey McEachran / Fine Art Photographer Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/tracey-mceachran/ Tracey McEachran is a multi-media artist and artist educator working with large format photography, film, sound and installations. Her practice broadly sits within the genre of portraiture and still life, employing c... Tracy Lawrence / Project Manager Mon, 16 Jun 2008 00:00:00 +0100 https://creativetorbay.com/tracy-lawrence/ I am a senior project manager at Smoothe. Smoothe is a creative agency that provides a complete range of design disciplines spanning graphics, identity, architecture, film and imagery. Smoothe has several design teams co... Trio Of Men / TRIO of MEN Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/trio-of-men/ Trio of Men (Hugh Nankivell, Steve Sowden, Ben Ballard) create music-based projects & performances which utilise theatre, projected video and narrative. They are dedicated to making innovative work which imaginatively an...