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`=1 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-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-19", DATEDIFF(`media`.`mediaCreated`, "2019-08-19"), DATEDIFF("2019-08-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-19", DATEDIFF(`media`.`mediaUpdated`, "2019-08-19"), DATEDIFF("2019-08-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-19", DATEDIFF(`userLastUpdate`, "2019-08-19"), DATEDIFF("2019-08-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-19"), DATEDIFF("2019-08-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `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(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=1 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`.`mediaChecked`=0 OR `media`.`mediaApproved`=1) AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=1 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 (14) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 50;
Creative Network / directory / Profiles / Performing Arts / J / 1 to 32 of 32 https://www.creativetorbay.com/directory/?disc%5B0%5D=14&letter=j&view=rss Creative Torbay a state of the art directory for creative, arts, cultural people, places and businesses to showcase their work (events, news, jobs, video, images etc) and connect with each other and audiences. J Singers / J Singers Choir, Bridgwater Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/j-singers/ 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, ... JACK TREE / blessed are the cracked for they let in the light Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jack-tree/ Arboristic arts & curious crafts from large chainsaw sculpture & furniture to curio creatures, bowls, jewellery & silvarian oddities. performance artist, environmental educator. www.tribeofmog.org Jackie Juno / Jackie Juno Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jackie-juno/ 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 https://creativetorbay.com/jacqueline-1/ 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 https://creativedoncaster.com/jade-saxelby/ 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 https://creativetorbay.com/james-murphy-productions/ 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 Callàs Ball / St Albans Theatre & Filmmaker Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/james-callascompany/ I am the founder of The Callàs Company, an organisation creating original, visually driven theatre. Our first production All or Nothing? premiered at the Edinburgh Fringe Festival 2013 to critical acclaim. I also wro... James Sharp, drum tutor. / Professional drum tuition, for all ages & levels. Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/james-sharp-drum-tutor/ 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... JamesCotter / Actor Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jamescotter/ I am a highly accomplished stage and screen actor with a number of leading parts to my name as well as supporting roles in films such as Scareycrows (2015), Torn (2014), All in the Valley (2014), World War Z (2013), The ... Jane Anderson-Brown / Soprano, Flute and Saxophone Player, Musical Director and Coach Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jane-anderson-brown/ 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 https://creativetorbay.com/jason-abrahams-king-of-swing/ 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 https://creativetorbay.com/jason-disley-author-poet/ 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... Jay / Herts: Health for All Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/jay-1/ Visit Welwyn Garden City Library for our FREE half-term Health Event on Tuesday 13 February, 11.00am-3.30pm, packed with fun activities, advice and information for all ages. Highlights include active rhymes and session... Jeff Shimell / Jeff Shimell amateur artist Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jeff-shimell/ 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... Jen Allen / Artist & Speed Painter Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jen-allen/ Jen Allen - Artist & Speed Painter Jeremy / Business-Creative-Solutions Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jeremy/ Jeremy has been in the arts for over 30 years and as such has a wealth of experience to offer. He was a lecturer in Arts Management and Arts Business for 8 years at Paignton's South Devon College as well as Artistic Dire... Jill Priest / Actor, Singer, Song-Writer, Director, Choreographer Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/jill-priest/ 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 https://creativetorbay.com/jj-s-arts-academy/ ‘ 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 ... JK Theatre Arts / Theatre School Mon, 30 Nov -001 00:00:00 +0000 https://creativesacrosssussex.com/jktheatrearts/ JK Theatre Arts provides first class performing arts training for children between the ages of 3 and 18 years. Classes are located in Ardingly in Haywards Heath and Burgess Hill, West Sussex. Whether your child is a ... JKL Theatre / JKL Theatre Mon, 30 Nov -001 00:00:00 +0000 https://creativedoncaster.com/jkl-theatre/ JKL Theatre is run by passionate local theatre makers and educators and provides: JKL Drama Academy- Weekly YOUTH THEATRE classes- we create a fun and friendly atmosphere and teach children of all ages theatre and per... John Katon / SUPERJOHN ENTERPRISES Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/john-katon/ 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, ... Johnsunter / Mr Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/johnsunter/ I am a musician playing keyboards with the Dana Ali Band Joseph Buckler / Composer. Producer. Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/josephbuckler/ 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... Josh Marriott / Actor/Director & Workshop Facilitator Mon, 30 Nov -001 00:00:00 +0000 https://creativesomerset.com/josh-marriott/ I am a professional actor with extensive experience in the theatre and on screen. I have directed a number of pieces for the professional stage. I have created and delivered in excess of 2500 issue lead workshops in scho... Josie Williams / Community Arts Development Officer Mon, 30 Nov -001 00:00:00 +0000 https://swindondoesarts.co.uk/josie-williams/ The Commonweal School, a Performing Arts Academy offers all students an enjoyable, rewarding and high quality education. Mission statement: Our mission is to increase knowledge of the power of Art in a broad social co... Jude / Creative Producer, Space Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/jude/ Hi, my name's Jude and I work at for the Arts at Dartington. I run the Immerse artists' programme here, and manage Space - our set of world-class studio facilities. Judith Silver / North Watford Community Choir Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/judith-silver/ 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. Julia Hallawell LGC / Broadway Cinema and Theatre, Studio and Gallery Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/julia-hallawell-lgc/ The iconic Art Deco Broadway in Letchworth Garden City is now home to a new two-in-one theatre and cinema space. Its sister venue is Broadway Studio and Gallery, a flexible space for events, and a gallery which displays ... Julian Seager Actor / Julian Seager Actor Mon, 30 Nov -001 00:00:00 +0000 https://creativetorbay.com/julianseager/ Professional Actor living in Torbay. I have worked on a wide range of feature films and television shows. in the last year I have performed with Brad Pitt, Angelina Jolie, Hugh Jackman, Anne Hathaway, Tom Hiddlestone, R... Julian Wathen / Actor, Singer, Musician Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/julian-wathen/ 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... Just Sing! CIC / ... Mon, 30 Nov -001 00:00:00 +0000 https://creativehertfordshire.com/just-sing-cic/ 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... JustifyMoveDanceAcademy / JMDA Mon, 30 Nov -001 00:00:00 +0000 https://creativekirklees.com/justifymovedanceacademy/ A Community Dance Group. JMDA provides dance classes for boys and girls aged from 4+, young people and adult classes in various dance styles such as Street Jazz, Bollywood Dance, Creative Class for L...