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
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
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
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
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
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
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
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
Dicksons Mensland
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=172 or tblfeedback.strbusinessname='Dicksons Mensland' or tblfeedback.strbusinessname='Dicksons 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
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
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
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
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
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
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
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