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
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
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
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
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
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
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
Bras N' Things
Broadmeadows VIC 3047
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=13418 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') 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
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
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
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
LA Figure 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=13505 or tblfeedback.strbusinessname='LA Figure Lingerie' or tblfeedback.strbusinessname='LA Figure Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lingerie Direct
Brunswick 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=4672 or tblfeedback.strbusinessname='Lingerie Direct' or tblfeedback.strbusinessname='Lingerie Direct') 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
Bras N' Things
Keysborough VIC 3173
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=13433 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Donnell's Lingerie
Forest Hill VIC 3131
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=13546 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
Dawn Thornton Lingerie
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=13460 or tblfeedback.strbusinessname='Dawn Thornton Lingerie' or tblfeedback.strbusinessname='Dawn Thornton Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Petticoat Junction
Eltham VIC 3095
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=13551 or tblfeedback.strbusinessname='Petticoat Junction' or tblfeedback.strbusinessname='Petticoat Junction') 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
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
Just Peachie
Mornington VIC 3931
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=13499 or tblfeedback.strbusinessname='Just Peachie' or tblfeedback.strbusinessname='Just Peachie') 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
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
Fleurs Lingerie
Heidelberg VIC 3084
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=13477 or tblfeedback.strbusinessname='Fleurs Lingerie' or tblfeedback.strbusinessname='Fleurs Lingerie') 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
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
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
Medici Clothing
Essendon VIC 3040
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=13525 or tblfeedback.strbusinessname='Medici Clothing' or tblfeedback.strbusinessname='Medici Clothing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diamond Cut Factory Outlet
Fairfield VIC 3078
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=13464 or tblfeedback.strbusinessname='Diamond Cut Factory Outlet' or tblfeedback.strbusinessname='Diamond Cut Factory Outlet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brazzies
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=13447 or tblfeedback.strbusinessname='Brazzies' or tblfeedback.strbusinessname='Brazzies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Femmeline
Croydon VIC 3136
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=13391 or tblfeedback.strbusinessname='Femmeline' or tblfeedback.strbusinessname='Femmeline') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Linda Leigh-Peter's
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=13394 or tblfeedback.strbusinessname='Linda Leigh-Peter'%%semi%%s' or tblfeedback.strbusinessname='Linda Leigh-Peter's') 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
Bra Shop 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=13414 or tblfeedback.strbusinessname='Bra Shop The' or tblfeedback.strbusinessname='Bra Shop The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Poly Lingerie & Hosiery
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=13555 or tblfeedback.strbusinessname='Poly Lingerie &%%semi%% Hosiery' or tblfeedback.strbusinessname='Poly Lingerie & Hosiery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pampering People (Victoria) The
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=13549 or tblfeedback.strbusinessname='Pampering People (%%semi%%Victoria)%%semi%% The' or tblfeedback.strbusinessname='Pampering People (Victoria) The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Illusion Lingerie
Moonee Ponds VIC 3039
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=13490 or tblfeedback.strbusinessname='Illusion Lingerie' or tblfeedback.strbusinessname='Illusion Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cupids Lingerie Boutique
Carnegie 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=13458 or tblfeedback.strbusinessname='Cupids Lingerie Boutique' or tblfeedback.strbusinessname='Cupids Lingerie Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Emistic Lingerie
Moorabbin VIC 3189
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=13467 or tblfeedback.strbusinessname='Emistic Lingerie' or tblfeedback.strbusinessname='Emistic Lingerie') 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
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
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
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=13432 or tblfeedback.strbusinessname='Bras N'%%semi%% Things' or tblfeedback.strbusinessname='Bras N' Things') 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
1 - 50 of 145 Sort search results alphabetically