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-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`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*n" 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 / N / 1 to 19 of 19 https://www.creativekirklees.com/directory/?disc%5B0%5D=13&letter=n&view=rss 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. Nacro / Broxbourne Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/nacro/ Nacro prevents people from getting involved in antisocial behaviour by working with them to improve their attitudes and behaviour. We also work with local communities to address the damage caused by antisocial behaviour.... Natalie Giacone / Musical Theatre/Pop Singing Teacher Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/natalie-giacone/ I am a self-employed singing teacher, specialising in Musical Theatre & Pop genres. I teach from home, Watford, Hertfordshire and currently have around 20 students. I trained at Mountview Academy of Theatre Arts, Mus... Nearly a Chaos / Musician Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/nearly-a-chaos/ I am a Hertfordshire based musician. I'm currently developing a number of soundtracks for Peppermint Muse theatre company. Demo tracks are available as free downloads from: www.soundcloud.com/nearly-a-chaos www.ne... Neil Maya / The Neil Maya Quartet Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/neil-maya/ The Neil Maya Quartet is one of the Southwest’s most exciting and talented bands, whose aim is to find fresh, new sounds within the wide scope of jazz whilst staying accessible to the public at large. As well as playing ... Neil Richards / The Digital Film Company - 1D, 2D, 3D digital content creation Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/neil-richards/ The Digital Film Company offers high-definition video production services specialising in "affordable" stereoscopic 3D for a wide variety of applications: music, dance, training and education, corporate and advertising a... New Devon Opera / WORLD CLASS OPERA!" NDO presents MADAM BUTTERFLY (Puccini) Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/new-devon-opera/ New Devon Opera's 2012 production is one of opera's best loved operas Puccini's gorgeous story of love and betrayal, "Madam Butterfly", sung in English. 2012 dates : 17/18 July at Theatre 1, Roland Levinsky Bldg, Ply... New Mill Male Voice Choir / A friendly choir with lots of perks Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/new-mill-male-voice-choir/ Harmony, Performance and Friendship There are as many reasons for joining a choir as there are members. An affinity with music is a good start. Some singers enjoy a weekly two hours away from day-to-day pressure in th... New Orleans Wiggle / New Orleans Wiggle Jazz Band Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/new-orleans-wiggle/ 6 piece jazz band playing the music from the early days of New Orleans including standards, ragtime, blues, spiritual for dancing, parties, weddings, festivals, indoors or outside. Our regular friendly monthly venue on... New Weird Huddersfield / Experimental Events Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/new-weird-huddersfield/ Experimental/alternative/weird music and arts event in and around Huddersfield. Nick / Salsa Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/nick-1/ Organiser of Salsa and Latin Events in Torbay Nick Carey / The Big Casino Mon, 30 Nov -001 00:00:00 +0000 https://swindondoesarts.co.uk/nick-carey/ Founded 1992 . The Band was formed in Swindon in 1992 by guitarist Bill King, Nick Carey & Pete Stephens. The name of the band was a reference to Bill's particular view on the random nature of life and the universe. Bill... Nick Evans-Pughe / Professional Violinist Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/nick-evans-pughe/ Violinstudio:Hitchin is the professional practice of Nick Evans-Pughe LRAM, PGdip (Mttp), a professional violinist with accredited expertise and experience in a range of disciplines: violin teaching (private, all ages;... Nicky Swann / singer songwriter Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/nicky-swann/ "Loved her songs" Boo Hewerdine "How Does Your Land Lie?" is a must hear album" Spiral Earth “Acoustic raw talent, no frills, no fancies, just pure, enigmatic soul." Maverick Magazine “Subtlety combined with g... Nicola Hall / Teacher Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/nicola-hall/ I am a self employed dance teacher. Just returned from the UAE were I was teaching emirates Bollywood/ bhangra style dance and fitness. I also teach children a dance mix were they can dip their good toes in differen... Nicola Smith / musician and teacher Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/nicola-smith/ Musician, teacher, mentor, orchestra manager and concert manager. Qualifications: B.A. (hons) Music - Dartington, P.G.C.E. secondary music, M.A. music education. I am a viola player (no jokes please!). I teach violi... Nigel Wood / Nigel Wood Ecology Services Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/nigel-wood-1/ Nigel Wood MCIEEM BSc Is a local ecological consultant providing advice to business and individuals on the vagaries of wildlife law. For more than 30 years , as a warden, ranger or site manager of a wide range of n... Nina / Nourish Festival Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/nina-1/ Nourish is a community iniatiave led by The Contemporary Craft Festival, The Cheese Shed and The Devon Guild of Craftsmen. A weekend of events celebrating fine food, craft and classical music in the heart of Bovey Tra... Niss / Manager at The Studio Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/niss/ A creative work and exhibitions space for creative people to share in Wells, Somerset, 10 min walk from center. The space is suitable for the larger art projects and the smaller ones), up to 5.5 meters high – you can ... Northern Quarter, Huddersfield / Northern Quarter Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/northern-quarter-huddersfield/ Northern Quarter is an independent live music venue and events space opened in December 2017. Welcoming and inclusive, the space host’s an array of music and performance from local and nationally touring live bands to Cl...