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
Hilltribe Clothing
Kingaroy QLD 4610
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=2975 or tblfeedback.strbusinessname='Hilltribe Clothing' or tblfeedback.strbusinessname='Hilltribe Clothing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Khazen Kev
Dalby QLD 4405
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=2988 or tblfeedback.strbusinessname='Khazen Kev' or tblfeedback.strbusinessname='Khazen Kev') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Oasis Wedding World
Mount Isa QLD 4825
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=15842 or tblfeedback.strbusinessname='Oasis Wedding World' or tblfeedback.strbusinessname='Oasis Wedding World') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mark Smith's Menswear
Murgon QLD 4605
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=15751 or tblfeedback.strbusinessname='Mark Smith'%%semi%%s Menswear' or tblfeedback.strbusinessname='Mark Smith's Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maria Mastro Designs
Stanthorpe QLD 4380
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=3003 or tblfeedback.strbusinessname='Maria Mastro Designs' or tblfeedback.strbusinessname='Maria Mastro Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gabriella Pompetti Dressmaker
Stanthorpe QLD 4380
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=2964 or tblfeedback.strbusinessname='Gabriella Pompetti Dressmaker' or tblfeedback.strbusinessname='Gabriella Pompetti Dressmaker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alagich
Broken Hill South NSW 2880
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=7766 or tblfeedback.strbusinessname='Alagich' or tblfeedback.strbusinessname='Alagich') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
La Femme Boutique
Kingaroy QLD 4610
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=2990 or tblfeedback.strbusinessname='La Femme Boutique' or tblfeedback.strbusinessname='La Femme Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coppard's Menswear
Kingaroy QLD 4610
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=2942 or tblfeedback.strbusinessname='Coppard'%%semi%%s Menswear' or tblfeedback.strbusinessname='Coppard's Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Wear Express
Brisbane QLD 4211
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=18940 or tblfeedback.strbusinessname='Formal Wear Express' or tblfeedback.strbusinessname='Formal Wear Express') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Neil Bennetts Fashions
Broken Hill NSW 2880
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=10639 or tblfeedback.strbusinessname='Neil Bennetts Fashions' or tblfeedback.strbusinessname='Neil Bennetts Fashions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coolibah Menswear
Emerald QLD 4720
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=15731 or tblfeedback.strbusinessname='Coolibah Menswear' or tblfeedback.strbusinessname='Coolibah Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15