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&letter=b") 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-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-21", DATEDIFF(`media`.`mediaCreated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-21", DATEDIFF(`media`.`mediaUpdated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-21", DATEDIFF(`userLastUpdate`, "2019-08-21"), DATEDIFF("2019-08-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-21"), DATEDIFF("2019-08-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `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]*b" 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, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Film and Video / B / 1 to 15 of 18

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 / B / 1 to 15 of 18

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

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

Bandini Videos / Animated Explainer Videos & Product Demonstrations

Bandini Videos

Animated Explainer Videos & Product Demonstrations

At Bandini Videos we produce stylish animated explainer videos and product demonstration videos. Our videos quickly and concisely communicate your brand and who you are. Explaining your service and benefits as wel.....Read more

Baobab Theatre / Theatre - Film - Education - Workshops

Baobab Theatre

Theatre - Film - Education - Workshops

Baobab Theatre is an independent theatre and film production company. We have worked with professional, youth and community performers to create a range of small, mid and large sale theatre productions. Our work is ensem.....Read more

BarriHitchin / Artist & Film-Maker

BarriHitchin

Artist & Film-Maker

Conservation and Wetland inspired themes...Read more

BearStoryHayley / Bear Story Theatre

BearStoryHayley

Bear Story Theatre

Actor/writer at Bear Story Theatre Company. We are a young company consisting of four University of Huddersfield Drama graduates. We strive to make theatre which is accessible, exciting and charming. We don't want to in.....Read more

Ben @ The Capture Agency

Ben Richardson

The Capture Agency is a communications agency based in St Albans that specialises in business journalism, corporate communications, documentary film-making and photography. We use journalistic techniques to help clients .....Read more

Ben Langworthy

the quiet shout is to pull at the loose threads

I am drawn to actions that are ridiculous and seemingly futile, actions that can tip the everyday off balance by using apparent and playful strategies, or simple and near invisible interventions. I often use protagonists.....Read more

Beth Dawes

Marketing Manager at Letchworth Heritage Foundation

Marketing Manager at Letchworth Garden City Heritage Foundation, promoting the town's Broadway venues - cinema, theatre, studio and gallery. Keen to link up with other arts venues in the region to share ideas!..Read more

Beverley Addy

Writer, Filmmaker, Visual Artist and Project/Events Manager

Writer, Filmmaker and Visual Artist working on my own work and working with others..Read more

biggerhouse film / Stephen Clarke

biggerhouse film

Stephen Clarke

director / producer / teacher Stephen has been living and working in Somerset for 30 years and is a co-director of the award winning biggerhouse film. biggerhouse film are passionate film makers specialising in .....Read more

Bill van den Yssel / Artist / Builder

Bill van den Yssel

Artist / Builder

I am an Artist / Film Maker / Builder. Lived and worked in Somerset for 12 years. ..Read more

Blind Ditch

Blind Ditch

Founded in 2001, Blind Ditch is a small group of artists and associates who make collaborative performance, art and cultural events. Working from our base in the South West of England, we are explorers (newcomers, settle.....Read more

Blue Walnut Cafe / Arts Cafe

Blue Walnut Cafe

Arts Cafe

A small fully licensed cafe open 6 days a week situated near the Torquay train station in the picturesque suburb of Chelston with a quiet little garden to the rear. The Blue Walnut incorporates an authentic 23 seat nicke.....Read more

Bomb Studios / Graphic and web design

Bomb Studios

Graphic and web design

BOMB is a Devon-based, international, independent print and web-design company offering a wide range of solutions from photography, copywriting and creative consultancy to complete business overhauls, analysis and image .....Read more

BowTieProductions / BowTieProductions

BowTieProductions

BowTieProductions

We are a film production company based on YouTube. We make our own short films with weekly channel updates to widen our audience to all over the world! We started through the KYEC (Kirklees Youth Enterprise Centre) in wh.....Read more

1 / 2 /