Rating
Julie Hebert Millinery
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=27584 or tblfeedback.strbusinessname='Julie Hebert Millinery' or tblfeedback.strbusinessname='Julie Hebert Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Inside Morocco
Stepney QLD 5069
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=26026 or tblfeedback.strbusinessname='Inside Morocco' or tblfeedback.strbusinessname='Inside Morocco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Velvet Henna
Adelaide SA 500
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=26028 or tblfeedback.strbusinessname='Velvet Henna' or tblfeedback.strbusinessname='Velvet Henna') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brittany Jordan Millinery
Glenelg South SA 5045
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=5662 or tblfeedback.strbusinessname='Brittany Jordan Millinery' or tblfeedback.strbusinessname='Brittany Jordan Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dianne Roberton
Flagstaff Hill SA 5159
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=5664 or tblfeedback.strbusinessname='Dianne Roberton' or tblfeedback.strbusinessname='Dianne Roberton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goldspink's Fine Bridal Head Wear
Woodville Gardens SA 5012
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=5666 or tblfeedback.strbusinessname='Goldspink'%%semi%%s Fine Bridal Head Wear' or tblfeedback.strbusinessname='Goldspink's Fine Bridal Head Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lorraine Gill Creations
Highbury SA 5089
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=5669 or tblfeedback.strbusinessname='Lorraine Gill Creations' or tblfeedback.strbusinessname='Lorraine Gill Creations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Hatters
Adelaide SA 5000
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=5660 or tblfeedback.strbusinessname='Adelaide Hatters' or tblfeedback.strbusinessname='Adelaide Hatters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hats by Jayne Morton
Kingston Park SA 5049
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=5667 or tblfeedback.strbusinessname='Hats by Jayne Morton' or tblfeedback.strbusinessname='Hats by Jayne Morton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crowning
Glenelg South SA 5045
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=5663 or tblfeedback.strbusinessname='Crowning' or tblfeedback.strbusinessname='Crowning') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Becky's Bridal & Millinery
Holden Hill SA 5088
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=5661 or tblfeedback.strbusinessname='Becky'%%semi%%s Bridal &%%semi%% Millinery' or tblfeedback.strbusinessname='Becky's Bridal & Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peter Trends Exclusive Bridal Gowns & Millinery
Adelaide SA 5000
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=6176 or tblfeedback.strbusinessname='Peter Trends Exclusive Bridal Gowns &%%semi%% Millinery' or tblfeedback.strbusinessname='Peter Trends Exclusive Bridal Gowns & Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Julie
Vista SA 5091
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=5668 or tblfeedback.strbusinessname='Julie' or tblfeedback.strbusinessname='Julie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Georginas Headwear
Kidman Park SA 5025
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=5665 or tblfeedback.strbusinessname='Georginas Headwear' or tblfeedback.strbusinessname='Georginas Headwear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15