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
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
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
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
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
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
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
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
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
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
Jania Lingerie
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=13495 or tblfeedback.strbusinessname='Jania Lingerie' or tblfeedback.strbusinessname='Jania Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
Taylors Lakes VIC 3038
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=13426 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barley There
St Kilda 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=13406 or tblfeedback.strbusinessname='Barley There' or tblfeedback.strbusinessname='Barley There') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
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=13436 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') 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
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
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
LA Figure Lingerie
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=13502 or tblfeedback.strbusinessname='LA Figure Lingerie' or tblfeedback.strbusinessname='LA Figure Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras & Pants
Ascot Vale VIC 3032
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=13416 or tblfeedback.strbusinessname='Bras &%%semi%% Pants' or tblfeedback.strbusinessname='Bras & Pants') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cinderella's Exotic Lingerie
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=13453 or tblfeedback.strbusinessname='Cinderella'%%semi%%s Exotic Lingerie' or tblfeedback.strbusinessname='Cinderella's Exotic 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
Bras N' Things
Airport West 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=13421 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peters Lingerie & Sportswear
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=13550 or tblfeedback.strbusinessname='Peters Lingerie &%%semi%% Sportswear' or tblfeedback.strbusinessname='Peters Lingerie & Sportswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Betty Mc Dowell Lingerie
Hawthorn VIC 3122
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=13410 or tblfeedback.strbusinessname='Betty Mc Dowell Lingerie' or tblfeedback.strbusinessname='Betty Mc Dowell Lingerie') 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
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
Fiori Lingerie
Ringwood VIC 3134
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=13473 or tblfeedback.strbusinessname='Fiori Lingerie' or tblfeedback.strbusinessname='Fiori Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Figure Lingerie
Glen Waverley VIC 3150
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=13509 or tblfeedback.strbusinessname='LA Figure Lingerie' or tblfeedback.strbusinessname='LA Figure Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A World for Adults Store
Sunshine VIC 3020
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=13399 or tblfeedback.strbusinessname='A World for Adults Store' or tblfeedback.strbusinessname='A World for Adults Store') 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
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
LA Donna Lingerie
Lilydale VIC 3140
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=13501 or tblfeedback.strbusinessname='LA Donna Lingerie' or tblfeedback.strbusinessname='LA Donna Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
Greensborough VIC 3088
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=13425 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') 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
Lingerie on Bay
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=13518 or tblfeedback.strbusinessname='Lingerie on Bay' or tblfeedback.strbusinessname='Lingerie on Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Donna
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=13500 or tblfeedback.strbusinessname='LA Donna' or tblfeedback.strbusinessname='LA Donna') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nikkers Pty Ltd
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=13539 or tblfeedback.strbusinessname='Nikkers Pty Ltd' or tblfeedback.strbusinessname='Nikkers Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dickory Dock Corsetry Salon
Camberwell VIC 3124
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=171 or tblfeedback.strbusinessname='Dickory Dock Corsetry Salon' or tblfeedback.strbusinessname='Dickory Dock Corsetry Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Donnell's Lingerie
Ringwood VIC 3134
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=13545 or tblfeedback.strbusinessname='O'%%semi%%Donnell'%%semi%%s Lingerie' or tblfeedback.strbusinessname='O'Donnell's Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
House of Sleepwear The
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=13488 or tblfeedback.strbusinessname='House of Sleepwear The' or tblfeedback.strbusinessname='House of Sleepwear The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras N' Things
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=13429 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Miss Balmoral
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=13531 or tblfeedback.strbusinessname='Miss Balmoral' or tblfeedback.strbusinessname='Miss Balmoral') 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
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
Nina's Lingerie
Ivanhoe East 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=13540 or tblfeedback.strbusinessname='Nina'%%semi%%s Lingerie' or tblfeedback.strbusinessname='Nina's Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Donnell's Lingerie
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=13542 or tblfeedback.strbusinessname='O'%%semi%%Donnell'%%semi%%s Lingerie' or tblfeedback.strbusinessname='O'Donnell's Lingerie') 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
1 - 50 of 145 Sort search results alphabetically