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%5B%5D=46") 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-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-24", DATEDIFF(`media`.`mediaCreated`, "2019-07-24"), DATEDIFF("2019-07-24", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-24", DATEDIFF(`media`.`mediaUpdated`, "2019-07-24"), DATEDIFF("2019-07-24", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-24", DATEDIFF(`userLastUpdate`, "2019-07-24"), DATEDIFF("2019-07-24", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-24", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-24"), DATEDIFF("2019-07-24", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `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-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-24", "2018-07-24") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-23", "2019-07-24")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (46) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Directory of artists and creative organisation in Kirklees / Profiles / Publishing / 1 to 15 of 116

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 / Publishing / 1 to 15 of 116

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

Rohde Creative / Graphic design and brand communication

Rohde Creative

Graphic design and brand communication

Rohde Creative Ltd is a brand communications consultancy providing a tailored and hands-on service adapted to the needs of your business. Established in 1997 Rohde Creative has serviced a wide range of clients from bot.....Read more

John Polley Brand Communications / graphic design, branding, website design and photography

John Polley Brand Communications

graphic design, branding, website design and photography

John Polley Brand Communications is a graphic design and branding studio based in Linthwaite, Huddersfield. We have many years experience creating branding, brochure, book, publishing and website work for a diverse range.....Read more

The Wandering Wordsmith / About me

The Wandering Wordsmith

About me

Born and raised on a windswept Yorkshire moor, I spent much of my childhood either reading or writing stories. My first steps into writing commercially began 15 years ago when I trained and landed a role as a newspaper j.....Read more

Obyod Press / Obyod Press

Obyod Press

Obyod Press

Thanks for reading! My name is Mark White and I am the proprietor of Obyod Press, an independent bookbinding and publishing company. The inspiration for my novels comes from my time as a Kirklees Council Noise Abatement .....Read more

Stu Nimmo

Graphic Design & Photography

Stuart Nimmo, a West Yorkshire based photographer and graphic designer. After training at Coventry Technical College and Nene College went on to gain experience as a graphic designer in the print industry. Since 2004 I h.....Read more

Karen Naylor / Festival Director, Cleckheaton Literature Festival

Karen Naylor

Festival Director, Cleckheaton Literature Festival

Writer who set up and runs the Cleckheaton Writer's Group and the Cleckheaton Literature Festival. I write several genres, short stories, novels, plays, radio plays, poetry, articles, proof read/edit and freelance. I hav.....Read more

Fletcher + Walker / Fletcher + Walker /

Fletcher + Walker

Fletcher + Walker /

Founded in 2013 Fletcher and Walker formerly Studio Disjointed is the focus of research and graphic design for print from the work of Rob Walker...Read more

D&M Heritage / Design, Publish, Print

D&M Heritage

Design, Publish, Print

Award-winning printer, publisher and bookbinder D&M Heritage is one of the UK’s leading heritage publishing, printing and bookbinding companies. Incorporating a state-of-the-art digitisation studio, we offer a complete r.....Read more

The Poetry Village / thepoetryvillage

The Poetry Village

thepoetryvillage

The Poetry Village provides an on-line platform featuring some of the most exciting and inspirational writing by both new and established poets. Please follow our submissions guidelines. The Poetry Village also wo.....Read more

HAD-PRINT Huddersfield / Print Centre Huddersfield

HAD-PRINT Huddersfield

Print Centre Huddersfield

Check out our New Huddersfield Print Centre , Castlegate Huddersfield Our Experienced Print Bureau Staff have a wealth of knowledge to make your Print and Graphics Project stand - out from the crowd...Read more

Charlotte Furness / Freelance Writer

Charlotte Furness

Freelance Writer

My name is Charlotte, I am a local lady who has studied and worked within heritage for almost a decade. I am now a freelance writer and marketing specialist full time. My first book "Lady of the House: Elite 19th Cen.....Read more

Cleckheaton Literature Festival / Cleckheaton Literature Festival

Cleckheaton Literature Festival

Cleckheaton Literature Festival

Cleckheaton Literature Festival ran in 2015 and 2016, and we have now produced an anthology of writing, Reflections, to celebrate the legacy of the festival. The anthology is a rich and diverse collection of work by many.....Read more

John Ling / Paper Aeroplane Man

John Ling

Paper Aeroplane Man

Author, mediator and Facilitator of AVP in the NW. (Alternatives to Violence Project) Latest book - "Paper Aeroplane Man" Olympia Publishers. Unusual variety of short stories, humour, fantasy, crime and pathos. B.....Read more

David Parrish / profile

David Parrish

profile

David Parrish empowers and inspires creative entrepreneurs - to help them become even more successful. David helps creative people ('T-Shirts') use smart business thinking ('Suits'), so they can achieve success on the.....Read more

Adam Grose / Artist, Writer, Tutor and Publisher

Adam Grose

Artist, Writer, Tutor and Publisher

Adam Grose's practice explores walking, collecting, recording & mapping journeys in the landscape and memories. These explore layering thoughts or scenes during a walk, juxtaposed into an aesthetic re-presentation, form.....Read more

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