[PrestaShopDatabaseException]

Unknown column 'product_shop.id_image' in 'group statement'

SELECT DISTINCT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`link_rewrite`, pl.`name`,
					MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, 1 position,
					DATEDIFF(
						p.`date_add`,
						DATE_SUB(
							NOW(),
							INTERVAL 1000 DAY
						)
					) > 0 new
				FROM `ps_product` p
				INNER JOIN `ps_product_lang` pl ON (
					p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = 1 AND pl.id_shop = 1 
				)
				 LEFT JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
				LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)		
				LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
				LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
				LEFT JOIN `ps_product_tag` pt ON (p.`id_product` = pt.`id_product`)
				LEFT JOIN `ps_tag` t ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = 1)
				LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`)
				LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`)
				LEFT JOIN `ps_category_shop` cs ON (cg.`id_category` = cs.`id_category` AND cs.`id_shop` = 1)
				 LEFT 
			JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  )
				WHERE product_shop.`active` = 1
					AND cs.`id_shop` = 1
					AND cg.`id_group` = 1
					AND t.`name` LIKE '%granit%'
					GROUP BY product_shop.id_image
				ORDER BY position DESC
				LIMIT 0,30

at line 607 in file classes/db/Db.php

601. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
602. 		}
603. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
604. 		{
605. 			if ($sql)
606. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
607. 			throw new PrestaShopDatabaseException($this->getMsgError());
608. 		}
609. 	}
610. 
611. 	/**