Wedding Formal Wear and Hire Sydney

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=25308 or tblfeedback.strbusinessname='The Wedding Shoppe' or tblfeedback.strbusinessname='The Wedding Shoppe') and year(getdate())-year(dtmadded)<=15

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=29750 or tblfeedback.strbusinessname='Beautiful Brides' or tblfeedback.strbusinessname='Beautiful Brides') and year(getdate())-year(dtmadded)<=15

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=11218 or tblfeedback.strbusinessname='Ron Bennett' or tblfeedback.strbusinessname='Ron Bennett') and year(getdate())-year(dtmadded)<=15

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=1547 or tblfeedback.strbusinessname='Hugs for Brides' or tblfeedback.strbusinessname='Hugs for Brides') and year(getdate())-year(dtmadded)<=15

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=24906 or tblfeedback.strbusinessname='Sweethearts Bridal Boutique' or tblfeedback.strbusinessname='Sweethearts Bridal Boutique') and year(getdate())-year(dtmadded)<=15

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=26531 or tblfeedback.strbusinessname='Bargo Party Hire' or tblfeedback.strbusinessname='Bargo Party Hire') and year(getdate())-year(dtmadded)<=15

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 year(getdate())-year(dtmadded)<=15

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 year(getdate())-year(dtmadded)<=15

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=1253 or tblfeedback.strbusinessname='Millani Bridal Boutique' or tblfeedback.strbusinessname='Millani Bridal Boutique') and year(getdate())-year(dtmadded)<=15

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=1546 or tblfeedback.strbusinessname='Helene Esdaile' or tblfeedback.strbusinessname='Helene Esdaile') and year(getdate())-year(dtmadded)<=15

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=1556 or tblfeedback.strbusinessname='Pamela's House of Dreams' or tblfeedback.strbusinessname='Pamela's House of Dreams') and year(getdate())-year(dtmadded)<=15

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=1557 or tblfeedback.strbusinessname='Park Avenue' or tblfeedback.strbusinessname='Park Avenue') and year(getdate())-year(dtmadded)<=15

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=1567 or tblfeedback.strbusinessname='Australis Bridal & After Five' or tblfeedback.strbusinessname='Australis Bridal & After Five') and year(getdate())-year(dtmadded)<=15

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=1602 or tblfeedback.strbusinessname='Baymen Menswear' or tblfeedback.strbusinessname='Baymen Menswear') and year(getdate())-year(dtmadded)<=15

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=1608 or tblfeedback.strbusinessname='Bridal & Formal House of Fashion' or tblfeedback.strbusinessname='Bridal & Formal House of Fashion') and year(getdate())-year(dtmadded)<=15

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=1657 or tblfeedback.strbusinessname='Classics Formal Wear' or tblfeedback.strbusinessname='Classics Formal Wear') and year(getdate())-year(dtmadded)<=15

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=1658 or tblfeedback.strbusinessname='Classics Formal Wear' or tblfeedback.strbusinessname='Classics Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11233 or tblfeedback.strbusinessname='Rosemont Big Night Out Formal Hire' or tblfeedback.strbusinessname='Rosemont Big Night Out Formal Hire') and year(getdate())-year(dtmadded)<=15

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=11234 or tblfeedback.strbusinessname='Rosemont Formal Hire' or tblfeedback.strbusinessname='Rosemont Formal Hire') and year(getdate())-year(dtmadded)<=15

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=11502 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11503 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11504 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11505 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11506 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11507 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11508 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11509 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=11510 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15

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=17397 or tblfeedback.strbusinessname='Formal Wear Express' or tblfeedback.strbusinessname='Formal Wear Express') and year(getdate())-year(dtmadded)<=15

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=11593 or tblfeedback.strbusinessname='Suit Hire-Man About Town' or tblfeedback.strbusinessname='Suit Hire-Man About Town') and year(getdate())-year(dtmadded)<=15

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=18473 or tblfeedback.strbusinessname='Bridal Collections, Formal Wear and Hire' or tblfeedback.strbusinessname='Bridal Collections, Formal Wear and Hire') and year(getdate())-year(dtmadded)<=15

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=18476 or tblfeedback.strbusinessname='Ferrari Formal Wear' or tblfeedback.strbusinessname='Ferrari Formal Wear') and year(getdate())-year(dtmadded)<=15

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=18478 or tblfeedback.strbusinessname='Harts' or tblfeedback.strbusinessname='Harts') and year(getdate())-year(dtmadded)<=15

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=18480 or tblfeedback.strbusinessname='M&S suit city' or tblfeedback.strbusinessname='M&S suit city') and year(getdate())-year(dtmadded)<=15

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=1844 or tblfeedback.strbusinessname='Greys Formal Wear' or tblfeedback.strbusinessname='Greys Formal Wear') and year(getdate())-year(dtmadded)<=15