Wedding Beauticians 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=28994 or tblfeedback.strbusinessname='The Glamour Mafia' or tblfeedback.strbusinessname='The Glamour Mafia') 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=28995 or tblfeedback.strbusinessname='Glamourfied by Lizi Hance' or tblfeedback.strbusinessname='Glamourfied by Lizi Hance') 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=29709 or tblfeedback.strbusinessname='BethMacMakeupArtistry' or tblfeedback.strbusinessname='BethMacMakeupArtistry') 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=26568 or tblfeedback.strbusinessname='Gabrielle Makeup Artistry' or tblfeedback.strbusinessname='Gabrielle Makeup Artistry') 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=26581 or tblfeedback.strbusinessname='Flawless Hair and Make Up' or tblfeedback.strbusinessname='Flawless Hair and Make Up') 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=27085 or tblfeedback.strbusinessname='Cosmetique Makeup' or tblfeedback.strbusinessname='Cosmetique Makeup') 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=27709 or tblfeedback.strbusinessname='Beauty By Julie (BBJ)' or tblfeedback.strbusinessname='Beauty By Julie (BBJ)') 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=29186 or tblfeedback.strbusinessname='Ebony Maize Makeup' or tblfeedback.strbusinessname='Ebony Maize Makeup') 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=17738 or tblfeedback.strbusinessname='Envy Day Spa' or tblfeedback.strbusinessname='Envy Day Spa') 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=17800 or tblfeedback.strbusinessname='Make Me up' or tblfeedback.strbusinessname='Make Me up') 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=17816 or tblfeedback.strbusinessname='Nikki's Day Spa' or tblfeedback.strbusinessname='Nikki's Day Spa') 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=17869 or tblfeedback.strbusinessname='Stefan Beauty Therapy' or tblfeedback.strbusinessname='Stefan Beauty Therapy') 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=17976 or tblfeedback.strbusinessname='Envy Day Spa' or tblfeedback.strbusinessname='Envy Day Spa') 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=834 or tblfeedback.strbusinessname='Make ME Over' or tblfeedback.strbusinessname='Make ME Over') 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=354 or tblfeedback.strbusinessname='Vanity Bridal Salon' or tblfeedback.strbusinessname='Vanity Bridal Salon') 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=4628 or tblfeedback.strbusinessname='Sundeck' or tblfeedback.strbusinessname='Sundeck') 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=12646 or tblfeedback.strbusinessname='Joveneh Beauty Salon' or tblfeedback.strbusinessname='Joveneh Beauty Salon') and year(getdate())-year(dtmadded)<=15