Rating Belinda Ward Hair & Makeup
Belinda Ward Hair & Makeup
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=19589 or tblfeedback.strbusinessname='Belinda Ward Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Belinda Ward Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mobile Hair & Makeup Artist servicing Newcastle, Lake Macquarie & Central Coast areas, with over 10yrs experience.

Rating
Babydoll Makeup Artistry
Dubbo NSW 2380
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29843 or tblfeedback.strbusinessname='Babydoll Makeup Artistry' or tblfeedback.strbusinessname='Babydoll Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blanc Hair Studio
Warners Bay NSW 2282
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29842 or tblfeedback.strbusinessname='Blanc Hair Studio' or tblfeedback.strbusinessname='Blanc Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lisa Single Makeup Artist
Anna Bay NSW 2316
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26309 or tblfeedback.strbusinessname='Lisa Single Makeup Artist' or tblfeedback.strbusinessname='Lisa Single Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Klg the salon
Hamilton NSW 2303
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26838 or tblfeedback.strbusinessname='Klg the salon' or tblfeedback.strbusinessname='Klg the salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
VME Hair Studio
Newcastle NSW 2285
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25696 or tblfeedback.strbusinessname='VME Hair Studio' or tblfeedback.strbusinessname='VME Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Addictive Hair and Beauty
Grafton NSW 2460
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29688 or tblfeedback.strbusinessname='Addictive Hair and Beauty' or tblfeedback.strbusinessname='Addictive Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
WHITE Hair & Makeup
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27887 or tblfeedback.strbusinessname='WHITE Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='WHITE Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Newcastle Makeup by Emma
Charlesto4n NSW 2290
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25179 or tblfeedback.strbusinessname='Newcastle Makeup by Emma' or tblfeedback.strbusinessname='Newcastle Makeup by Emma') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Welcome to Wonderland
Dubbo NSW 2830
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=28989 or tblfeedback.strbusinessname='Welcome to Wonderland' or tblfeedback.strbusinessname='Welcome to Wonderland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cocotanning Hair Makeup and Beauty
Toronto NSW 2283
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=38446 or tblfeedback.strbusinessname='Cocotanning Hair Makeup and Beauty' or tblfeedback.strbusinessname='Cocotanning Hair Makeup and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jessica Howlett Hair Artist
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27272 or tblfeedback.strbusinessname='Jessica Howlett Hair Artist' or tblfeedback.strbusinessname='Jessica Howlett Hair Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brides with Style
Eleebana NSW 2282
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27170 or tblfeedback.strbusinessname='Brides with Style' or tblfeedback.strbusinessname='Brides with Style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kristi Urwin Makeup
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26424 or tblfeedback.strbusinessname='Kristi Urwin Makeup' or tblfeedback.strbusinessname='Kristi Urwin Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brides With Styles
Eleebana NSW 2282
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27188 or tblfeedback.strbusinessname='Brides With Styles' or tblfeedback.strbusinessname='Brides With Styles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Go Go Glam
Hamlyn Terrace NSW 2261
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26940 or tblfeedback.strbusinessname='Go Go Glam' or tblfeedback.strbusinessname='Go Go Glam') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ivory State Hair and Makeup
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=41627 or tblfeedback.strbusinessname='Ivory State Hair and Makeup' or tblfeedback.strbusinessname='Ivory State Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
White Hair & Makeup
Hunter Valley NSW 2323
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=24568 or tblfeedback.strbusinessname='White Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='White Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gloss Girl Bridal Story
Cessnock NSW 2325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=38316 or tblfeedback.strbusinessname='Gloss Girl Bridal Story' or tblfeedback.strbusinessname='Gloss Girl Bridal Story') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Airlie and co
Collaroy NSW 2097
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=43421 or tblfeedback.strbusinessname='Airlie and co' or tblfeedback.strbusinessname='Airlie and co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Kirby
Newcastle NSW 2290
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27273 or tblfeedback.strbusinessname='Makeup by Kirby' or tblfeedback.strbusinessname='Makeup by Kirby') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeupmejordyn
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27276 or tblfeedback.strbusinessname='Makeupmejordyn' or tblfeedback.strbusinessname='Makeupmejordyn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cassy Morris Mobile Hairstylist
Central Coast NSW 2260
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27502 or tblfeedback.strbusinessname='Cassy Morris Mobile Hairstylist' or tblfeedback.strbusinessname='Cassy Morris Mobile Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rock Paper Hair Studio
Dubbo NSW 2380
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25310 or tblfeedback.strbusinessname='Rock Paper Hair Studio' or tblfeedback.strbusinessname='Rock Paper Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Paint by Brock
Orange NSW 2800
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=41444 or tblfeedback.strbusinessname='Paint by Brock' or tblfeedback.strbusinessname='Paint by Brock') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Style by Divine
Thornton NSW 2322
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26888 or tblfeedback.strbusinessname='Style by Divine' or tblfeedback.strbusinessname='Style by Divine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Luxe Makeup Artistry
Central Coast NSW 2250
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21554 or tblfeedback.strbusinessname='Luxe Makeup Artistry' or tblfeedback.strbusinessname='Luxe Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Spoilt Beauty Studio
Dubbo NSW 2830
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27105 or tblfeedback.strbusinessname='Spoilt Beauty Studio' or tblfeedback.strbusinessname='Spoilt Beauty Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Demme
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27181 or tblfeedback.strbusinessname='Makeup by Demme' or tblfeedback.strbusinessname='Makeup by Demme') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gloss Girl
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26024 or tblfeedback.strbusinessname='Gloss Girl' or tblfeedback.strbusinessname='Gloss Girl') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kimidoll Makeup Artistry
Muswellbrook NSW 2333
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21596 or tblfeedback.strbusinessname='Kimidoll Makeup Artistry' or tblfeedback.strbusinessname='Kimidoll Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flayr
NSW
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=38132 or tblfeedback.strbusinessname='Flayr' or tblfeedback.strbusinessname='Flayr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ashley Cashman Makeup
Newcastle NSW 2267
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=37509 or tblfeedback.strbusinessname='Ashley Cashman Makeup' or tblfeedback.strbusinessname='Ashley Cashman Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chic Artistry
Lorn NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21214 or tblfeedback.strbusinessname='Chic Artistry' or tblfeedback.strbusinessname='Chic Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kylie Edwards Makeup
East Maitland NSW 2323
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29114 or tblfeedback.strbusinessname='Kylie Edwards Makeup' or tblfeedback.strbusinessname='Kylie Edwards Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
MBL Beauty
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27791 or tblfeedback.strbusinessname='MBL Beauty' or tblfeedback.strbusinessname='MBL Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dunn and Dusted
Newcastle NSW 2267
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29317 or tblfeedback.strbusinessname='Dunn and Dusted' or tblfeedback.strbusinessname='Dunn and Dusted') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Boys Makeup & Hair Studio
Mayfield West NSW 2304
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=23624 or tblfeedback.strbusinessname='The Boys Makeup &%%semi%% Hair Studio' or tblfeedback.strbusinessname='The Boys Makeup & Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Snip It's
Weston NSW 2326
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18565 or tblfeedback.strbusinessname='Snip It'%%semi%%s' or tblfeedback.strbusinessname='Snip It's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kendros Vicki-Make-Up Artist
Wallsend NSW 2287
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10050 or tblfeedback.strbusinessname='Kendros Vicki-Make-Up Artist' or tblfeedback.strbusinessname='Kendros Vicki-Make-Up Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Terrace Hair Designs
Raymond Terrace NSW 2324
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11705 or tblfeedback.strbusinessname='Terrace Hair Designs' or tblfeedback.strbusinessname='Terrace Hair Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ann's Hair Lounge
Mayfield NSW 2304
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=7867 or tblfeedback.strbusinessname='Ann'%%semi%%s Hair Lounge' or tblfeedback.strbusinessname='Ann's Hair Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Amanda Roddenby & Fiona Harrison
Merewether NSW 2291
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=7828 or tblfeedback.strbusinessname='Amanda Roddenby &%%semi%% Fiona Harrison' or tblfeedback.strbusinessname='Amanda Roddenby & Fiona Harrison') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lucia's Hairdressing Salon
Adamstown NSW 2289
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10285 or tblfeedback.strbusinessname='Lucia'%%semi%%s Hairdressing Salon' or tblfeedback.strbusinessname='Lucia's Hairdressing Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hairs Rok of Wallsend
Wallsend NSW 2287
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=9594 or tblfeedback.strbusinessname='Hairs Rok of Wallsend' or tblfeedback.strbusinessname='Hairs Rok of Wallsend') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adnama Beauty
Lorn NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18518 or tblfeedback.strbusinessname='Adnama Beauty' or tblfeedback.strbusinessname='Adnama Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fuse Gallery
Cessnock NSW 2325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18535 or tblfeedback.strbusinessname='Fuse Gallery' or tblfeedback.strbusinessname='Fuse Gallery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15