Duplicate entry '4676' for key 'group_key'
SELECT `iProduct` FROM ( SELECT SUM( `sub_orders_products`.`iQuantity` ) AS `iQuantity`, `sub_products_variants`.`iProduct` FROM `ss13_orders_products` AS `sub_orders_products` LEFT JOIN `ss13_orders` AS `sub_orders` ON ( `sub_orders`.`iOrder` = `sub_orders_products`.`iOrder` ) LEFT JOIN `ss13_pl_products_variants` AS `sub_products_variants` USING( `iProductVariant` ) LEFT JOIN `ss13_pl_products` AS `sub_products` USING( `iProduct` ) WHERE `sub_orders`.`sLanguage` = 'pl' AND `sub_products`.`iStatus` >= 1 AND EXISTS ( SELECT 1 FROM `ss13_pl_products_pages` AS `products_pages` WHERE `sub_products`.`iProduct` = `products_pages`.`iProduct` AND `products_pages`.`iPage` IN ( '154', '72', '9', '22', '19', '153', '21', '4', '18', '35', '16', '137', '205', '135', '113', '108', '196', '203', '197', '118', '142', '152', '192', '253', '144', '125', '123', '176', '131', '132', '129', '121', '136', '120', '117', '134', '128', '119', '151', '251', '149', '191', '150', '141', '122', '112', '138', '109', '124', '126', '287', '148', '114', '110', '111', '116', '115', '130', '105', '235', '234', '216', '228', '236', '206', '221', '145', '215', '98', '237', '238', '246', '222', '289', '213', '245', '147', '223', '232', '146', '291', '209', '239', '231', '143', '288', '290', '220', '249', '241', '214', '233', '240', '259', '248', '255', '247', '243', '244', '139', '193', '242', '219', '93', '97', '100', '200', '96', '103', '101', '104', '201', '102', '189', '59', '64', '65', '58', '74', '57', '71', '73', '33', '62', '61', '70', '75', '34', '63', '67', '5', '6', '7', '8', '78', '77', '20', '32', '17', '2', '162', '163', '164', '155', '157', '159', '158', '156', '165', '166', '167', '168', '160', '161' ) LIMIT 1 ) AND `sub_products`.`TiCanBuy` >= 1 GROUP BY `sub_products_variants`.`iProduct` ) AS `sub` ORDER BY `iQuantity` DESC LIMIT 5