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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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's Bridal & Millinery' or tblfeedback.strbusinessname='Becky's Bridal & Millinery') and year(getdate())-year(dtmadded)<=15
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 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 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 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 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's Fine Bridal Head Wear' or tblfeedback.strbusinessname='Goldspink's Fine Bridal Head Wear') and year(getdate())-year(dtmadded)<=15
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 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 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 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 & Millinery' or tblfeedback.strbusinessname='Peter Trends Exclusive Bridal Gowns & Millinery') and year(getdate())-year(dtmadded)<=15