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
Baxter Designs CNC and Laser
Maffra VIC 3680
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=25552 or tblfeedback.strbusinessname='Baxter Designs CNC and Laser' or tblfeedback.strbusinessname='Baxter Designs CNC and Laser') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bronwyn Walker Exclusive Millinery
Yinnar South VIC 3869
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=136 or tblfeedback.strbusinessname='Bronwyn Walker Exclusive Millinery' or tblfeedback.strbusinessname='Bronwyn Walker Exclusive Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Valew Fashions
Moe VIC 3825
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=12637 or tblfeedback.strbusinessname='Valew Fashions' or tblfeedback.strbusinessname='Valew Fashions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Thera's Boutique & Bridal House
Traralgon VIC 3844
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=349 or tblfeedback.strbusinessname='Thera'%%semi%%s Boutique &%%semi%% Bridal House' or tblfeedback.strbusinessname='Thera's Boutique & Bridal House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sale Bridal Boutique
Sale VIC 3850
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=319 or tblfeedback.strbusinessname='Sale Bridal Boutique' or tblfeedback.strbusinessname='Sale Bridal Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15