Inside Morocco
149 Magill Road 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
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
Julie Hebert Millinery
5 Etna Street 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
Adelaide Hatters
Shop 47 Adelaide Arcade 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
Becky's Bridal & Millinery
Shop 4 11 Brabham Avenue 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 year(getdate())-year(dtmadded)<=15
Brittany Jordan Millinery
Shop 3 101-103 Partridge Street 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
Crowning
70 Broadway Street 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
Dianne Roberton
81 Ridgway Drive 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
Georginas Headwear
Frogmore Road
<BR>Cnr Valetta Rd 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
Goldspink's Fine Bridal Head Wear
37 Danvers Grove 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 year(getdate())-year(dtmadded)<=15
Hats by Jayne Morton
9 Pine Avenue 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
Julie
56 Janlyn Road 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
Lorraine Gill Creations
2 Rustic Court 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
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 year(getdate())-year(dtmadded)<=15
