Wedding Cars Central Coast

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=2120 or tblfeedback.strbusinessname='VIP Jaguar' or tblfeedback.strbusinessname='VIP Jaguar') 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=2060 or tblfeedback.strbusinessname='Mackay Chauffeured Limousines' or tblfeedback.strbusinessname='Mackay Chauffeured Limousines') 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=2095 or tblfeedback.strbusinessname='Queensland Limousines' or tblfeedback.strbusinessname='Queensland Limousines') 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=2043 or tblfeedback.strbusinessname='Kangnarra Stage Coach' or tblfeedback.strbusinessname='Kangnarra Stage Coach') 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=2051 or tblfeedback.strbusinessname='Kylindael Enterprises' or tblfeedback.strbusinessname='Kylindael Enterprises') 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=1960 or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines' or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines') 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=1973 or tblfeedback.strbusinessname='Cinderella's Carriage' or tblfeedback.strbusinessname='Cinderella's Carriage') 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=1980 or tblfeedback.strbusinessname='Colonial Royal Mail Coaches' or tblfeedback.strbusinessname='Colonial Royal Mail Coaches') 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=17075 or tblfeedback.strbusinessname='KJ Carriages' or tblfeedback.strbusinessname='KJ Carriages') 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=17050 or tblfeedback.strbusinessname='Bundaberg Limousines' or tblfeedback.strbusinessname='Bundaberg Limousines') 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=17053 or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines' or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines') 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=17055 or tblfeedback.strbusinessname='Classic Car Rentals' or tblfeedback.strbusinessname='Classic Car Rentals') 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=17079 or tblfeedback.strbusinessname='Mackay Chauffeured Limousines' or tblfeedback.strbusinessname='Mackay Chauffeured Limousines') 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=17087 or tblfeedback.strbusinessname='Olde Time Limousines' or tblfeedback.strbusinessname='Olde Time Limousines') 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=18611 or tblfeedback.strbusinessname='Acacia Limousines' or tblfeedback.strbusinessname='Acacia Limousines') 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=18637 or tblfeedback.strbusinessname='Classic Limousines' or tblfeedback.strbusinessname='Classic Limousines') and year(getdate())-year(dtmadded)<=15