SELECT DISTINCT(p.products_id) from products as p JOIN manufacturers as m ON p.marca=m.manufacturers_id JOIN categorias as c ON c.categories_id=p.categoria JOIN stocks as s ON s.products_id=p.products_id WHERE s.stock>0 AND p.online=1 AND p.thumb!='' AND p.precio_ini>0 AND p.precio_ini<10000 AND ( p.codigo='genova' OR p.nombre LIKE '%genova%' OR m.manufacturers_name LIKE '%genova%' OR c.categories_name LIKE '%genova%' )
Search en Yellow Shop.
SHIPPINGS EN 24H Y RETURNS GRATIS
STORES
0
CART
YellowShop
0
CART
Filtrar Resultados
No se han encontrado resultados
YELLOWSHOP
SUSCRIBE TO NEWSLETTER
GO!
I agree the Términos y condiciones and the Privacy Policy de yellowshop.es
FOLLOW US
BUYING CONDITIONS
CONTACT
+34 973 94 98 39
L-V 9 a 13h y 16 a 19h
DOWNLOAD APP
© 2018 YELLOW SHOP. All rights reserved.