****************
SELECT P.id,P.modelo,P.pvp,P.descuento_tienda,I.img_pr,( P.pvp - (P.pvp * (P.descuento_tienda / 100) ) + ( P.pvp - (P.pvp * (P.descuento_tienda / 100) ) ) * 0.21 ) as precio_filtro ,P.activo FROM productos AS P ,pr_site2prod as S2P ,pr_imagenes AS I ,pr_categorias as C WHERE P.id > 0 AND P.activo = 1 AND S2P.idprod = P.id AND S2P.idsite = 1 AND I.idimg = P.portada AND P.idcat = C.idcat AND P.idcat IN (96, 97, 98, 99, 100, 101, 102, 103, 104, 244, 256, 277, 113, 114, 115, 116, 117, 118, 119, 120, 197, 121, 122, 123, 124, 252, 180, 181, 183, 187, 198, 199, 200, 201, 202, 203, 204, 205, 206, 253, 207, 208, 209, 210, 211, 212, 213, 217, 218, 254, 255, 369, 184, 185, 186, 191, 192, 193, 281) AND P.portada = I.idimg ORDER BY C.idcat ASC, P.orden ASC LIMIT 500 OFFSET 0
****************


Sitio oficial de Varlion
Inicio > Pádel