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
Launceston Mens Wearhouse
Launceston TAS 7250
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=5436 or tblfeedback.strbusinessname='Launceston Mens Wearhouse' or tblfeedback.strbusinessname='Launceston Mens Wearhouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Launceston TAS 7250
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=5469 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
Neil Pitt Pty Ltd
Launceston TAS 7250
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=5468 or tblfeedback.strbusinessname='Neil Pitt Pty Ltd' or tblfeedback.strbusinessname='Neil Pitt Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Charles Boutique
Launceston TAS 7250
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=3852 or tblfeedback.strbusinessname='Charles Boutique' or tblfeedback.strbusinessname='Charles Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Sharee Marshall Fashion Centre
Launceston TAS 7250
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=5279 or tblfeedback.strbusinessname='Sharee Marshall Fashion Centre' or tblfeedback.strbusinessname='Sharee Marshall Fashion Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fancy
Launceston TAS 7250
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=5471 or tblfeedback.strbusinessname='Fancy' or tblfeedback.strbusinessname='Fancy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Myer Launceston
Launceston TAS 7250
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=5267 or tblfeedback.strbusinessname='Myer Launceston' or tblfeedback.strbusinessname='Myer Launceston') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15