SELECT temp.*, filters.name as filter_name, GROUP_CONCAT(DISTINCT criteria.value) as filter_values FROM ( SELECT priceitems.id, priceitems.part_id, priceitems.price*currencies.ratio as price_start, parts.article_long, parts.article, parts.brand, parts.brand_long, parts.images, parts.`name`, priceitems.price * currencies.ratio * (SELECT discount_limits.percentage / 100 + 1 FROM discount_limits LEFT JOIN discounts ON discount_limits.discount_id = discounts.id WHERE discounts.standart = 1 AND priceitems.price * currencies.ratio > discount_limits.from AND (priceitems.price * currencies.ratio <= discount_limits.to OR discount_limits.to = 0) LIMIT 1) AS price_final, priceitems.delivery FROM priceitems LEFT JOIN currencies ON currencies.id = priceitems.currency_id LEFT JOIN suppliers ON suppliers.id = priceitems.supplier_id INNER JOIN parts ON parts.id = part_id LEFT JOIN group_parts ON priceitems.part_id = group_parts.part_id LEFT JOIN type_category_group ON group_parts.group_id = type_category_group.id INNER JOIN own_models ON type_category_group.type_id = own_models.tecdoc_id INNER JOIN own_manufactures ON own_models.tecdoc_manufacture_id = own_manufactures.tecdoc_id WHERE type_category_group.category_id = 613 AND own_models.active = 1 AND own_models.url = 'a6' AND own_manufactures.url = 'audi' AND suppliers.dont_show = 0 ORDER BY priceitems.part_id, IF(priceitems.delivery = 1, priceitems.delivery, price_final), IF(priceitems.delivery = 1, price_final, priceitems.delivery) ) AS temp LEFT JOIN filters_to_parts ON temp.part_id = filters_to_parts.part_id LEFT JOIN filters ON filters_to_parts.filter_id = filters.id LEFT JOIN criteria ON filters_to_parts.criteria_id = criteria.id GROUP BY temp.part_id