SELECT SQL_CALC_FOUND_ROWS product.ean, product.asin, product.isbn, product.weight, product.product_type_id, product.cached_price, stock_area.stock_type_id, product.amazon_lowest_new_price, product.amazon_lowest_used_price, product.melando_reference_price, stock_area.stock_area, article.*, article.user_id AS article_user_id FROM `article` INNER JOIN `stock_area` ON `article`.`stock_area_id` = `stock_area`.`stock_area_id` LEFT OUTER JOIN `product` ON `article`.`product_id` = `product`.`product_id` WHERE `article`.`product_id` = 60121 AND `article`.`article_state_id` = 1 AND `article`.`deleted_at` IS NULL ORDER BY `article`.`article_condition_id` ASC