SELECT DISTINCT cil.id_cilindraje as id, cil.nombre as nom, lit.id_litro as id_lit, lit.nombre_litro as nom_lit 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 WHERE ('' BETWEEN mo.anio_ini AND mo.anio_fin) AND ma.id_marca = ''AND mc.id_modelocarro = '' ORDER BY cil.nombre ASC