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%5B0%5D=20&type=individual&page=3") AS `href`,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-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-19", DATEDIFF(`media`.`mediaCreated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-19", DATEDIFF(`media`.`mediaUpdated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-19", DATEDIFF(`userLastUpdate`, "2019-07-19"), DATEDIFF("2019-07-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-19"), DATEDIFF("2019-07-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `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 `userType`="individual" AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-19", "2018-07-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-18", "2019-07-19")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (20) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 30, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Individuals / Film and Video / 31 to 45 of 118

Directory

A directory of artists, creative organisation and places in Kirklees - covering Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas.

If you're an individual artist, producer, creative organisation, creative business or venue - set up a profile page to showcase your work to others in Kirklees and beyond.  To add a profile, register and log into My Account.

If you're looking for an individual artistcreative business or creative place in Kirklees then search the Creative Directory to find out who's working locally.

Profiles / Individuals / Film and Video / 31 to 45 of 118

Show All / A / B / C / D / E / F / G / H / I / J / K / L / M / N / O / P / Q / R / S / T / U / V / W / X / Y / Z

Robin Whenary

Cinematographer

Freelance cinematographer & graduate of the MA Cinematography course at the National Film & Television School. I grew up in the South Devon countryside, near Totnes. Please see my website for more details and exa.....Read more

tobz

Toby (events)

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.....Read more

jessjohn_artist

sea painting series

Everything creates the art, the sea, sound, smell, land and weather they all play an emphasis in creating the work and it is not about a singular component, not a singular artist, not a singular response, not a singular .....Read more

Amanda Buckley

Independent Film Producer

Hi, I'm Amanda Buckley and based here in the South West in Plymouth. I've been an independent film producer for 4 years now, and currently studying for a BA in Film Art at Plymouth College of Art. As well as making short.....Read more

Stephanie Edmonds

Makeup artist

I am a freelance Makeup artist based in Plymouth, I have a passion for art and being creative. I have worked on many photoshoots including a uk calender and theatre productions. Please contact me if you need a makeup art.....Read more

watertree

Sean M Lee Artist

LIFE..Read more

Vic Vasey

Writer

My portfoiio of film scripts, short stories, poems and songs will be updated later with more details, HOWEVER....... FREE PANTOMIME SCRIPT AVAILABLE TO LOCAL THEATRE GROUPS 'George and the Dragon' is a full 2 hour pantom.....Read more

Jane Hodgson, VJ Films/Design / Practising artist and creative promotional film maker

Jane Hodgson, VJ Films/Design

Practising artist and creative promotional film maker

I completed a BA (Hons) in Fine Art at University of Hertfordsshire in 2005, then the MA Arts and Ecology at Dartington in 2008, since then I have pursued a career as a practising artist - painting, film and photography......Read more

Shane Peterson

The Outsider Art

Composer and visual artist, based in Brixham...Read more

shadytremain

music composer

Currently studying a foundation degree in music technology at south devon college. I compose mainly dubstep at the moment, however I also compose chillout, hiphop and dance tracks from time to time. You can listen to som.....Read more

Clem So

Clem So : Tracing The Intangible

My work is an on going investigation into my Chinese identity, but also the feeling of loss, a numbness of something not quite there. I can be a person at cross-purpose with myself, a dual identity that reveals itself i.....Read more

Icarus Gray

Rorschach Productions

Hi my name is Peter Boueiri. At the moment I am a Student attending South Devon College (In the Torbay) Studying a Extended Diploma in Media Film Production (level 3) I have already done a level 2 course and studied medi.....Read more

Danny Cooke / Danny Cooke Freelance Filmmaker

Danny Cooke

Danny Cooke Freelance Filmmaker

I work as a multi-award winning freelance filmmaker, director, editor and cinematographer based in Torbay, Devon, UK. Often I see images and have ideas that I would like to share with others. This is how my films come.....Read more

Friends of Paignton Library

Friends of Paignton Library Film club

Unique, old news films of Torbay from between 1912 and 1992 have been discovered in the archives of Torbay Library Services by the Friends of Paignton Library (FoPL). These include the arrival of the railway, carnivals a.....Read more

The Haphazard Organization / The Haphazard Organization

The Haphazard Organization

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 .....Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 /