Rating
Bloomfields Fashion House
Traralgon VIC 3844
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=116 or tblfeedback.strbusinessname='Bloomfields Fashion House' or tblfeedback.strbusinessname='Bloomfields Fashion House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pitstop Menswear
Warrnambool VIC 3280
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=38549 or tblfeedback.strbusinessname='Pitstop Menswear' or tblfeedback.strbusinessname='Pitstop Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Made With Love Bridal
Varsity Lakes QLD 4227
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=26976 or tblfeedback.strbusinessname='Made With Love Bridal' or tblfeedback.strbusinessname='Made With Love Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
His & Her World
Wonthaggi VIC 3995
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=13120 or tblfeedback.strbusinessname='His &%%semi%% Her World' or tblfeedback.strbusinessname='His & Her World') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Panther's Mensland
Sale VIC 3850
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=13151 or tblfeedback.strbusinessname='Panther'%%semi%%s Mensland' or tblfeedback.strbusinessname='Panther's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stobie's Mensland
Maffra VIC 3860
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=13200 or tblfeedback.strbusinessname='Stobie'%%semi%%s Mensland' or tblfeedback.strbusinessname='Stobie's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Panther's Mensland
Moe VIC 3825
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=13148 or tblfeedback.strbusinessname='Panther'%%semi%%s Mensland' or tblfeedback.strbusinessname='Panther's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Panther's Mensland
Leongatha VIC 3953
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=13149 or tblfeedback.strbusinessname='Panther'%%semi%%s Mensland' or tblfeedback.strbusinessname='Panther's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Panther's Mensland
Morwell VIC 3840
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=13150 or tblfeedback.strbusinessname='Panther'%%semi%%s Mensland' or tblfeedback.strbusinessname='Panther's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Centre Menswear
Sale VIC 3850
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=13080 or tblfeedback.strbusinessname='Centre Menswear' or tblfeedback.strbusinessname='Centre Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Panther's Mensland
Traralgon VIC 3844
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=13152 or tblfeedback.strbusinessname='Panther'%%semi%%s Mensland' or tblfeedback.strbusinessname='Panther's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silver Bell Bridal
Bairnsdale VIC 3875
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=13191 or tblfeedback.strbusinessname='Silver Bell Bridal' or tblfeedback.strbusinessname='Silver Bell Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Modern Male Menswear
Korumburra VIC 3950
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=13142 or tblfeedback.strbusinessname='Modern Male Menswear' or tblfeedback.strbusinessname='Modern Male Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sale Bridal Boutique
Sale VIC 3850
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=319 or tblfeedback.strbusinessname='Sale Bridal Boutique' or tblfeedback.strbusinessname='Sale Bridal Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Latrobe Valley Formal Hire
Moe VIC 3825
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=13126 or tblfeedback.strbusinessname='Latrobe Valley Formal Hire' or tblfeedback.strbusinessname='Latrobe Valley Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wilkinson's Menswear
Warragul VIC 3820
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=364 or tblfeedback.strbusinessname='Wilkinson'%%semi%%s Menswear' or tblfeedback.strbusinessname='Wilkinson's Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Les Davidson Men's Wear
Traralgon VIC 3844
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=13129 or tblfeedback.strbusinessname='Les Davidson Men'%%semi%%s Wear' or tblfeedback.strbusinessname='Les Davidson Men's Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15