SELECT mc.number,mc.dateTo,td.cai_title,td.cai_title,td.model_title,td.index_title,td.size_title,td.brand_title FROM michelin_certificate mc LEFT JOIN certificate_cais cc ON mc.id = cc.certificate_id LEFT JOIN tyre_data td ON td.cai_id = cc.cai_id;