SELECT * FROM productos LEFT JOIN precios ON precios.cod_articulo=productos.cod_articulo where visible=1 AND aux_descuento>=30 AND precio >1 AND productos.oferta='1' ORDER BY CAST(precios.precio AS DECIMAL(10,2)) DESC LIMIT 0,6;1SELECT * FROM descuentos_globales WHERE date('2024-03-29 05:11:33') 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 0,6;3
Siguiente página