AMA001SELECT p.`sku`, GROUP_CONCAT(DISTINCT paf.`submodel_id` SEPARATOR ';') AS `submodels_ids`, GROUP_CONCAT(DISTINCT paf.`submodel` SEPARATOR ';') AS `submodels`, GROUP_CONCAT(DISTINCT CONCAT(paf.`min_year`, '-', paf.`max_year`, '&', paf.`submodel`) SEPARATOR ';') AS `years_submodels`, GROUP_CONCAT(DISTINCT paf.`body_type` SEPARATOR ';') AS `bodytypes`, GROUP_CONCAT(DISTINCT paf.`short_engine` SEPARATOR ';') AS `engines`, MIN(paf.`min_year`) AS `year_min`, MAX(paf.`max_year`) AS `year_max`, GROUP_CONCAT(DISTINCT TRIM(pcp.`Position`) SEPARATOR ';') AS `positions`, IFNULL(SUM(prr.`sales`), 0) AS `old_sales`, p.`partslink_norm`, p.`partslink`, p.`price` FROM `products` p JOIN `partslink_aces_fitment_aggregated` AS paf ON paf.`partslink` = p.`partslink_norm` LEFT JOIN `ignore_products_from_bar` AS igpf ON igpf.`ignore_product_sku` = p.`sku` LEFT JOIN `products_rank` prr ON prr.`product_id` = p.`product_id` LEFT JOIN `partslink_aces_fitment_data` pf ON pf.`partslink` = paf.`partslink` LEFT JOIN `pcdb_new`.`Positions` AS pcp ON pcp.`PositionID` = pf.`position_id` WHERE p.`in_stock` = 1 AND p.`category_id` = ? AND igpf.`ignore_product_sku` IS NULL AND paf.`model_id` = 178 AND paf.`make_id` = 31 AND p.`model_id` = paf.`model_id` AND paf.min_year <= 1992 AND paf.max_year >= 1992 GROUP BY p.`sku` ORDER BY p.`partslink` ASC, p.`price` ASC