Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kalamunda Central Suite Hire
Kalamunda WA 6076
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=7049 or tblfeedback.strbusinessname='Kalamunda Central Suite Hire' or tblfeedback.strbusinessname='Kalamunda Central Suite Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Steves Mens & Boys Wear
Manjimup WA 6258
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=7066 or tblfeedback.strbusinessname='Steves Mens &%%semi%% Boys Wear' or tblfeedback.strbusinessname='Steves Mens & Boys Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
City Formal Wear
Bunbury WA 6230
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=7038 or tblfeedback.strbusinessname='City Formal Wear' or tblfeedback.strbusinessname='City Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mandurah Formalwear
Mandurah WA 6210
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=3728 or tblfeedback.strbusinessname='Mandurah Formalwear' or tblfeedback.strbusinessname='Mandurah Formalwear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rockingham Formal & Bridal Hire
Rockingham WA 6168
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=3740 or tblfeedback.strbusinessname='Rockingham Formal &%%semi%% Bridal Hire' or tblfeedback.strbusinessname='Rockingham Formal & Bridal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cherokee Clothing Medieval Costumes
Capel WA 6271
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=3691 or tblfeedback.strbusinessname='Cherokee Clothing Medieval Costumes' or tblfeedback.strbusinessname='Cherokee Clothing Medieval Costumes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mandurah Fomalwear
Mandurah WA 6210
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=7050 or tblfeedback.strbusinessname='Mandurah Fomalwear' or tblfeedback.strbusinessname='Mandurah Fomalwear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albany Formal Hire
Albany WA 6330
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=3668 or tblfeedback.strbusinessname='Albany Formal Hire' or tblfeedback.strbusinessname='Albany Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pete's Surfwear
Collie WA 6225
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=7054 or tblfeedback.strbusinessname='Pete'%%semi%%s Surfwear' or tblfeedback.strbusinessname='Pete's Surfwear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Rockingham WA 6168
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=7065 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bon Marche Mensland
Bunbury WA 6230
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=7036 or tblfeedback.strbusinessname='Bon Marche Mensland' or tblfeedback.strbusinessname='Bon Marche Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15