You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `catalog_size_amount`.`amount` > '0' GROUP BY `catalog`.`id` ORDER BY `cat' at line 1 [ SELECT `catalog_i18n`.*, `catalog`.*, `product_prices`.`price`, `product_prices`.`price_old`, `catalog_categories`.`catalog_tree_id`, `product_prices`.`currency_id` FROM `catalog` JOIN `catalog_i18n` ON (`catalog_i18n`.`row_id` = `catalog`.`id`) JOIN `product_prices` ON (`catalog`.`id` = `product_prices`.`product_id`) LEFT JOIN `catalog_categories` ON (`catalog_categories`.`catalog_id` = `catalog`.`id`) LEFT JOIN `catalog_tree` ON (`catalog_tree`.`id` = `catalog_categories`.`catalog_tree_id`) JOIN `product_ages` ON (`catalog`.`id` = `product_ages`.`product_id`) JOIN `catalog_size_amount` ON (`catalog_size_amount`.`catalog_id` = `catalog`.`id`) WHERE `product_prices`.`price_type` = '875e4eb9-364f-11ea-80cc-a4bf01075a5b' AND `catalog`.`status` = 1 AND `catalog_i18n`.`language` = 'ru' AND `catalog_categories`.`catalog_tree_id` IN ('75', '126', '174', '176', '177', '178', '183', '184', '185', '186', '9', '165', '8', '124', '196', '197', '198', '199', '200', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '189', '191', '192', '194', '211', '213', '214', '216', '217', '218', '220', '221', '222', '223', '224', '225', '226', '227', '14', '15', '16', '17', '172', '242', '18', '19', '20', '21', '22', '228', '229', '230', '231', '232', '233', '234', '235', '236', '237', '238', '23', '24', '25', '26', '27', '28', '29', '30', '32', '33', '34', '35', '36', '37', '38', '40', '41', '163', '239', '240', '241', '243', '244', '345', '651', '1243', '42', '43', '55', '60', '61', '62', '65', '67', '68', '72', '73', '76', '77', '274', '275', '276', '277', '278', '281', '7', '44', '46', '47', '48', '49', '52', '58', '59', '69', '70', '78', '317', '318', '319', '320', '322', '323', '334', '336', '344', '45', '56', '64', '74', '311', '316', '325', '326', '327', '328', '329', '330', '331', '332', '333', '50', '53', '54', '57', '63', '71', '81', '215', '308', '309', '310', '313', '315', '321', '335', '342', '343', '86', '87', '88', '89', '171', '90', '91', '92', '93', '94', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '255', '95', '96', '97', '99', '100', '101', '102', '103', '104', '105', '106', '107', '108', '110', '164', '257', '258', '259', '339', '346', '348', '1247', '127', '129', '130', '131', '132', '314', '349', '647', '649', '133', '134', '135', '137', '114', '116', '138', '139', '260', '340', '140', '141', '142', '143', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '159', '160', '161', '162', '341', '121', '128', '136', '144', '261', '166', '168', '169', '170', '117', '120', '122', '123', '125', '180', '181') AND `catalog`.`sale` = 1 AND `product_ages`.`age_type` IN () AND `catalog_size_amount`.`amount` > '0' GROUP BY `catalog`.`id` ORDER BY `catalog`.`available` ASC ]