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-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-20", DATEDIFF(`media`.`mediaCreated`, "2019-06-20"), DATEDIFF("2019-06-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-20", DATEDIFF(`media`.`mediaUpdated`, "2019-06-20"), DATEDIFF("2019-06-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-20", DATEDIFF(`userLastUpdate`, "2019-06-20"), DATEDIFF("2019-06-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-03-28" AND "2019-09-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-20"), DATEDIFF("2019-06-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-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(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`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-20", IF(`media`.`mediaDate`>"2019-06-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-20", "2018-06-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-19", "2019-06-20")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (100) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
Directory of artists and creative organisation in Kirklees / Profiles / TV and Radio / 1 to 18 of 18 https://www.creativekirklees.com/directory/?disc%5B0%5D=100&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. Nova Productions / The Outdoor Production People Mon, 30 Nov -001 00:00:00 +0000 https://creativedoncaster.com/novaproductions/ Yorkshire-based team passionate about making inspirational & engaging television about outdoors, heritage & transport. And tea. The team behind the TV series Walks Around Britain. Miss Tofelees ( beatmaker ) / Miss Tofelees Hiphop Jazz Funk Producer Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/miss-tofelees-beatmaker/ BEATS / INSTRUMENTALS FOR LICENSING - HIPHOP JAZZ FUNK SPECIALIST Hailing from Huddersfield UK, Miss Tofelees started making beats after attending class at Leeds College of Music. In 2011 she launched beatmaking outfi... Toppers Theatre Group / September in the Rain Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/toppers-theatre-group/ Toppers Theatre Group is a small amateur community theatre group. We are about to start a tour of small venues in Kirklees and Calderdale. Jamie Rhodes / Writer Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/jamie-rhodes/ Jamie Rhodes WriterJamie Rhodes is a writer working in comics, prose and screen. He studied Philosophy at Manchester Metropolitan University, where he focused on Heideggarian studies and Phenomenology. He is a full membe... Stuart Packer / Storyteller | Storytelling Coach | VoiceOvers | Producer | Actor Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/stuart-packer/ Currently working on Storytelling Masterclasses for Gifted and Talented Children, disabled children and disadvantaged adults Plus my Four Letter Word workshop for SEN for KS2 and KS3 is ready to roll; four letter word ex... Somerset Film / Film and Creative Digital Media Organisation Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/somerset-film/ The Engine Room is a community media centre based in Bridgwater High Street. It is an initiative of and home to Somerset Film, a registered charity dedicated to empowering people through film and technology. The Engine R... Stannie / DJ Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/stannie/ Radio DJ & Founder member of Glastonbury FM 107.1fm 10 Radio / Radio Broadcaster, OB unit and Trainer Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/10-radio/ - STUDIO AND OUTSIDE BROADCASTING - TRAINING - EQUIPMENT HIRE - PROJECT MANAGEMENT - OPEN DOOR POLICY 10Radio was awarded an Ofcom licence 2008 as a Community Interest Company broadcasting on 105.3fm and streamin... Debbie McCarty / Jeweller Designer Maker Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/debbie-mccarty/ Debbie is a Jeweller Designer and maker who creates a beautiful range of unique one-of-a-kind jewellery pieces that are inspired by her love of foraging. They are hand crafted using recycled precious metals and felt. TheWriteDay / Amazingly productive 1-day retreat for procrastinating writers Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/thewriteday/ We are a group of procrastinating writers of all genres and abilities who get together on TheWriteDay once a month to write our socks off for the whole day. Our aim on the day is not to get it right, just to get it w... Mell / Director Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/mell-1/ Media maven and maverick interested in working on projects brining together people of varying disciplines to produce visual and audio work. Worked in media and education for over 20 years and always looking at the new wa... Josh Marriott / Actor/Director & Workshop Facilitator Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/josh-marriott/ I am a professional actor with extensive experience in the theatre and on screen. I have directed a number of pieces for the professional stage. I have created and delivered in excess of 2500 issue lead workshops in scho... Richard Addison / Writer/Lecturer/Presenter/Script Consultant Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/richard-addison/ Author of 14 published books. Written for film, TV and radio, mostly comedy. Plus cartoon strips. Trained reporter and journalist – written for the national press. Lecturer in writing film scripts and TV sitcom for v... Drawmill Animation Studio / Animation Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/drawmill-animation-studio/ We create silly cartoons for people silly enough to pay us Drawmill Animation is a UK based 2D animation studio producing professional and affordable animations. We work with traditional animation, modern 2D animation... Radio Ninesprings / Community Radio for Yeovil Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/radio-ninesprings-yeovil/ We have a studio at Yeovil College and provide media training and programme making opportunities. arrandutton / writerproducer Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/arrandutton/ I co-founded Somerset based production company Audio Factory with Dave Perry and through that I have gained series creator, writer and producer credits on two series for BBC CBeebies Radio titled 'Poppy's Play Dates' and... SDOS Recording Studios / High end recording studio services throughout Somerset & Dorset: Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/sdos-recording-studios/ SDOS provide high end studio & mobile recording services throughout Somerset and Dorset, South West UK VIDEO FOR BUSINESS / VIDEO PRODUCTION Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/video-for-business/ VIDEO FOR BUSINESS Video is the future of content marketing.* By 2017, Video will account for 69% of all internet traffic, according to Cisco. Businesses that fail to include Video in their marketing will do so at the...