Rating
Lisa's Lacies
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=17793 or tblfeedback.strbusinessname='Lisa'%%semi%%s Lacies' or tblfeedback.strbusinessname='Lisa's Lacies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Rating
Yandy
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=41285 or tblfeedback.strbusinessname='Yandy' or tblfeedback.strbusinessname='Yandy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Honey Birdette
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=27282 or tblfeedback.strbusinessname='Honey Birdette' or tblfeedback.strbusinessname='Honey Birdette') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bras n Things
Regents Park VIC 2143
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=38110 or tblfeedback.strbusinessname='Bras n Things' or tblfeedback.strbusinessname='Bras n Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Honey Birdette
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=27282 or tblfeedback.strbusinessname='Honey Birdette' or tblfeedback.strbusinessname='Honey Birdette') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bendon Lingerie
Fyshwick ACT 2609
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=25687 or tblfeedback.strbusinessname='Bendon Lingerie' or tblfeedback.strbusinessname='Bendon Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
IM Lingerie (Crown Casino)
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=27011 or tblfeedback.strbusinessname='IM Lingerie (%%semi%%Crown Casino)%%semi%%' or tblfeedback.strbusinessname='IM Lingerie (Crown Casino)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bras N Things
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=21306 or tblfeedback.strbusinessname='Bras N Things' or tblfeedback.strbusinessname='Bras N Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bras N Things
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=21306 or tblfeedback.strbusinessname='Bras N Things' or tblfeedback.strbusinessname='Bras N Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yandy
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=41285 or tblfeedback.strbusinessname='Yandy' or tblfeedback.strbusinessname='Yandy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bras n Things
Regents Park VIC 2143
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=38110 or tblfeedback.strbusinessname='Bras n Things' or tblfeedback.strbusinessname='Bras n Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bras N' Things
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=13423 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bra World
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=13415 or tblfeedback.strbusinessname='Bra World' or tblfeedback.strbusinessname='Bra World') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Camille Foundations
Hampton VIC 3188
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=13388 or tblfeedback.strbusinessname='Camille Foundations' or tblfeedback.strbusinessname='Camille Foundations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras & Pants
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=13417 or tblfeedback.strbusinessname='Bras &%%semi%% Pants' or tblfeedback.strbusinessname='Bras & Pants') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Figure Foundations
Elsternwick VIC 3185
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=13469 or tblfeedback.strbusinessname='Figure Foundations' or tblfeedback.strbusinessname='Figure Foundations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bare Elegance
Niddrie VIC 3042
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=13405 or tblfeedback.strbusinessname='Bare Elegance' or tblfeedback.strbusinessname='Bare Elegance') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nicole Lingerie
Malvern VIC 3144
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=13537 or tblfeedback.strbusinessname='Nicole Lingerie' or tblfeedback.strbusinessname='Nicole Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Night Affair
South Yarra VIC 3141
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=13538 or tblfeedback.strbusinessname='Night Affair' or tblfeedback.strbusinessname='Night Affair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Village Lingerie Pty Ltd
Mount Waverley VIC 3149
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=13577 or tblfeedback.strbusinessname='Village Lingerie Pty Ltd' or tblfeedback.strbusinessname='Village Lingerie Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botticelli Art
Richmond VIC 3121
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=13413 or tblfeedback.strbusinessname='Botticelli Art' or tblfeedback.strbusinessname='Botticelli Art') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Orchid Blue
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=297 or tblfeedback.strbusinessname='Orchid Blue' or tblfeedback.strbusinessname='Orchid Blue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
My Secret
Malvern VIC 3144
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=13535 or tblfeedback.strbusinessname='My Secret' or tblfeedback.strbusinessname='My Secret') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
Chirnside Park VIC 3116
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=13434 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vanity Australia
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=13576 or tblfeedback.strbusinessname='Vanity Australia' or tblfeedback.strbusinessname='Vanity Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Miss Behaving
Windsor 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=13532 or tblfeedback.strbusinessname='Miss Behaving' or tblfeedback.strbusinessname='Miss Behaving') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Freeline Lingerie
Murrumbeena VIC 3163
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=13481 or tblfeedback.strbusinessname='Freeline Lingerie' or tblfeedback.strbusinessname='Freeline Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
Chadstone VIC 3148
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=13430 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lavender Lace Lingerie
Dandenong 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=13512 or tblfeedback.strbusinessname='Lavender Lace Lingerie' or tblfeedback.strbusinessname='Lavender Lace Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coco Divine
Fitzroy VIC 3065
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=13455 or tblfeedback.strbusinessname='Coco Divine' or tblfeedback.strbusinessname='Coco Divine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
CE Soir
Beaumaris VIC 3193
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=13451 or tblfeedback.strbusinessname='CE Soir' or tblfeedback.strbusinessname='CE Soir') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Season's Lingerie
Cranbourne VIC 3977
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=13562 or tblfeedback.strbusinessname='Season'%%semi%%s Lingerie' or tblfeedback.strbusinessname='Season's Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Leg Essentials
Northcote VIC 3070
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=13513 or tblfeedback.strbusinessname='Leg Essentials' or tblfeedback.strbusinessname='Leg Essentials') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cotton Comfort
Richmond VIC 3121
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=13457 or tblfeedback.strbusinessname='Cotton Comfort' or tblfeedback.strbusinessname='Cotton Comfort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Figure Lingerie
Hawthorn East VIC 3123
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=13507 or tblfeedback.strbusinessname='LA Figure Lingerie' or tblfeedback.strbusinessname='LA Figure Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
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=13438 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Scandal
South Yarra VIC 3141
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=13561 or tblfeedback.strbusinessname='Scandal' or tblfeedback.strbusinessname='Scandal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rosies Lingerie
Sorrento VIC 3943
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=13560 or tblfeedback.strbusinessname='Rosies Lingerie' or tblfeedback.strbusinessname='Rosies Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Happy Bodies
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=13392 or tblfeedback.strbusinessname='Happy Bodies' or tblfeedback.strbusinessname='Happy Bodies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shagmore
St Kilda South VIC 3182
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=13563 or tblfeedback.strbusinessname='Shagmore' or tblfeedback.strbusinessname='Shagmore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cass Helen Lingerie
Balwyn VIC 3103
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=13449 or tblfeedback.strbusinessname='Cass Helen Lingerie' or tblfeedback.strbusinessname='Cass Helen Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Figure Lingerie
Oakleigh VIC 3166
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=13503 or tblfeedback.strbusinessname='LA Figure Lingerie' or tblfeedback.strbusinessname='LA Figure Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Figure Lingerie
Mooroolbark VIC 3138
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=13506 or tblfeedback.strbusinessname='LA Figure Lingerie' or tblfeedback.strbusinessname='LA Figure Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Top Drawer Lingerie & Corsetry Boutique
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=13571 or tblfeedback.strbusinessname='Top Drawer Lingerie &%%semi%% Corsetry Boutique' or tblfeedback.strbusinessname='Top Drawer Lingerie & Corsetry Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Simply Feminine
Ivanhoe VIC 3079
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=13567 or tblfeedback.strbusinessname='Simply Feminine' or tblfeedback.strbusinessname='Simply Feminine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coco Divine
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=13454 or tblfeedback.strbusinessname='Coco Divine' or tblfeedback.strbusinessname='Coco Divine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
L'Amour Cherie
Brighton VIC 3186
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=13511 or tblfeedback.strbusinessname='L'%%semi%%Amour Cherie' or tblfeedback.strbusinessname='L'Amour Cherie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lingerie Direct
Brunswick East VIC 3057
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=13516 or tblfeedback.strbusinessname='Lingerie Direct' or tblfeedback.strbusinessname='Lingerie Direct') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Melbourne Sock Shop
Toorak VIC 3142
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=13528 or tblfeedback.strbusinessname='Melbourne Sock Shop' or tblfeedback.strbusinessname='Melbourne Sock Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silk & Lace Lingerie
Caulfield South VIC 3162
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=13566 or tblfeedback.strbusinessname='Silk &%%semi%% Lace Lingerie' or tblfeedback.strbusinessname='Silk & Lace Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 145 Sort search results alphabetically