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
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
Glam Couture Bridal
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=43500 or tblfeedback.strbusinessname='Glam Couture Bridal' or tblfeedback.strbusinessname='Glam Couture Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Unique Diamonds Canberra
Kingston ACT 2604
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=46062 or tblfeedback.strbusinessname='Unique Diamonds Canberra' or tblfeedback.strbusinessname='Unique Diamonds Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tiffany
Melbourne VIC 3000
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=29489 or tblfeedback.strbusinessname='Tiffany' or tblfeedback.strbusinessname='Tiffany') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Black & Bloom
Melbourne VIC 3000
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=43994 or tblfeedback.strbusinessname='Black &%%semi%% Bloom' or tblfeedback.strbusinessname='Black & Bloom') 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
Harry Rose
Canberra City ACT 2601
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=27157 or tblfeedback.strbusinessname='Harry Rose' or tblfeedback.strbusinessname='Harry Rose') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Diamond Boutique
Braddon ACT 2612
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=41136 or tblfeedback.strbusinessname='Diamond Boutique' or tblfeedback.strbusinessname='Diamond Boutique') 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
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
Vangeli Manufacturing
Woden ACT 2606
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=5582 or tblfeedback.strbusinessname='Vangeli Manufacturing' or tblfeedback.strbusinessname='Vangeli Manufacturing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mihran's Jewellers
Manuka ACT 2603
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=5579 or tblfeedback.strbusinessname='Mihran'%%semi%%s Jewellers' or tblfeedback.strbusinessname='Mihran's Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Erich Radinger
Kingston ACT 2604
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=5577 or tblfeedback.strbusinessname='Erich Radinger' or tblfeedback.strbusinessname='Erich Radinger') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Armen's Gallery Jeweller
Woden ACT 2606
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=5574 or tblfeedback.strbusinessname='Armen'%%semi%%s Gallery Jeweller' or tblfeedback.strbusinessname='Armen's Gallery Jeweller') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Briolette Jewellers
Franklin ACT 2913
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=5576 or tblfeedback.strbusinessname='Briolette Jewellers' or tblfeedback.strbusinessname='Briolette Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Talal Jeweller
Weston ACT 2611
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=5581 or tblfeedback.strbusinessname='Talal Jeweller' or tblfeedback.strbusinessname='Talal Jeweller') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Minx Designer Jewellers
Tuggeranong ACT 2900
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=5580 or tblfeedback.strbusinessname='Minx Designer Jewellers' or tblfeedback.strbusinessname='Minx Designer Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Giovanni & Jones
Queanbeyan NSW 2620
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=9459 or tblfeedback.strbusinessname='Giovanni &%%semi%% Jones' or tblfeedback.strbusinessname='Giovanni & Jones') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bijioux Jewellers
Canberra City ACT 2601
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=5575 or tblfeedback.strbusinessname='Bijioux Jewellers' or tblfeedback.strbusinessname='Bijioux Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Conservation & Restoration Studio The
Bonython ACT 2905
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=4250 or tblfeedback.strbusinessname='Conservation &%%semi%% Restoration Studio The' or tblfeedback.strbusinessname='Conservation & Restoration Studio The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hansens
Canberra City ACT 2601
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=5578 or tblfeedback.strbusinessname='Hansens' or tblfeedback.strbusinessname='Hansens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15