SELECT DISTINCT(cat.id_catalogo),EX.cantidad,art.precio, ma.nombre_marca,mc.nombre_modelocarro,tp.nombre_tipo,art.id_articulo, art.nombre_articulo, cil.nombre,
lit.nombre_litro, pos.nombre_posicion, mo.anio_ini, mo.anio_fin, cat.id_catalogo, lin.nombre_linea, lin.id_linea,
ma.id_marca, mc.id_modelocarro, cat.descripcion, lin.id_empresas
FROM catalogoarticulos as cat
INNER JOIN modelos as mo ON mo.id_modelo = cat.id_modelo
INNER JOIN marcatipo as mt ON mt.id_marcatipo = mo.id_marcatipo
INNER JOIN marcas as ma ON ma.id_marca=mt.id_marca
INNER JOIN tipos as tp ON tp.id_tipo = mt.id_tipo
INNER JOIN modelocarros as mc ON mc.id_modelocarro=mt.id_modelocarro
INNER JOIN articulos as art ON art.id_articulo = cat.id_articulo
INNER JOIN lineas as lin ON lin.id_linea= art.id_linea
INNER JOIN cilindrajes as cil ON cil.id_cilindraje= cat.id_cilindraje
INNER JOIN litros as lit ON lit.id_litro = cat.id_litro
INNER JOIN posiciones as pos ON pos.id_posicion=cat.id_posicion
LEFT JOIN existencias AS EX ON EX.id_articulo=art.id_articulo
WHERE TRUE fffffffffffffff
datacat
-------------Sin coincidencias