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(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")) AS `desc`,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("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-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-20", DATEDIFF(`media`.`mediaCreated`, "2019-07-20"), DATEDIFF("2019-07-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-20", DATEDIFF(`media`.`mediaUpdated`, "2019-07-20"), DATEDIFF("2019-07-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-20", DATEDIFF(`userLastUpdate`, "2019-07-20"), DATEDIFF("2019-07-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-20"), DATEDIFF("2019-07-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-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]*j" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (13) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 50;
Directory of artists and creative organisation in Kirklees / Profiles / Music / J / 1 to 43 of 43 Creative Kirklees has an extensive directory of artists, creative organisations and places. Take a look at who’s working locally in Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas. J Singers / J Singers Choir, Bridgwater Mon, 30 Nov -001 00:00:00 +0000 The J Singers are a friendly amateur mixed-voice choir based in Bridgwater. We combine the aims of singing ‘seriously for pleasure’ with performing across the county at charity fund-raising concerts. Founded in 1966, ... Jackie Juno / Jackie Juno Mon, 30 Nov -001 00:00:00 +0000 Stand-up poet, comedian, singer with The Invisible Opera Company of Tibet; also artist and radio presenter. I organise and compere HOOT! Cabarets in various venues in Devon, so am always looking for new acts to entertain... Jacqueline / Miss Mon, 30 Nov -001 00:00:00 +0000 Specialist in music and movement education (Dalcroze) including Early Years, KS1 & 2, Music Students. Training in Dalcroze for teachers of the above. Piano and Harpsichord teacher. Music Theory Jade Saxelby / Actor and Director Mon, 30 Nov -001 00:00:00 +0000 I am an actor with experience in directing. Looking for exciting new projects and for writers of original material. JAMES & MURPHY PRODUCTIONS / James & Murphy Productions Mon, 30 Nov -001 00:00:00 +0000 A Devon based production company, writing and producing shows for theatre's, holiday parks, theme parks and hotels. After two successful summer runs at The Palace Theatre in 2009 and The Carlton Theatre in 2010, James... James / Drum Torbay Mon, 30 Nov -001 00:00:00 +0000 World roots drum and percussion workshops at Lupton House, Brixham. - These workshops are open to anyone who wants to explore their inner rhythm and soul! We explore the dynamics of group drumming playing rhythms from al... James Bullock / St John's Revival Mon, 30 Nov -001 00:00:00 +0000 Booking agent for international DJs Artists management Event management Creative consultancy James Mabbett / Napoleon IVth / Napoleon IIIrd Mon, 30 Nov -001 00:00:00 +0000 James Mabbett is a composer, musician, producer and sound artist. Releasing music and touring internationally as Napoleon IIIrd, his music is a rich tangle of sounds, experimental soundscapes and joyous melodies - ww... James Mayhew / Illustrator, author, storyteller Mon, 30 Nov -001 00:00:00 +0000 I am an artist and illustrator, storyteller and writer. Creator of the Katie's Picture Show books, and Ella Bella Ballerina, I also work with musicians and orchestras on family concerts, including the de Havilland Philha... James Music / Musician - Educator - Creative Entrepreneur Mon, 30 Nov -001 00:00:00 +0000 A highly creative BA (Hons) Commercial Music graduate based in Taunton with a diverse set of skills and experience, currently working as a Learning Support Assistant at The Taunton Academy ( James Sharp, drum tutor. / Professional drum tuition, for all ages & levels. Mon, 30 Nov -001 00:00:00 +0000 As a student or parent, you can be assured of the following when choosing James as a tutor: Structured, modular learning - Clear, simple, good value pricing - Regular feedback on student’s progress - Pro-qualit... JamFactory / JamFactory Mon, 30 Nov -001 00:00:00 +0000 Founded by two friends with a passion for all things musical; JamFactory is a musical education hub in Huddersfield with the goal of providing inspiration and a wide range of musical opportunities for people of all ages ... Jane Anderson-Brown / Soprano, Flute and Saxophone Player, Musical Director and Coach Mon, 30 Nov -001 00:00:00 +0000 Jane has many years experience of teaching, conducting and performing, beginning with school performances and covering a wide variety of musical styles. As a singer she has created operatic roles for Stephen McNeff an... jason abrahams king of swing / Jason Abrahams . Singer Of Jazz And Swing Mon, 30 Nov -001 00:00:00 +0000 Started singing from yr dot by ear progressed thru am dram to summer season ,cabaret and panto bit of filming ,theatre but always come back to music seems like most have no choice in the matter lifes cocaine. jazz starte... Jason Disley Author/poet / Jason Disley Poet Mon, 30 Nov -001 00:00:00 +0000 Jason Disley, is an Author and Poet from Manchester, who now resides on the English Riviera, in the South West of England, with his wife and children. Interests are The Beat Generation literature, Jazz music and the hist... Jazz & Blues TV / Profile Mon, 30 Nov -001 00:00:00 +0000 Jazz & Blues TV is a subscription based video-on-demand music channel, dedicated to showcasing exceptional artists performing the coolest Jazz, the smoothest Soul and the baddest Blues. We believe exceptional talent d... Jazz Workshop / Jazz Workshop Mon, 30 Nov -001 00:00:00 +0000 The Jazz Workshop has two main aims, which are primarily educational: · to introduce new musicians to playing jazz, so that more people play jazz; · to provide opportunities for existing jazz musicians to play together... Jeff Shimell / Jeff Shimell amateur artist Mon, 30 Nov -001 00:00:00 +0000 Jeff became interested in drawing on early retirement in 1979, and has since worked in a variety of medium, though he has developed a special affinity to watercolour and oil. Impatience has led him to use Alkyd, quick-dr... jersey / miss Mon, 30 Nov -001 00:00:00 +0000 Published writer of short stories and poetry. Also a Novelist and Children's Writer. Plus a songwriter too! Have had success in teaching creative writing to foreign learners in the past and would like to network in my l... Jess and Moira Sing / Jess and Moira Sing Mon, 30 Nov -001 00:00:00 +0000 Jess Baker and Moira Wade are both members of the Natural Voice Network and have been leading harmony singing sessions for over 5 years with people of all ages. Jess is also and accomplished singer/songwriter. We beli... Jessica Davey / Composer Mon, 30 Nov -001 00:00:00 +0000 I am a composer and arranger with experience in popular, jazz, and musical theatre styles, specialising in arrangements for live instruments. Credits include the short film A Mind Beside Itself (2011 as Jessica McFar... Jessica Price / Miss Mon, 30 Nov -001 00:00:00 +0000 Double Bassist Studies at the Purcell School of Music, Lower Sixth. Member of the National Youth Orchestra, and the Junior Royal Academy of Music. Jill Priest / Actor, Singer, Song-Writer, Director, Choreographer Mon, 30 Nov -001 00:00:00 +0000 Originally from Sheffield, I was brought up on stage, dancing from the age of 4 and appearing in pantos and variety shows throughout my childhood. At Durham University I continued to dance, co-founding InStep Contemporar... JJ's Arts Academy / JJ's Music School Mon, 30 Nov -001 00:00:00 +0000 ‘ Welcome to JJ’s Arts Academy! Previously known as JJ's Music School set up in September 2006 before its relaunch in January 2015 to JJ's Arts Academy. For many, this will be the start of your musical journey. This can ... JKM Guitars / Hand Made Guitars and Ukuleles Mon, 30 Nov -001 00:00:00 +0000 JKM Guitars specialising in making and repairing stringed musical instruments and are based in Storrington, West Sussex. JKM guitars is run by Jacob Menear, a fully qualified luthier with 5 years of making and repair... Jo / Not Tonight Josephine - covers band Mon, 30 Nov -001 00:00:00 +0000 Band available for functions, weddings, parties and events Not Tonight Josephine is an excellent 5 piece covers band based in Hertfordshire who play all types of music from the swinging sixties right up to modern day ... Joao Marques / My Profile Mon, 30 Nov -001 00:00:00 +0000 I'm looking for a long-term career after being abroad for the last two years in Africa. I'm living in Brighton, a city that I really enjoy, and I would like to continue working in the Design area here. My long term plan... Joe Copplestone / Journalist and Music Producer Mon, 30 Nov -001 00:00:00 +0000 Over the past 3 years, I have worked steadily as a songwriter and producer with 3 different singers in London and have been involved with songwriting and creative direction with Midlands music production company Dusted P... John Katon / SUPERJOHN ENTERPRISES Mon, 30 Nov -001 00:00:00 +0000 semi retired technical stage manager with over 20 years experience at many venues in London and home countie i have worked with Clive Owen, Dervla Kirwan, Susannah York , Linda Marlowe , Brendan Coyle , Aiden Gilan, ... John Wiles / Jazz pianist Mon, 30 Nov -001 00:00:00 +0000 SET the perfect atmosphere on your special day with live background music from me, jazz pianist John Wiles. Whether you're planning a wedding reception, dinner party, or corporate function, a personalised performance ... Johnsunter / Mr Mon, 30 Nov -001 00:00:00 +0000 I am a musician playing keyboards with the Dana Ali Band Jol Rose / Harbour Fest Swindon Mon, 30 Nov -001 00:00:00 +0000 I'm volunteering with Swindon's rather wonderful Harbour Project, to organise a multi-cultural arts fest to raise awareness - and much-needed funds - for the important work of supporting newly arrived asylum seekers and ... Jon Stein / Writer and Musician Mon, 30 Nov -001 00:00:00 +0000 Writer and Musician Jon has been a professional musician for over 20 years. Recently he has focused on creative writing and published his first book 'On the Road to Auroville' in 2012. Jonathan Gayle / Wayne McArthur & The Universal Players Mon, 30 Nov -001 00:00:00 +0000 The seven-piece reggae roots band based in Beds, Bucks & Herts is headed by singer and songwriter Wayne McArthur, ably backed by drum, bass, guitar, keyboard, percussion rhythm section and vocal harmonies. The band have ... JONATHAN MARK / vocalist& Entertainer Mon, 30 Nov -001 00:00:00 +0000 As an entertainer with 30 years experience performing both at home and abroad, top vocalist, JONATHAN MARK performs a wide range of music, from smooth powerful, ballads to foot-tapping up-tempo numbers; from the days of ... Jonny Croose / Busker, writer, performer, musician & arts academic. Mon, 30 Nov -001 00:00:00 +0000 I am a busker, theatre writer, performer, musician, teacher and academic with a 20-year record working in community arts, festival, street theatre, music, Theatre and Drama in Education, youth and community work. I h... Joseph Buckler / Composer. Producer. Mon, 30 Nov -001 00:00:00 +0000 Joseph is a composer, orchestrator/arranger, performer and conductor based at his studio near Bristol, UK. Joseph is versatile in his composition, performance and music production, with experience in soundtracks, elec... Judith Silver / North Watford Community Choir Mon, 30 Nov -001 00:00:00 +0000 This friendly choir meets weekly on Tuesdays from 7.30 to 9pm. We sing songs and rounds in harmony, in English and sometimes in other languages. Everything is learned by ear and no experience is necessary. Julian Wathen / Actor, Singer, Musician Mon, 30 Nov -001 00:00:00 +0000 Actor, singer (baritone), musician (guitar, bass-guitar) and occasional dancer. Interested in performance. Acting credits include: Harry Brewer, John Arscott, Cpt Jemmie Campbell (Our Country's Good), Puck (A Midsumm... Jumping Out Music Duo / (a big mix of low key music) & commecial jazz outfit Mon, 30 Nov -001 00:00:00 +0000 The Duo play a big mix of easy listening or background music including jazz favourites, 50, 60s ballads, modern acoustic. We also play in a commercial trad, swing & blues outfit (2, 3, 4, 5 or 6). All the old classics & ... Just A Cappella / singing without musical instruments Mon, 30 Nov -001 00:00:00 +0000 We are an award winning vocal group based in Hemel Hempstead. Blending the voices of men and women in close unaccompanied harmony, we sing popular songs from the 1930's through to the 21st Century. Just Sing! CIC / ... Mon, 30 Nov -001 00:00:00 +0000 is a social enterprise dedicated to promoting and communicating the health, social and community benefits of singing. Research shows, that enjoying singing as part of a group and enabling people to experience and part... Jwdaubney / MR Mon, 30 Nov -001 00:00:00 +0000 Technical Events Administrator at C6 Commonweal