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=m") 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-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`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*m" 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 / M / 1 to 15 of 23

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 / M / 1 to 15 of 23

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

Machine Media

Machine Media

A vibrant video production company based in Devon. Machine Media specialises in broadcast-quality films that can be embedded in websites, burned onto DVDs or uploaded onto social networking sites. The award-winning team .....Read more

Made By Stupid / Video, Stills, Advertising

Made By Stupid

Video, Stills, Advertising

A Brighton based creative agency with working in advertising and video/stills production. Set up by advertising industry creatives, filmmakers & photographers we make sure our content not only looks great but does th.....Read more

majdleen / creative writing

majdleen

creative writing

hi there , i am a creative writer , hope to join you and enjoy..Read more

mark / Photographer

mark

Photographer

I am a Photographer, I can do Portraits , Actors Head shots , Events and what ever else you may need, and I am also an actor under my stage name Mark Heartford...Read more

Mark Garvey / Mark Garvey

Mark Garvey

Mark Garvey

Filmmaker..Read more

Mark Whitefield / Composer

Mark Whitefield

Composer

British born composer Mark Whitefield. Is a music graduate of Dartington College of Arts England, where he obtained a BA with [hons] in music composition. He is a composer of eclectic and wide-ranging interests. With .....Read more

Maya Gordon

Creative Design & Moving Image

I am currently on my second year of Fda Creative Digital Media at South Devon College hoping to complete a third year in Media Production at Bournemouth, Hertfordshire or Plymouth to top-up my degree to a BA Hons. My mai.....Read more

MED Theatre / MED Theatre

MED Theatre

MED Theatre

MED Theatre is a community theatre organisation and registered charity based on Dartmoor, working with people in remote rural areas and throughout Devon. All of our work is inspired by the history, ecology and folklore o.....Read more

Medianity / video/photographer

Medianity

video/photographer

Medianity is a creative service for charities, non-profits, ethical and social businesses, as well as people with humanitarian goals. With experience in videography and photography, the service aims to join the movement .....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

Mew Lab / Animation

Mew Lab

Animation

Welcome to Mew Lab the collective talent of Directors Shaun Clark and Kim Noce. We are both graduates of The National Film and Television School and specialise in creating Animation content for Films, Television, exhibit.....Read more

Michael Bowerman / Embow Music

Michael Bowerman

Embow Music

Music Composition for films and professional media Michael Bowerman is a recent graduate of Music Composition from the University of Brighton. He has completed composition projects and commissions for videogames, corp.....Read more

Michael Joseph / Michael Joseph Presents...

Michael Joseph

Michael Joseph Presents...

Independent Dance Artist - Choreographer • Teacher • Dance Artist • Film Maker working in and around Hertfordshire Bedfordshire and Cambridgeshire. Since completing my training at Rambert School of Ballet & Contempo.....Read more

Mícheál Ó Rodochain

Film Maker

Film Maker/Director Theme Mental-Well Being and Art I am in need of various people for a film project over the next view months. Please have a look at the website. Thank you...Read more

Mike Edmonds

Musician

We are very sad to let all friends and musicians know that Mike died peacefully at his home on the evening of Monday 5th April. Mike had pancreatic cancer and fought this positively for some months whilst recording his a.....Read more

1 / 2 /