No hay productos
MC Pinturas
Plaza del rollo, 2
28023 Aravaca - Madrid
Horario:
De Lunes a Viernes 10:30 - 14:00 y 16:30 - 19:30
Sábados de 10:30 - 14:00
Teléfono: 91 357 92 27
Para preguntas relacionadas con un pedido o para informarse sobre nuestros productos.
Si quiere encontrarnos en el mapa haga click en el icono
DISPONIBLE PARKING PÚBLICO EN:
ParkingSELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, i.`id_image`, il.`legend`, ps.`quantity` AS sales, p.`ean13`, cl.`link_rewrite` AS category FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = 3) WHERE p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) GROUP BY p.`id_product` ORDER BY sales DESC LIMIT 0, 5