Rating
Mc Wedding Cars
Prospect TAS 7250
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=5382 or tblfeedback.strbusinessname='Mc Wedding Cars' or tblfeedback.strbusinessname='Mc Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MG Birrelli
Launceston TAS 7250
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=3514 or tblfeedback.strbusinessname='MG Birrelli' or tblfeedback.strbusinessname='MG Birrelli') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Celebrity Limousines
Launceston TAS 7250
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=3502 or tblfeedback.strbusinessname='Celebrity Limousines' or tblfeedback.strbusinessname='Celebrity Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Plaza Taxis
Evandale TAS 7212
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=3515 or tblfeedback.strbusinessname='Plaza Taxis' or tblfeedback.strbusinessname='Plaza Taxis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Purins
Port Sorell TAS 7307
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=5383 or tblfeedback.strbusinessname='Purins' or tblfeedback.strbusinessname='Purins') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
M.C. Wedding Cars
Prospect TAS 7250
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=3512 or tblfeedback.strbusinessname='M.C. Wedding Cars' or tblfeedback.strbusinessname='M.C. Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Economy Car Rentals
Launceston TAS 7250
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=3508 or tblfeedback.strbusinessname='Economy Car Rentals' or tblfeedback.strbusinessname='Economy Car Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousine Tours
Hadspen TAS 7290
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=3511 or tblfeedback.strbusinessname='Limousine Tours' or tblfeedback.strbusinessname='Limousine Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bob Mason
Deloraine TAS 7304
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=3500 or tblfeedback.strbusinessname='Bob Mason' or tblfeedback.strbusinessname='Bob Mason') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Taxi Combined Services
Launceston TAS 7250
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=3521 or tblfeedback.strbusinessname='Taxi Combined Services' or tblfeedback.strbusinessname='Taxi Combined Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
My Limousine Service
Launceston TAS 7250
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=3492 or tblfeedback.strbusinessname='My Limousine Service' or tblfeedback.strbusinessname='My Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pete's Vintage Cars
Legana TAS 7277
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=3493 or tblfeedback.strbusinessname='Pete'%%semi%%s Vintage Cars' or tblfeedback.strbusinessname='Pete's Vintage Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15