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-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-18", DATEDIFF(`media`.`mediaCreated`, "2019-07-18"), DATEDIFF("2019-07-18", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-18", DATEDIFF(`media`.`mediaUpdated`, "2019-07-18"), DATEDIFF("2019-07-18", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-18", DATEDIFF(`userLastUpdate`, "2019-07-18"), DATEDIFF("2019-07-18", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-25" AND "2019-10-10", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-18", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-18"), DATEDIFF("2019-07-18", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-18", IF(`media`.`mediaDate`>"2019-07-18", `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` 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]*u" 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 / U / 1 to 31 of 31 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. UCD / University Centre Doncaster Mon, 30 Nov -001 00:00:00 +0000 Providers of Higher Education at Doncaster College. A range of Education, Health and Community Practice courses are available. Udifydance Company / Performance and Education Mon, 30 Nov -001 00:00:00 +0000 Udifydance Company is an all male contemporary dance company founded in 2008 by Artistic Directors Chay Burrows and Christopher Reynolds. Their first duet, ‘PLeX’ was performed across West Sussex, Hampshire and London be... UHArts / University of Hertfordshire Mon, 30 Nov -001 00:00:00 +0000 University of Hertfordshire Arts (UHArts) supports the cultural life of the University and the wider community through the provision of high quality and affordable arts events and exhibitions. Within our excellent pe... UH_Recruit / jwlallen Mon, 30 Nov -001 00:00:00 +0000 Where is your next generation of employee talent coming from? I am interested in working with representatives of organisations of all sizes, who have an interest in recruiting graduates. This could be short and long t... Ultimate Mobile Recordings / Sound Engineering Mon, 30 Nov -001 00:00:00 +0000 Ultimate Mobile Recordings is a fully equip mobile recording studio. with use of high quality digital hardware and software. including midas preamps and microphones for excellent audio recordings as well as use the use o... Unbloq / About Mon, 30 Nov -001 00:00:00 +0000 We believe in the power of design. Our unique and intuitive approach across a wide range of media is the reason our clients get noticed. We create designs that excite, get the results you’re after and bring a return on... Under One Sun / Global Music & Culture Promotion Mon, 30 Nov -001 00:00:00 +0000 Under One Sun's formal aims are "To promote greater collective caring about our communities & our environment, and especially issues around differing cultural norms and traditions; equality and justice; and living in har... Under Wraps Music / Under Wraps Music Mon, 30 Nov -001 00:00:00 +0000 Under Wraps Music is a music company and record label specializing in events, bookings and artist development. Run by Noah Burton, a creative producer and musician from Huddersfield UK. Noah still performs with many m... Undercurrent / Undercurrent Mon, 30 Nov -001 00:00:00 +0000 Undercurrent Weekend 2012 Friday 17th, Saturday 18th, and Sunday 19th August 10am - 4pm All activities are FREE Take part in this three-day weekend of playful installations and interactive games across Shoreham’s... UNDESIGN / visual Mon, 30 Nov -001 00:00:00 +0000 Educator/Designer/Artist/Free-Thinker UnglueYou / Create, Connect & Communicate through art and storytelling Mon, 30 Nov -001 00:00:00 +0000 Hi, my name is Andréa. UnglueYou uses collage art as a visual way to explore and express feelings, thoughts or ideas. I started UnglueYou because when we express ourselves visually we can access our subconscious, allowin... Union 10 Design / Branding / Web Design / Print Mon, 30 Nov -001 00:00:00 +0000 Union 10 Design is a full-service design agency, providing brand, digital and print services to a diverse collection of clients and brands. Our approach balances technology with creativity. By bringing craftsmanship, ... Unique Boutique / E Carr Mon, 30 Nov -001 00:00:00 +0000 pop up markets that show case the best south west designers and makers. Next market: 28th November, 10-5, Exeter Phoenix. Uniquely Knitted / Custom-Made Hand-Knitted Hats, Scarves and Pets! Mon, 30 Nov -001 00:00:00 +0000 Suzanne Smith, owner and founder of Uniquely Knitted, was taught to knit by her late Mum when she was six years old. However, she didn't pick up her knitting needles again until the age of 37, when she was looking for a ... Unit 9 Gallery / Exhibition Space Mon, 30 Nov -001 00:00:00 +0000 Unit 9 Gallery is an exciting new exhibition space in the centre of Huddersfield which opened in November 2014. By collaborating with curators and other organisations we will provide a changing program of events and oppo... Unit Seven / Enterprise Bureau Mon, 30 Nov -001 00:00:00 +0000 Unit Seven is a shared space for work and leisure for people who want to enjoy life in and around Torquay Harbour from the comfort of our stylish and luxurious studio. The idea for Unit Seven was formed when thinking... United4Good / Asset Based Community Development Mon, 30 Nov -001 00:00:00 +0000 Our mission is to identify underutilised community assets within the Broxbourne and East Herts area and explore ways that they could better serve the community in the form of community cohesion projects. UNITY STUDIOS / Unity Arts Trust Mon, 30 Nov -001 00:00:00 +0000 Unity Arts Trust (UAT) have been developing a vision that has two interconnecting functions - The outcomes of the successful life/career development of Artists, some of whom work in affordable studios, are to be directed... University of Chichester / Fine Art BA & MA Mon, 30 Nov -001 00:00:00 +0000 The University of Chichester's Fine Art Department is based in 'artOne', a purpose-designed building on the Bishop Otter Campus in Chichester. The Department runs BA (Hons) and MA courses in Fine Art, both of which are s... University of Huddersfield / 175th Anniversary Mon, 30 Nov -001 00:00:00 +0000 To mark the 175th Anniversary of the Young Men’s Mental Improvement Society, a predecessor institution, the University of Huddersfield has organised a series of celebratory events, a lot of them around the creativity and... University of Huddersfield / Events Mon, 30 Nov -001 00:00:00 +0000 The University of Huddersfield – Inspiring Global Professionals The University of Huddersfield has a growing reputation as an inspiring, innovative provider of higher education of international renown. Recognised as ... Unleashed Theatre Company / Community Drama Group Mon, 30 Nov -001 00:00:00 +0000 Unleashed Theatre Company and Unleashed Community Drama are two strands of the same organization. Unleashed Community Drama is an inspiring community program aimed at folk who have been / or are homeless, ex-offenders, f... Unleashed Web / About Us Mon, 30 Nov -001 00:00:00 +0000 We provide web design, e-commerce and digital marketing services to clients throughout Exeter and the South West Do you need help with your website? The team of highly experienced experts at Unleashed work with their ... Unna Way / A B O U T Mon, 30 Nov -001 00:00:00 +0000 U N N A W A Y is an artist led organisation based in Huddersfield, established in 2015 to develop criticality within artistic frameworks and facilitate engaging, ambitious and reflexive artistic dialogue through exhibiti... Untold Films-Benjamin Everingham / Film Maker Mon, 30 Nov -001 00:00:00 +0000 Benjamin Everingham has worked cross platform in digital, film, and TV - always with the same high production values whatever the media. Projects include Directing, editing and producing video content for various FMC... Upcycle Fashion / Julia Roebuck Mon, 30 Nov -001 00:00:00 +0000 Delivering textile Upcycling workshops to extend the useful life of clothing and accessories and end textile waste. Upcycle-Devon / Aboutus Mon, 30 Nov -001 00:00:00 +0000 A service catered and inspired by you Turning preloved materials and turning them into quirky, innovative pieces to be proud of. We will work with what you have to reduce, reuse and repurpose materials that would o... Upstairs Gallery / Upstairs Gallery Berkhamsted Mon, 30 Nov -001 00:00:00 +0000 The Upstairs Gallery, in Berkhamsted, is supported by a charitable trust and aims to provide a showcase for Chiltern artists at an affordable cost. Throughout the year the gallery will be showing themed exhibitions, one ... Urban Voice Choir / Choir Mon, 30 Nov -001 00:00:00 +0000 Urban Voice was formed 7 years ago by our Choir Master, Steve Bray. We consist of around 30 members of varying ages, experience and walks of life; a lot of us have a background with local theatre groups, hence our perfor... Ursula / Superact CIC - Arts and Wellbeing Mon, 30 Nov -001 00:00:00 +0000 Superact CIC is an organisation that uses creativity to improve the lives of vulnerable groups and bring communities together. We provide music for hospitals and people living with dementia; run participatory storytel... used2bee / Recycle Organic Fairtrade Mon, 30 Nov -001 00:00:00 +0000 Come to us to be inspired , excited, delighted by an enlightened range of superb recycled fairtrade and organic products. Clothing, gifts, foods, homeware, all individual and unique. Torbays only ECOshop