Consulta query dataPromo: SELECT distinct 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, ma.id_marca, mc.id_modelocarro, prom.descuento, lin.id_empresas, cat.descripcion 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 existencias AS EX ON EX.id_articulo=art.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 INNER JOIN promociones as prom ON ('2025-05-02 19:49:21' BETWEEN prom.fecha_inicio and prom.fecha_fin AND ((prom.tipo='1' AND ma.id_marca IN (prom.criterio) OR (prom.tipo='2' AND mc.id_modelocarro IN (prom.criterio)) OR (prom.tipo='3') OR (prom.tipo='4' AND lin.id_linea IN (prom.criterio)) OR (prom.tipo='5' AND lin.id_empresas IN (prom.criterio)) OR (prom.tipo='6' AND art.id_articulo IN (prom.criterio)) )) ) WHERE TRUE group by art.nombre_articulo