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&page=14") 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-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-25", DATEDIFF(`media`.`mediaCreated`, "2019-06-25"), DATEDIFF("2019-06-25", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-25", DATEDIFF(`media`.`mediaUpdated`, "2019-06-25"), DATEDIFF("2019-06-25", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-25", DATEDIFF(`userLastUpdate`, "2019-06-25"), DATEDIFF("2019-06-25", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-25", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-25"), DATEDIFF("2019-06-25", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `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-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-25", "2018-06-25") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-24", "2019-06-25")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (20) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 195, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Film and Video / 196 to 210 of 299

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 / Film and Video / 196 to 210 of 299

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

Tony FullCircle / Film Maker

Tony FullCircle

Film Maker

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

Cinema Obscura / Film Society

Cinema Obscura

Film Society

Wiveliscombe based Cinema Obscura is a film society established in 2000. Independent in thinking and always seeking to screen the best and possibly most challenging films that World Cinema offers. Based at the New Hall, .....Read more

Mell

Director

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

BarriHitchin / Artist & Film-Maker

BarriHitchin

Artist & Film-Maker

Conservation and Wetland inspired themes...Read more

PlantPhoto / Simon Plant Photographic Productions

PlantPhoto

Simon Plant Photographic Productions

Simon Plant is an award-winning photographer & retoucher with over two decades of experience in the production of people & location photography. Whatever the subject his images share the same unique style and attentio.....Read more

Hawthorne Theatre

CW Entertainment

Hertfordshire's home for Film and the Dramatic Arts with two art galleries and a 361-seat theatre/cinema. Partnered with Rollercity, Hertfordshire's only purpose-built Roller rink...Read more

George / Freelance Filmmaker

George

Freelance Filmmaker

Freelance Director and Camera Operator: Four years' practical experience in the industry where I have produced content for global companies, such as Unilever, and creative content...Read more

Simon Beer / Aerial Video & Photography

Simon Beer

Aerial Video & Photography

Hertfordshire based camera operator specialising in remotely piloted aerial video / photography and hand held 3-axis camera gimbals for extremely steady video. Full permission to operate commercially in the UK granted b.....Read more

Watford Filmhouse

Watford Filmhouse

Born out of a desire to see films that are not available locally, WATFORD FILMHOUSE is a local club that aims to show a diverse range of films on a monthly basis. There is a warmth and excitement to the Filmhouse tha.....Read more

Victoria Johnstone / Theatre Designer

Victoria Johnstone

Theatre Designer

http://www.victoriajohnstone.com/..Read more

Hugh Gilbert / photographer

Hugh Gilbert

photographer

Photographer living between West Sussex and London. Specialising in photography of artists work, and the making of limited edition prints of artists work. Member of the Association of Historical and Fine Art Photogra.....Read more

StudioShedSouth / Studio Hire

StudioShedSouth

Studio Hire

LOCAL - STUDIO HIRE AVAILABLE FOR FILM & STILLS, FILM LOCATION BASE, PRESS LAUNCHES & EVENTS 1000 square feet with infinity cove Drive-in facility Fully equipped with flash and continuous lighting Suitable for vide.....Read more

Bad Chicken Productions / Film and Video Production Company

Bad Chicken Productions

Film and Video Production Company

We create niche and bespoke films for the creative industries, companies and the community. If you want to give your organisation a fresh new digital presence then you may want to consider some of our services: • Online.....Read more

kick up the arts / watford creative networking

kick up the arts

watford creative networking

Kick up the Arts is a laid back evening for Watford and nearby creatives to make new friends, drink coffee, exchange ideas, get advice. All levels welcome, pros and hobbyists: filmmakers, musicians, crafters, artists, ph.....Read more

PETE HEPPA / SOUTH DEVON COLLEGE ARTS

PETE HEPPA

SOUTH DEVON COLLEGE ARTS

I am Section Head of Creative Arts at South Devon College. We offer exciting courses for 14 to adult , in Art ,Fashion, Photography,Dance, Drama,Media and Music.We are based at Long Road Paignton...Read more

/ 1 / / 5 / / 10 / 11 / 12 / 13 / 14 / 15 / 16 / 17 / 18 / / 20 /