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
Harris' of Tasmania
Latrobe TAS 7307
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=5429 or tblfeedback.strbusinessname='Harris'%%semi%% of Tasmania' or tblfeedback.strbusinessname='Harris' of Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
His Nibbs Mensland
Devonport TAS 7310
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=3859 or tblfeedback.strbusinessname='His Nibbs Mensland' or tblfeedback.strbusinessname='His Nibbs Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Anna-Christina Bridal
Devonport TAS 7310
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=3850 or tblfeedback.strbusinessname='Anna-Christina Bridal' or tblfeedback.strbusinessname='Anna-Christina Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Frank's Bridal Salon
Devonport TAS 7310
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=3857 or tblfeedback.strbusinessname='Frank'%%semi%%s Bridal Salon' or tblfeedback.strbusinessname='Frank's Bridal Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A & J Formal Suit Hire
Ulverstone TAS 7315
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=5452 or tblfeedback.strbusinessname='A &%%semi%% J Formal Suit Hire' or tblfeedback.strbusinessname='A & J Formal Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brides of Burnie
Upper Burnie TAS 7320
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=3844 or tblfeedback.strbusinessname='Brides of Burnie' or tblfeedback.strbusinessname='Brides of Burnie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fashion Folkus
Burnie TAS 7320
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=3856 or tblfeedback.strbusinessname='Fashion Folkus' or tblfeedback.strbusinessname='Fashion Folkus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15