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
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
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
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
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
Wolford
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=12071 or tblfeedback.strbusinessname='Wolford' or tblfeedback.strbusinessname='Wolford') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Olivia's Secret
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=10773 or tblfeedback.strbusinessname='Olivia'%%semi%%s Secret' or tblfeedback.strbusinessname='Olivia's Secret') 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
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
Hats & Lingerie International
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=9634 or tblfeedback.strbusinessname='Hats &%%semi%% Lingerie International' or tblfeedback.strbusinessname='Hats & Lingerie International') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
In-Wear
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=9834 or tblfeedback.strbusinessname='In-Wear' or tblfeedback.strbusinessname='In-Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DC Silvia International Pty Ltd
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=8953 or tblfeedback.strbusinessname='DC Silvia International Pty Ltd' or tblfeedback.strbusinessname='DC Silvia International Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elleran Lingerie
St Ives NSW 2075
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=9158 or tblfeedback.strbusinessname='Elleran Lingerie' or tblfeedback.strbusinessname='Elleran Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pandora's Secret Treasures
Oatley NSW 2223
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=10822 or tblfeedback.strbusinessname='Pandora'%%semi%%s Secret Treasures' or tblfeedback.strbusinessname='Pandora's Secret Treasures') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Chatswood NSW 2067
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=8339 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
Liverpool NSW 2170
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=8325 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
Zodee Pty Ltd
Willoughby NSW 2068
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=12133 or tblfeedback.strbusinessname='Zodee Pty Ltd' or tblfeedback.strbusinessname='Zodee Pty Ltd') 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
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
Jeanelle of Five Dock
Five Dock NSW 2046
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=9900 or tblfeedback.strbusinessname='Jeanelle of Five Dock' or tblfeedback.strbusinessname='Jeanelle of Five Dock') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Undercover Wear
Baulkham Hills NSW 2153
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=18591 or tblfeedback.strbusinessname='Undercover Wear' or tblfeedback.strbusinessname='Undercover Wear') 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
Lewis A Collins
Surry Hills NSW 2010
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=10204 or tblfeedback.strbusinessname='Lewis A Collins' or tblfeedback.strbusinessname='Lewis A Collins') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lolita Lingerie 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=10264 or tblfeedback.strbusinessname='Lolita Lingerie Pty Ltd' or tblfeedback.strbusinessname='Lolita Lingerie Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Ryde NSW 2112
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=8351 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 Lingerie
Darling Harbour 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=8799 or tblfeedback.strbusinessname='Coucher Lingerie' or tblfeedback.strbusinessname='Coucher Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lin & Barrett Lingerie
Broadway NSW 2007
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=10216 or tblfeedback.strbusinessname='Lin &%%semi%% Barrett Lingerie' or tblfeedback.strbusinessname='Lin & Barrett Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bras 'N' Things
Roselands NSW 2196
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=8347 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
It's Just for You
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=9847 or tblfeedback.strbusinessname='It'%%semi%%s Just for You' or tblfeedback.strbusinessname='It's Just for You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Covergirl Lingerie
Earlwood NSW 2206
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=8821 or tblfeedback.strbusinessname='Covergirl Lingerie' or tblfeedback.strbusinessname='Covergirl 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
Simone's Story Lingerie
Mona Vale NSW 2103
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=11413 or tblfeedback.strbusinessname='Simone'%%semi%%s Story Lingerie' or tblfeedback.strbusinessname='Simone's Story Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jaye M Underfashions
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=9891 or tblfeedback.strbusinessname='Jaye M Underfashions' or tblfeedback.strbusinessname='Jaye M Underfashions') 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
Bras 'N' Things
Bankstown NSW 2200
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=8349 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
DC Silvia International Pty Ltd
Hurstville NSW 2220
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=8951 or tblfeedback.strbusinessname='DC Silvia International Pty Ltd' or tblfeedback.strbusinessname='DC Silvia International Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elegance In Lingerie
Winston Hills NSW 2153
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=9133 or tblfeedback.strbusinessname='Elegance In Lingerie' or tblfeedback.strbusinessname='Elegance In Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wild Orchid
Mosman NSW 2088
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=12046 or tblfeedback.strbusinessname='Wild Orchid' or tblfeedback.strbusinessname='Wild Orchid') 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
Debra's
Wentworthville NSW 2145
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=1799 or tblfeedback.strbusinessname='Debra'%%semi%%s' or tblfeedback.strbusinessname='Debra's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Exquizite Bodywear
Ashfield NSW 2131
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=1820 or tblfeedback.strbusinessname='Exquizite Bodywear' or tblfeedback.strbusinessname='Exquizite Bodywear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hide & Seek Lingerie Boutique
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=9689 or tblfeedback.strbusinessname='Hide &%%semi%% Seek Lingerie Boutique' or tblfeedback.strbusinessname='Hide & Seek Lingerie Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kiss ME Lingerie
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=10091 or tblfeedback.strbusinessname='Kiss ME Lingerie' or tblfeedback.strbusinessname='Kiss ME Lingerie') 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
Materna Moda-Maternity 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=10413 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
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
1 - 50 of 124 Sort search results alphabetically