Rating
Sundari Gems
NSW
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=25983 or tblfeedback.strbusinessname='Sundari Gems' or tblfeedback.strbusinessname='Sundari Gems') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Prouds
QLD
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=25818 or tblfeedback.strbusinessname='Prouds' or tblfeedback.strbusinessname='Prouds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michael Hill
Sydney NSW 2000
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=26473 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michael Hill
Sydney NSW 2000
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=26473 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gregory's Jewellers (Bondi Junction)
Bondi Junction NSW 2022
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=29218 or tblfeedback.strbusinessname='Gregory'%%semi%%s Jewellers (%%semi%%Bondi Junction)%%semi%%' or tblfeedback.strbusinessname='Gregory's Jewellers (Bondi Junction)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Crystal Bay Bridal
Brisbane QLD 4000
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=27737 or tblfeedback.strbusinessname='Crystal Bay Bridal' or tblfeedback.strbusinessname='Crystal Bay Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michael Hill
Warrnambool VIC 3280
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=29129 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michael Hill
Warrnambool VIC 3280
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=29129 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Prouds
QLD
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=25818 or tblfeedback.strbusinessname='Prouds' or tblfeedback.strbusinessname='Prouds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brett's Art Works
Geelong West VIC 3218
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=13309 or tblfeedback.strbusinessname='Brett'%%semi%%s Art Works' or tblfeedback.strbusinessname='Brett's Art Works') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Amanda Jane Special Occasion Jewellery
Geelong VIC 3220
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=18198 or tblfeedback.strbusinessname='Amanda Jane Special Occasion Jewellery' or tblfeedback.strbusinessname='Amanda Jane Special Occasion Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Gill's Jewellers
Geelong VIC 3220
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=13347 or tblfeedback.strbusinessname='Mc Gill'%%semi%%s Jewellers' or tblfeedback.strbusinessname='Mc Gill's Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
JAB Jewellers
Geelong VIC 3220
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=13331 or tblfeedback.strbusinessname='JAB Jewellers' or tblfeedback.strbusinessname='JAB Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15