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
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
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
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
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
Jewellery By Design
Hyde Park QLD 4812
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=44587 or tblfeedback.strbusinessname='Jewellery By Design' or tblfeedback.strbusinessname='Jewellery By Design') 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
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
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
Michael Hill - Townsville
Aitkenvale QLD 4814
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=41215 or tblfeedback.strbusinessname='Michael Hill - Townsville' or tblfeedback.strbusinessname='Michael Hill - Townsville') 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
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
House of Flori
Mareeba QLD 4880
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=43371 or tblfeedback.strbusinessname='House of Flori' or tblfeedback.strbusinessname='House of Flori') 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
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
Brett Thompson Jewellers
Mareeba QLD 4880
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=14993 or tblfeedback.strbusinessname='Brett Thompson Jewellers' or tblfeedback.strbusinessname='Brett Thompson Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
House of Australian Design The
Innot Hot Springs QLD 4872
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=15027 or tblfeedback.strbusinessname='House of Australian Design The' or tblfeedback.strbusinessname='House of Australian Design The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Amardio Jewellery Design
Cairns QLD 4870
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=14979 or tblfeedback.strbusinessname='Amardio Jewellery Design' or tblfeedback.strbusinessname='Amardio Jewellery Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kim Bartlett Master Jewellers
Townsville QLD 4814
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=18959 or tblfeedback.strbusinessname='Kim Bartlett Master Jewellers' or tblfeedback.strbusinessname='Kim Bartlett Master Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Graham the Jeweller
Cairns QLD 4870
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=15022 or tblfeedback.strbusinessname='Graham the Jeweller' or tblfeedback.strbusinessname='Graham the Jeweller') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diamonds & Gold
Cairns QLD 4870
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=15009 or tblfeedback.strbusinessname='Diamonds &%%semi%% Gold' or tblfeedback.strbusinessname='Diamonds & Gold') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Robert Price Design Jewellery
Cairns QLD 4870
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=15070 or tblfeedback.strbusinessname='Robert Price Design Jewellery' or tblfeedback.strbusinessname='Robert Price Design Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kubach
Cairns QLD 4870
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=15044 or tblfeedback.strbusinessname='Kubach' or tblfeedback.strbusinessname='Kubach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bejewel
Cairns QLD 4870
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=14990 or tblfeedback.strbusinessname='Bejewel' or tblfeedback.strbusinessname='Bejewel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kim Bartlett Master Jewellers
Aitkenvale QLD 4814
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=15042 or tblfeedback.strbusinessname='Kim Bartlett Master Jewellers' or tblfeedback.strbusinessname='Kim Bartlett Master Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kai Hagberg
Kuranda QLD 4872
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=15040 or tblfeedback.strbusinessname='Kai Hagberg' or tblfeedback.strbusinessname='Kai Hagberg') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hepworth's
Cairns QLD 4870
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=15026 or tblfeedback.strbusinessname='Hepworth'%%semi%%s' or tblfeedback.strbusinessname='Hepworth's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crofton Clauson & Co
Cairns QLD 4870
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=15001 or tblfeedback.strbusinessname='Crofton Clauson &%%semi%% Co' or tblfeedback.strbusinessname='Crofton Clauson & Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jewel & Gem N Q Valuation Services
Hermit Park QLD 4812
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=15029 or tblfeedback.strbusinessname='Jewel &%%semi%% Gem N Q Valuation Services' or tblfeedback.strbusinessname='Jewel & Gem N Q Valuation Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chris Gaskill
Machans Beach QLD 4878
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=14998 or tblfeedback.strbusinessname='Chris Gaskill' or tblfeedback.strbusinessname='Chris Gaskill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
W & S Russell
Cairns QLD 4870
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=15083 or tblfeedback.strbusinessname='W &%%semi%% S Russell' or tblfeedback.strbusinessname='W & S Russell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goldberries Jewellery
Cairns QLD 4870
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=15021 or tblfeedback.strbusinessname='Goldberries Jewellery' or tblfeedback.strbusinessname='Goldberries Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gary DI Betta
Townsville QLD 4810
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=15018 or tblfeedback.strbusinessname='Gary DI Betta' or tblfeedback.strbusinessname='Gary DI Betta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15