asd

$query = "SELECT c.id,
    c.name,
    c.inn,
    c.address,
    c.phone,
    c.email,
    c.type,
    c.account_number,
    c.bank_name,
    c.iban,
    cc.brand,
    cc.model,
    cc.vin,
    cc.plate_number,
    cc.engine_type,
    cc.year,
    cc.transmission_type
FROM
    ms_clients AS c
LEFT JOIN
    ms_clients_cars AS cc
ON
    c.id = cc.client_id
WHERE
    c.id IS NOT NULL $where
ORDER BY
    $sort $dir
$limit_str;";