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
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
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
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
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
Bras 'N' Things
Bondi Junction NSW 2022
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=8338 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
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
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
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
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
Materna Moda
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=10410 or tblfeedback.strbusinessname='Materna Moda' or tblfeedback.strbusinessname='Materna Moda') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
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
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
New Look Lingerie
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=10665 or tblfeedback.strbusinessname='New Look Lingerie' or tblfeedback.strbusinessname='New Look Lingerie') 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
Glamourworld
Newtown NSW 2042
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=9465 or tblfeedback.strbusinessname='Glamourworld' or tblfeedback.strbusinessname='Glamourworld') 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
Eve's Intimate Apparel Bankstown
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=9213 or tblfeedback.strbusinessname='Eve'%%semi%%s Intimate Apparel Bankstown' or tblfeedback.strbusinessname='Eve's Intimate Apparel Bankstown') 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
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
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
Pam's Place
Gordon NSW 2072
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=10818 or tblfeedback.strbusinessname='Pam'%%semi%%s Place' or tblfeedback.strbusinessname='Pam's Place') 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
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
IM Designer Bodywear
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=9792 or tblfeedback.strbusinessname='IM Designer Bodywear' or tblfeedback.strbusinessname='IM Designer Bodywear') 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
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
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
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
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
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
Bras 'N' Things
Seven Hills NSW 2147
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=8345 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
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
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
Materna Moda-Maternity 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=10412 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
Bras 'N' Things
Leichhardt NSW 2040
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=8342 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
Pj's Bold & Beautiful Lingerie
Sutherland NSW 2232
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=11004 or tblfeedback.strbusinessname='Pj'%%semi%%s Bold &%%semi%% Beautiful Lingerie' or tblfeedback.strbusinessname='Pj's Bold & Beautiful Lingerie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lingerie Acte III
Balmain NSW 2041
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=10226 or tblfeedback.strbusinessname='Lingerie Acte III' or tblfeedback.strbusinessname='Lingerie Acte III') 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
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
Bras 'N' Things
Hornsby NSW 2077
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=8340 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
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
1 - 50 of 124 Sort search results alphabetically