SELECT * FROM descuentos_globales WHERE date('2024-04-29 02:58:24') BETWEEN date(fecha_inicio) AND date(fecha_fin) AND cod_restriccion='0' AND descuento>=30 AND cod_articulo in (SELECT cod_articulo from productos where visible='1') AND cod_articulo_real in ( SELECT cod_articulo FROM stock WHERE stock >=1) ORDER BY orden LIMIT 6,6;3
Siguiente página