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
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
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
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
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
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
Naughty & Nice
Kogarah Bay NSW 2217
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=10634 or tblfeedback.strbusinessname='Naughty &%%semi%% Nice' or tblfeedback.strbusinessname='Naughty & Nice') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Pagewood NSW 2035
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=8337 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Margg's Collection Plus
Blacktown NSW 2148
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=1531 or tblfeedback.strbusinessname='Margg'%%semi%%s Collection Plus' or tblfeedback.strbusinessname='Margg's Collection Plus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ann Summers
Parramatta NSW 2150
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=7857 or tblfeedback.strbusinessname='Ann Summers' or tblfeedback.strbusinessname='Ann Summers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Designer Lingerie Parties
Woollahra NSW 2025
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=8996 or tblfeedback.strbusinessname='Designer Lingerie Parties' or tblfeedback.strbusinessname='Designer Lingerie Parties') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Miranda NSW 2228
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=8341 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Noregrets
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=10711 or tblfeedback.strbusinessname='Noregrets' or tblfeedback.strbusinessname='Noregrets') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wolford
Double Bay NSW 2028
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=12072 or tblfeedback.strbusinessname='Wolford' or tblfeedback.strbusinessname='Wolford') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mirror Mirror Beauty & Lingerie
Merrylands NSW 2160
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=10518 or tblfeedback.strbusinessname='Mirror Mirror Beauty &%%semi%% Lingerie' or tblfeedback.strbusinessname='Mirror Mirror Beauty & Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
North Ryde NSW 2113
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=8350 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coucher Lingerei Gifts & Accessories
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=8798 or tblfeedback.strbusinessname='Coucher Lingerei Gifts &%%semi%% Accessories' or tblfeedback.strbusinessname='Coucher Lingerei Gifts & Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Laced With Elegance
Cherrybrook NSW 2126
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=10138 or tblfeedback.strbusinessname='Laced With Elegance' or tblfeedback.strbusinessname='Laced With Elegance') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
White Ivy Pty Ltd
Double Bay NSW 2028
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=12031 or tblfeedback.strbusinessname='White Ivy Pty Ltd' or tblfeedback.strbusinessname='White Ivy Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Good Yarn
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=7656 or tblfeedback.strbusinessname='A Good Yarn' or tblfeedback.strbusinessname='A Good Yarn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Perle's Lingerie
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=10915 or tblfeedback.strbusinessname='Perle'%%semi%%s Lingerie' or tblfeedback.strbusinessname='Perle's Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Blacktown NSW 2148
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=8352 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Good In Bed
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=9493 or tblfeedback.strbusinessname='Good In Bed' or tblfeedback.strbusinessname='Good In Bed') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Simply Lingerie
Fairfield NSW 2165
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=11417 or tblfeedback.strbusinessname='Simply Lingerie' or tblfeedback.strbusinessname='Simply Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hetty Belle Lingerie
Avalon Beach NSW 2107
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=9686 or tblfeedback.strbusinessname='Hetty Belle Lingerie' or tblfeedback.strbusinessname='Hetty Belle Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Parramatta NSW 2150
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=8346 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sock Drawer
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=11446 or tblfeedback.strbusinessname='Sock Drawer' or tblfeedback.strbusinessname='Sock Drawer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fine & Fit Lingerie
Neutral Bay 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=9277 or tblfeedback.strbusinessname='Fine &%%semi%% Fit Lingerie' or tblfeedback.strbusinessname='Fine & Fit Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ruby's Lingerie
Campsie NSW 2194
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=11258 or tblfeedback.strbusinessname='Ruby'%%semi%%s Lingerie' or tblfeedback.strbusinessname='Ruby's Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Brookvale NSW 2100
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=8355 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Milperra NSW 2214
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=8348 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bra-Vado
Kogarah NSW 2217
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=8361 or tblfeedback.strbusinessname='Bra-Vado' or tblfeedback.strbusinessname='Bra-Vado') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lin & Barrett Lingerie
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=10219 or tblfeedback.strbusinessname='Lin &%%semi%% Barrett Lingerie' or tblfeedback.strbusinessname='Lin & Barrett Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sheila's Lingerie
Rose Bay NSW 2029
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=11368 or tblfeedback.strbusinessname='Sheila'%%semi%%s Lingerie' or tblfeedback.strbusinessname='Sheila's Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Naked Truth Lingerie
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=10620 or tblfeedback.strbusinessname='Naked Truth Lingerie' or tblfeedback.strbusinessname='Naked Truth Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Materna Moda-Maternity Lingerie
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=10411 or tblfeedback.strbusinessname='Materna Moda-Maternity Lingerie' or tblfeedback.strbusinessname='Materna Moda-Maternity Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Warriewood Lingerie
Warriewood NSW 2102
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=11954 or tblfeedback.strbusinessname='Warriewood Lingerie' or tblfeedback.strbusinessname='Warriewood Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jenny C'S Lingerie
Cronulla NSW 2230
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=9921 or tblfeedback.strbusinessname='Jenny C'%%semi%%S Lingerie' or tblfeedback.strbusinessname='Jenny C'S Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sock Shop Australia
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=11449 or tblfeedback.strbusinessname='Sock Shop Australia' or tblfeedback.strbusinessname='Sock Shop Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Yuge Co
Fairfield NSW 2165
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=12125 or tblfeedback.strbusinessname='Yuge Co' or tblfeedback.strbusinessname='Yuge Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Castle Hill Boutique
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=8555 or tblfeedback.strbusinessname='Castle Hill Boutique' or tblfeedback.strbusinessname='Castle Hill Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accessories by Touche 2000
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=1582 or tblfeedback.strbusinessname='Accessories by Touche 2000' or tblfeedback.strbusinessname='Accessories by Touche 2000') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lin & Barrett Lingerie
Burwood NSW 2134
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=10217 or tblfeedback.strbusinessname='Lin &%%semi%% Barrett Lingerie' or tblfeedback.strbusinessname='Lin & Barrett Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Savanah Lingerie
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=11307 or tblfeedback.strbusinessname='Savanah Lingerie' or tblfeedback.strbusinessname='Savanah Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peppers Lingerie
Neutral Bay 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=10904 or tblfeedback.strbusinessname='Peppers Lingerie' or tblfeedback.strbusinessname='Peppers Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Carlingford NSW 2118
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=8353 or tblfeedback.strbusinessname='Bras '%%semi%%N'%%semi%% Things' or tblfeedback.strbusinessname='Bras 'N' Things') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sylvia Rhodes Lingerie
Double Bay NSW 2028
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=11664 or tblfeedback.strbusinessname='Sylvia Rhodes Lingerie' or tblfeedback.strbusinessname='Sylvia Rhodes Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 124 Sort search results alphabetically