Carrito  

(vacío)

Contactar con nosotr@s

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:

Parking

Enviar un mensaje

 



Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mc_pinturas.i.id_image' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

		SELECT 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