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
Ulayna Aster
Main Beach QLD 4217
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=26465 or tblfeedback.strbusinessname='Ulayna Aster' or tblfeedback.strbusinessname='Ulayna Aster') 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
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
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
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
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
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
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
Nerang Jewellers
Nerang QLD 4211
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=15057 or tblfeedback.strbusinessname='Nerang Jewellers' or tblfeedback.strbusinessname='Nerang Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grande Gems Pty Ltd
Surfers Paradise QLD 4217
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=15023 or tblfeedback.strbusinessname='Grande Gems Pty Ltd' or tblfeedback.strbusinessname='Grande Gems Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Paradise's Jewellers
Broadbeach QLD 4218
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=15061 or tblfeedback.strbusinessname='Paradise'%%semi%%s Jewellers' or tblfeedback.strbusinessname='Paradise's Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Damians Jewellers
Beenleigh QLD 4207
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=15004 or tblfeedback.strbusinessname='Damians Jewellers' or tblfeedback.strbusinessname='Damians Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lee Jeweller & Goldsmith
Chevron Island QLD 4217
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=15046 or tblfeedback.strbusinessname='Lee Jeweller &%%semi%% Goldsmith' or tblfeedback.strbusinessname='Lee Jeweller & Goldsmith') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Anderson
Southport QLD 4215
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=14980 or tblfeedback.strbusinessname='Anderson' or tblfeedback.strbusinessname='Anderson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Julian Lawrence Designer Jeweller
Broadbeach QLD 4218
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=15036 or tblfeedback.strbusinessname='Julian Lawrence Designer Jeweller' or tblfeedback.strbusinessname='Julian Lawrence Designer Jeweller') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jewellery by Armon
Burleigh Heads QLD 4220
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=15030 or tblfeedback.strbusinessname='Jewellery by Armon' or tblfeedback.strbusinessname='Jewellery by Armon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diamond Exchange
Southport QLD 4215
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=15006 or tblfeedback.strbusinessname='Diamond Exchange' or tblfeedback.strbusinessname='Diamond Exchange') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
R & T Goldsmiths
Palm Beach QLD 4221
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=15065 or tblfeedback.strbusinessname='R &%%semi%% T Goldsmiths' or tblfeedback.strbusinessname='R & T Goldsmiths') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Bostock Design
Sorrento QLD 4217
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=15033 or tblfeedback.strbusinessname='John Bostock Design' or tblfeedback.strbusinessname='John Bostock Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bakers Jewellers
Coolangatta QLD 4225
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=14989 or tblfeedback.strbusinessname='Bakers Jewellers' or tblfeedback.strbusinessname='Bakers Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
London Loans & Estate Jewellers
Southport QLD 4215
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=15047 or tblfeedback.strbusinessname='London Loans &%%semi%% Estate Jewellers' or tblfeedback.strbusinessname='London Loans & Estate Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Annabelle's Fine Estate & Antique Jewellery
Robina QLD 4226
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=14983 or tblfeedback.strbusinessname='Annabelle'%%semi%%s Fine Estate &%%semi%% Antique Jewellery' or tblfeedback.strbusinessname='Annabelle's Fine Estate & Antique Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Halpin's Jewellers
Burleigh Heads QLD 4220
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=15025 or tblfeedback.strbusinessname='Halpin'%%semi%%s Jewellers' or tblfeedback.strbusinessname='Halpin's Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Finelines Manufacturers of Fine Jewellery
Robina QLD 4226
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=15014 or tblfeedback.strbusinessname='Finelines Manufacturers of Fine Jewellery' or tblfeedback.strbusinessname='Finelines Manufacturers of Fine Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Original Showroom
Hope Island QLD 4212
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=15059 or tblfeedback.strbusinessname='Original Showroom' or tblfeedback.strbusinessname='Original Showroom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
SEL Pilgrim Silver & Goldsmith Manufacturer
Southport QLD 4215
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=15075 or tblfeedback.strbusinessname='SEL Pilgrim Silver &%%semi%% Goldsmith Manufacturer' or tblfeedback.strbusinessname='SEL Pilgrim Silver & Goldsmith Manufacturer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15