Rating Anania Family Jewellers
Anania Family Jewellers
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=29657 or tblfeedback.strbusinessname='Anania Family Jewellers' or tblfeedback.strbusinessname='Anania Family Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Since 1965, for three generations, we handcraft & repair jewellery.
Rating Elizabeth Bower
Elizabeth Bower
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=18026 or tblfeedback.strbusinessname='Elizabeth Bower' or tblfeedback.strbusinessname='Elizabeth Bower') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hand made elegant bridal jewellery.

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
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
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
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
Bassil Creations
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=25862 or tblfeedback.strbusinessname='Bassil Creations' or tblfeedback.strbusinessname='Bassil Creations') 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
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
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
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
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
Exquisite Jewels Australia
Leichhardt NSW 2040
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=43774 or tblfeedback.strbusinessname='Exquisite Jewels Australia' or tblfeedback.strbusinessname='Exquisite Jewels Australia') 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
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
Penelope Grace Jewellery
Wilton NSW 2571
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=46433 or tblfeedback.strbusinessname='Penelope Grace Jewellery' or tblfeedback.strbusinessname='Penelope Grace Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roman & French
Wetherill Park NSW 2164
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=38095 or tblfeedback.strbusinessname='Roman &%%semi%% French' or tblfeedback.strbusinessname='Roman & French') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ronza George Jewellery
Putney NSW 2112
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=44294 or tblfeedback.strbusinessname='Ronza George Jewellery' or tblfeedback.strbusinessname='Ronza George Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
David Connor Designs Pty Ltd
Balgowlah NSW 2093
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=8919 or tblfeedback.strbusinessname='David Connor Designs Pty Ltd' or tblfeedback.strbusinessname='David Connor Designs Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tourrier Sophie Jewellery
Surry Hills NSW 2010
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=11766 or tblfeedback.strbusinessname='Tourrier Sophie Jewellery' or tblfeedback.strbusinessname='Tourrier Sophie Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AM Jewellery Design
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=7826 or tblfeedback.strbusinessname='AM Jewellery Design' or tblfeedback.strbusinessname='AM Jewellery Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dixon Bruce Designs Pty Ltd
Lane Cove NSW 2066
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=9037 or tblfeedback.strbusinessname='Dixon Bruce Designs Pty Ltd' or tblfeedback.strbusinessname='Dixon Bruce Designs Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blue Turtle Studio
Newtown NSW 2042
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=8258 or tblfeedback.strbusinessname='Blue Turtle Studio' or tblfeedback.strbusinessname='Blue Turtle Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Robert MAC G Design
Castle Hill NSW 2154
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=11176 or tblfeedback.strbusinessname='Robert MAC G Design' or tblfeedback.strbusinessname='Robert MAC G Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ice Jewellers
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=9782 or tblfeedback.strbusinessname='Ice Jewellers' or tblfeedback.strbusinessname='Ice Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alexander H Iskenderian Jewellery
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=7777 or tblfeedback.strbusinessname='Alexander H Iskenderian Jewellery' or tblfeedback.strbusinessname='Alexander H Iskenderian Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kristina Karter Jewellery Design
Paddington NSW 2021
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=10111 or tblfeedback.strbusinessname='Kristina Karter Jewellery Design' or tblfeedback.strbusinessname='Kristina Karter Jewellery Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gary Peters Jewellery Studio
Balmain NSW 2041
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=9419 or tblfeedback.strbusinessname='Gary Peters Jewellery Studio' or tblfeedback.strbusinessname='Gary Peters Jewellery Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Penelope Ellen Jewellery
Bexley NSW 2207
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=10889 or tblfeedback.strbusinessname='Penelope Ellen Jewellery' or tblfeedback.strbusinessname='Penelope Ellen Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Piccoli
Surry Hills NSW 2010
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=10982 or tblfeedback.strbusinessname='Piccoli' or tblfeedback.strbusinessname='Piccoli') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
GS Gold Shop
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=18583 or tblfeedback.strbusinessname='GS Gold Shop' or tblfeedback.strbusinessname='GS Gold Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tousou Kimono Designs
Ryde NSW 2112
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=11767 or tblfeedback.strbusinessname='Tousou Kimono Designs' or tblfeedback.strbusinessname='Tousou Kimono Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jewellery Design Associates Pty Ltd
Castle Hill NSW 2154
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=9929 or tblfeedback.strbusinessname='Jewellery Design Associates Pty Ltd' or tblfeedback.strbusinessname='Jewellery Design Associates Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rhon Rae Productions Pty Ltd
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=11137 or tblfeedback.strbusinessname='Rhon Rae Productions Pty Ltd' or tblfeedback.strbusinessname='Rhon Rae Productions Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Deborah Windfield Jewellery Pty Ltd
Neutral Bay Junction NSW 2089
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=8962 or tblfeedback.strbusinessname='Deborah Windfield Jewellery Pty Ltd' or tblfeedback.strbusinessname='Deborah Windfield Jewellery Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kim Lien Jewellery
Marrickville NSW 2204
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=10077 or tblfeedback.strbusinessname='Kim Lien Jewellery' or tblfeedback.strbusinessname='Kim Lien Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Victoria Spring Designs
Paddington NSW 2021
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=11877 or tblfeedback.strbusinessname='Victoria Spring Designs' or tblfeedback.strbusinessname='Victoria Spring Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carolyn Meloy Individual Designs & Production Models
Bondi NSW 2026
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=8533 or tblfeedback.strbusinessname='Carolyn Meloy Individual Designs &%%semi%% Production Models' or tblfeedback.strbusinessname='Carolyn Meloy Individual Designs & Production Models') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Paspaley Pearls Pty Ltd
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=10861 or tblfeedback.strbusinessname='Paspaley Pearls Pty Ltd' or tblfeedback.strbusinessname='Paspaley Pearls Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blake & Angel
Lane Cove NSW 2066
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=8231 or tblfeedback.strbusinessname='Blake &%%semi%% Angel' or tblfeedback.strbusinessname='Blake & Angel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Independent Jewellery
Gymea NSW 2227
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=9810 or tblfeedback.strbusinessname='Independent Jewellery' or tblfeedback.strbusinessname='Independent Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Helen Teulon Jewellery Design
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=9665 or tblfeedback.strbusinessname='Helen Teulon Jewellery Design' or tblfeedback.strbusinessname='Helen Teulon Jewellery Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Artisto Cat
Ryde NSW 2112
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=7895 or tblfeedback.strbusinessname='Artisto Cat' or tblfeedback.strbusinessname='Artisto Cat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ANT Haus Designs
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=7870 or tblfeedback.strbusinessname='ANT Haus Designs' or tblfeedback.strbusinessname='ANT Haus Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ernst Pfenninger
Annandale NSW 2038
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=9183 or tblfeedback.strbusinessname='Ernst Pfenninger' or tblfeedback.strbusinessname='Ernst Pfenninger') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tracy Wenban Jewellers
Rushcutters Bay NSW 2011
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=11771 or tblfeedback.strbusinessname='Tracy Wenban Jewellers' or tblfeedback.strbusinessname='Tracy Wenban Jewellers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hablitschek John Gems Pty Ltd
Coogee NSW 2034
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=9589 or tblfeedback.strbusinessname='Hablitschek John Gems Pty Ltd' or tblfeedback.strbusinessname='Hablitschek John Gems Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 122 Sort search results alphabetically