Rating
Bridal Classics
Ballajura WA 6066
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=17642 or tblfeedback.strbusinessname='Bridal Classics' or tblfeedback.strbusinessname='Bridal Classics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glamour & Co Beauty Studio
Strathfieldsaye VIC 3551
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=46555 or tblfeedback.strbusinessname='Glamour &%%semi%% Co Beauty Studio' or tblfeedback.strbusinessname='Glamour & Co Beauty Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tu To Per Te Hair Salon
Castlemaine VIC 3450
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=29128 or tblfeedback.strbusinessname='Tu To Per Te Hair Salon' or tblfeedback.strbusinessname='Tu To Per Te Hair Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kristie hedington hair and makeup
Bendigo VIC 3555
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=21607 or tblfeedback.strbusinessname='Kristie hedington hair and makeup' or tblfeedback.strbusinessname='Kristie hedington hair and makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
213 Hair Design
Castlemaine VIC 3450
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=22544 or tblfeedback.strbusinessname='213 Hair Design' or tblfeedback.strbusinessname='213 Hair Design') 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
Stacey McClure Make Up
Horsham VIC 3400
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=22135 or tblfeedback.strbusinessname='Stacey McClure Make Up' or tblfeedback.strbusinessname='Stacey McClure Make Up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brilee Anne Makeup Artist
Echuca VIC 3564
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=39935 or tblfeedback.strbusinessname='Brilee Anne Makeup Artist' or tblfeedback.strbusinessname='Brilee Anne Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush by Leanne
Brown Hill VIC 3550
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=26298 or tblfeedback.strbusinessname='Blush by Leanne' or tblfeedback.strbusinessname='Blush by Leanne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yellow Rose Beauty Studio
Buninyong VIC 3357
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=27603 or tblfeedback.strbusinessname='Yellow Rose Beauty Studio' or tblfeedback.strbusinessname='Yellow Rose Beauty Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Le Luxe Bridal Hair
Ballarat VIC 3350
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=39930 or tblfeedback.strbusinessname='Le Luxe Bridal Hair' or tblfeedback.strbusinessname='Le Luxe Bridal Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jools For Jim
Bendigo VIC 3550
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=17782 or tblfeedback.strbusinessname='Jools For Jim' or tblfeedback.strbusinessname='Jools For Jim') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair House
Bendigo VIC 3550
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=17763 or tblfeedback.strbusinessname='Hair House' or tblfeedback.strbusinessname='Hair House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15