• Inicio

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