1.SELECT c_car.car_id, c_act.*, c_tax.*, c_insurance.*, c_company.*, c_company_1.*, c_company_1.company_name AS com FROM c_company AS c_company_1 RIGHT JOIN (c_company RIGHT JOIN ((c_car LEFT JOIN (c_act LEFT JOIN c_tax ON c_act.act_no = c_tax.act_no) ON c_car.car_id = c_act.car_id) LEFT JOIN c_insurance ON c_car.car_id = c_insurance.car_id) ON c_company.companyid = c_act.companyid) ON c_company_1.companyid = c_insurance.companyid
2.WHERE YEAR(c_act.act_Enddate) in (2014) OR YEAR(c_tax.tax_Enddate) in (2014) OR YEAR(c_insurance.Ins_Enddate) in (2014)
