Wedding Event Managers Melbourne

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=19832 or tblfeedback.strbusinessname='Hudson's Famous' or tblfeedback.strbusinessname='Hudson's Famous') 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=17316 or tblfeedback.strbusinessname='A Perfect Day' or tblfeedback.strbusinessname='A Perfect Day') 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=23217 or tblfeedback.strbusinessname='Levian Events' or tblfeedback.strbusinessname='Levian Events') 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=26992 or tblfeedback.strbusinessname='Abracadabra Events' or tblfeedback.strbusinessname='Abracadabra Events') 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=27778 or tblfeedback.strbusinessname='Je Creative Events' or tblfeedback.strbusinessname='Je Creative Events') 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=29508 or tblfeedback.strbusinessname='DIY brides events' or tblfeedback.strbusinessname='DIY brides events') 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=36345 or tblfeedback.strbusinessname='Lets create it' or tblfeedback.strbusinessname='Lets create it') 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=17682 or tblfeedback.strbusinessname='Artistic Catering' or tblfeedback.strbusinessname='Artistic Catering') 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=535 or tblfeedback.strbusinessname='Simply Weddings And Events' or tblfeedback.strbusinessname='Simply Weddings And Events') 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=4644 or tblfeedback.strbusinessname='Wishful Weddings' or tblfeedback.strbusinessname='Wishful Weddings') 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=12778 or tblfeedback.strbusinessname='Adele Blakiston' or tblfeedback.strbusinessname='Adele Blakiston') 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=12780 or tblfeedback.strbusinessname='Complete Co-Ordinating Services' or tblfeedback.strbusinessname='Complete Co-Ordinating Services') 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=12781 or tblfeedback.strbusinessname='Create A Wedding' or tblfeedback.strbusinessname='Create A Wedding') 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=12782 or tblfeedback.strbusinessname='Current Events-Wedding Consultants' or tblfeedback.strbusinessname='Current Events-Wedding Consultants') 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=12785 or tblfeedback.strbusinessname='Events Melbourne Style' or tblfeedback.strbusinessname='Events Melbourne Style') 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=12787 or tblfeedback.strbusinessname='Functions of Distinction' or tblfeedback.strbusinessname='Functions of Distinction') 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=12789 or tblfeedback.strbusinessname='Images Wedding Co-Ordinators' or tblfeedback.strbusinessname='Images Wedding Co-Ordinators') 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=12790 or tblfeedback.strbusinessname='Inflatable Image Technologies' or tblfeedback.strbusinessname='Inflatable Image Technologies') 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=12792 or tblfeedback.strbusinessname='Le Classique Master of Ceremonies/Function Co-Ordinator' or tblfeedback.strbusinessname='Le Classique Master of Ceremonies/Function Co-Ordinator') 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=12794 or tblfeedback.strbusinessname='Melbourne Wedding Consultancy' or tblfeedback.strbusinessname='Melbourne Wedding Consultancy') 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=12796 or tblfeedback.strbusinessname='Sky Is the Limit Pty Ltd' or tblfeedback.strbusinessname='Sky Is the Limit Pty Ltd') 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=12797 or tblfeedback.strbusinessname='Unique Occasions' or tblfeedback.strbusinessname='Unique Occasions') and year(getdate())-year(dtmadded)<=15