SELECT * FROM descuentos_globales WHERE date('2024-05-15 00:02:46') 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 12,6;3 Siguiente página