Rating
Rays Private Hire Cars
Casuarina NT 0810
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=4790 or tblfeedback.strbusinessname='Rays Private Hire Cars' or tblfeedback.strbusinessname='Rays Private Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian National Limousines
Darwin NT 0800
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=4783 or tblfeedback.strbusinessname='Australian National Limousines' or tblfeedback.strbusinessname='Australian National Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mollybloom's Luxury Car Service
Darwin NT 0800
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=4788 or tblfeedback.strbusinessname='Mollybloom'%%semi%%s Luxury Car Service' or tblfeedback.strbusinessname='Mollybloom's Luxury Car Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Presidential Limousine Services
Casuarina NT 0810
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=4789 or tblfeedback.strbusinessname='Presidential Limousine Services' or tblfeedback.strbusinessname='Presidential Limousine Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colemans Printing Pty Ltd
Darwin NT 0800
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=4785 or tblfeedback.strbusinessname='Colemans Printing Pty Ltd' or tblfeedback.strbusinessname='Colemans Printing Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jaygee Limousines
Parap NT 0820
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=4786 or tblfeedback.strbusinessname='Jaygee Limousines' or tblfeedback.strbusinessname='Jaygee Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Delta Car Hire
Darwin NT 0801
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=19089 or tblfeedback.strbusinessname='Delta Car Hire' or tblfeedback.strbusinessname='Delta Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AAA Private Hire Car
Darwin NT 0800
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=4782 or tblfeedback.strbusinessname='AAA Private Hire Car' or tblfeedback.strbusinessname='AAA Private Hire Car') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
C Bresson's Luxury Car Hire
Parap NT 0820
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=4784 or tblfeedback.strbusinessname='C Bresson'%%semi%%s Luxury Car Hire' or tblfeedback.strbusinessname='C Bresson's Luxury Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15