SELECT SQL_CALC_FOUND_ROWS c.`entreprise`, m.`marque`,v.`modele`, v.`annee`, v.`vehicule_id`, c.`photo_name`, c.`client_id`, v.`odometre`, v.`prix`
FROM `marques` m, `vehicules` v, `clients` c
WHERE v.`client_id` = c.`client_id`
WHERE v.`client_id` = c.`client_id`
AND v.`marque_id` = m.`marque_id` 
AND m.`marque`<>"" 
AND m.`marque`<>"0" 
AND v.`active`="1" 
AND c.`active`="1" 
AND c.`is_concessionaire` = 1 
AND m.`marque`="jeep" 
ORDER BY c.`entreprise`, m.`marque` 
LIMIT 0, 20