Lord Coconut
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=20134 or tblfeedback.strbusinessname='Lord Coconut' or tblfeedback.strbusinessname='Lord Coconut ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Specialising in handcrafted contemporary wedding jewellery & cufflinks for men.
Stephanie Browne Australia
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=18199 or tblfeedback.strbusinessname='Stephanie Browne Australia' or tblfeedback.strbusinessname='Stephanie Browne Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elegant couture jewellery, classic and uncomplicated pieces through to strikingly bold 'must have' pieces.
Boutique Brollies
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=20211 or tblfeedback.strbusinessname='Boutique Brollies' or tblfeedback.strbusinessname='Boutique Brollies ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The one thing you cannot predict...
Samaria's Manchester
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=17267 or tblfeedback.strbusinessname='Samaria'%%semi%%s Manchester' or tblfeedback.strbusinessname='Samaria's Manchester') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A perfect 'quick gift'
Yazzi International
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=19940 or tblfeedback.strbusinessname='Yazzi International' or tblfeedback.strbusinessname='Yazzi International') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Creative, imaginative and multi-functional jewellery organisers.
Miss Gowns Bridal and Debutante Boutique
Berwick VIC 3806
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=27010 or tblfeedback.strbusinessname='Miss Gowns Bridal and Debutante Boutique' or tblfeedback.strbusinessname='Miss Gowns Bridal and Debutante Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Heather McDowall
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=41521 or tblfeedback.strbusinessname='Heather McDowall' or tblfeedback.strbusinessname='Heather McDowall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Derby and Power
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=38296 or tblfeedback.strbusinessname='Derby and Power' or tblfeedback.strbusinessname='Derby and Power') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Heather McDowall
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=41521 or tblfeedback.strbusinessname='Heather McDowall' or tblfeedback.strbusinessname='Heather McDowall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jeanette Maree Jewellery
Armadale VIC 3143
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=17778 or tblfeedback.strbusinessname='Jeanette Maree Jewellery' or tblfeedback.strbusinessname='Jeanette Maree Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Luna Weddings
Bayswater VIC 3153
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=38343 or tblfeedback.strbusinessname='Luna Weddings' or tblfeedback.strbusinessname='Luna Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Julie Hebert Millinery
Orange NSW 2800
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=27584 or tblfeedback.strbusinessname='Julie Hebert Millinery' or tblfeedback.strbusinessname='Julie Hebert Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
The Photo Booth girl
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=44630 or tblfeedback.strbusinessname='The Photo Booth girl' or tblfeedback.strbusinessname='The Photo Booth girl') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Francesca Jewellery
Hobart TAS 7000
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=43082 or tblfeedback.strbusinessname='Francesca Jewellery' or tblfeedback.strbusinessname='Francesca Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Luxe bride
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=29401 or tblfeedback.strbusinessname='The Luxe bride' or tblfeedback.strbusinessname='The Luxe bride') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wild Laurel
online NSW 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=43856 or tblfeedback.strbusinessname='Wild Laurel' or tblfeedback.strbusinessname='Wild Laurel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Etsy
Australa WA 0000
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=35433 or tblfeedback.strbusinessname='Etsy' or tblfeedback.strbusinessname='Etsy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lovisa
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=27009 or tblfeedback.strbusinessname='Lovisa' or tblfeedback.strbusinessname='Lovisa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mariana Hardwick (Melbourne)
South Melbourne VIC 3205
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=271 or tblfeedback.strbusinessname='Mariana Hardwick (Melbourne)' or tblfeedback.strbusinessname='Mariana Hardwick (Melbourne)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Francesca Jewellery
Hobart TAS 7000
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=43082 or tblfeedback.strbusinessname='Francesca Jewellery' or tblfeedback.strbusinessname='Francesca Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lady's Stardust Boutique
Preston VIC 3072
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=246 or tblfeedback.strbusinessname='Lady'%%semi%%s Stardust Boutique' or tblfeedback.strbusinessname='Lady's Stardust Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Crystal Dew Millinery
Donvale VIC 3111
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=12599 or tblfeedback.strbusinessname='Crystal Dew Millinery' or tblfeedback.strbusinessname='Crystal Dew Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ines Colosimo Exclusive Millinery & Accessories
Brunswick VIC 3056
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=222 or tblfeedback.strbusinessname='Ines Colosimo Exclusive Millinery &%%semi%% Accessories' or tblfeedback.strbusinessname='Ines Colosimo Exclusive Millinery & Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Spurling Bridal Wear
Frankston VIC 3199
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=326 or tblfeedback.strbusinessname='Spurling Bridal Wear' or tblfeedback.strbusinessname='Spurling Bridal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Enchanted Bridal Accessories
Doncaster East VIC 3109
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=184 or tblfeedback.strbusinessname='Enchanted Bridal Accessories' or tblfeedback.strbusinessname='Enchanted Bridal Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sarah Conners
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=12632 or tblfeedback.strbusinessname='Sarah Conners' or tblfeedback.strbusinessname='Sarah Conners') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kris K Bridal
Heathmont VIC 3135
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=243 or tblfeedback.strbusinessname='Kris K Bridal' or tblfeedback.strbusinessname='Kris K Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Impostors
Brunswick VIC 3056
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=220 or tblfeedback.strbusinessname='Impostors' or tblfeedback.strbusinessname='Impostors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Suga
Southbank VIC 3006
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=17875 or tblfeedback.strbusinessname='Suga' or tblfeedback.strbusinessname='Suga') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bridal Room The
Aspendale VIC 3195
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=129 or tblfeedback.strbusinessname='Bridal Room The' or tblfeedback.strbusinessname='Bridal Room The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Adrienne Barrington Design
Prahran VIC 3181
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=83 or tblfeedback.strbusinessname='Adrienne Barrington Design' or tblfeedback.strbusinessname='Adrienne Barrington Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
MIA Moda Boutique
Brunswick VIC 3056
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=283 or tblfeedback.strbusinessname='MIA Moda Boutique' or tblfeedback.strbusinessname='MIA Moda Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Danceland (Aust) Pty Ltd
Prahran VIC 3181
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=164 or tblfeedback.strbusinessname='Danceland (%%semi%%Aust)%%semi%% Pty Ltd' or tblfeedback.strbusinessname='Danceland (Aust) Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lifetime Treasures
Carlton VIC 3053
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=478 or tblfeedback.strbusinessname='Lifetime Treasures' or tblfeedback.strbusinessname='Lifetime Treasures') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mowbray
Mount Eliza VIC 3930
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=12625 or tblfeedback.strbusinessname='Mowbray' or tblfeedback.strbusinessname='Mowbray') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Linda Gorringe Couture
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=256 or tblfeedback.strbusinessname='Linda Gorringe Couture' or tblfeedback.strbusinessname='Linda Gorringe Couture') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Le Diademe Headpieces
Mulgrave VIC 3170
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=248 or tblfeedback.strbusinessname='Le Diademe Headpieces' or tblfeedback.strbusinessname='Le Diademe Headpieces') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Natalina Fashions
Armadale VIC 3143
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=292 or tblfeedback.strbusinessname='Natalina Fashions' or tblfeedback.strbusinessname='Natalina Fashions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ascot Millinery
Surrey Hills North VIC 3127
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=12589 or tblfeedback.strbusinessname='Ascot Millinery' or tblfeedback.strbusinessname='Ascot Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Essential Hat The
Prahran VIC 3181
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=12600 or tblfeedback.strbusinessname='Essential Hat The' or tblfeedback.strbusinessname='Essential Hat The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Christine Walsh Millinery
Blairgowrie VIC 3942
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=12598 or tblfeedback.strbusinessname='Christine Walsh Millinery' or tblfeedback.strbusinessname='Christine Walsh Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Millinery Magic
Selby VIC 3159
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=12623 or tblfeedback.strbusinessname='Millinery Magic' or tblfeedback.strbusinessname='Millinery Magic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
M Lester Headpieces
Dandenong North VIC 3175
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=268 or tblfeedback.strbusinessname='M Lester Headpieces' or tblfeedback.strbusinessname='M Lester Headpieces') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jecal Bridal
Coburg VIC 3058
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=228 or tblfeedback.strbusinessname='Jecal Bridal' or tblfeedback.strbusinessname='Jecal Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Louise Macdonald
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=12613 or tblfeedback.strbusinessname='Louise Macdonald' or tblfeedback.strbusinessname='Louise Macdonald') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Serena Lindeman Millinery
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=12634 or tblfeedback.strbusinessname='Serena Lindeman Millinery' or tblfeedback.strbusinessname='Serena Lindeman Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jade Creations
Brunswick West VIC 3055
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=225 or tblfeedback.strbusinessname='Jade Creations' or tblfeedback.strbusinessname='Jade Creations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Adawn
Wantirna South VIC 3152
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=18190 or tblfeedback.strbusinessname='Adawn' or tblfeedback.strbusinessname='Adawn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15