SELECT m.modellID, m.art_no, m.familyID, m.plastID, m.markeID, m.katID, m.typID, m.editionID, m.price_type_id, m.price_type_id2, m.statusID, m.statusID as artStatID, m.prioID, m.price_sek, m.price_eur, m.price_usd, m.sale_sek, m.sale_eur, m.sale_usd, m.back_up_qty, matt.turn, matt.speed, matt.glide, matt.fade, matt.img_file, matt.img_file_type, matt.img_file_type2, matt.img_file_qty, matt.img_file_str, matt.img_file_ver, matt.qtyNos, matt.img_color_id, matt.diameter, matt.weight, matt.mf_link, matt.introduced, matt.updated, SUM(oi.qty) as qtySold, md.slug, md.modell, mf.family_id, mf.slug as dmSlug, mf.family, mf.fa_type_id, mf.fa_speed, mf.fa_glide, mf.fa_turn, mf.fa_fade, mf.rim_thickness, ma.marke, ma.abbrev as bAbbr, ma.catalogue as bCata, (mf.fa_speed + mf.fa_glide) AS distance, (mf.fa_turn + mf.fa_fade) AS direction, k.kat, k.katID, t.typeStatId, t.typ, t.typ_en, p.plast, p.abbrev as pAbbr, p.qualityID, p.p_price_sek, p.p_price_eur, p.p_price_usd FROM modell m INNER JOIN modell_family mf ON m.familyID = mf.family_id INNER JOIN modell_description md ON m.modellID = md.modellID INNER JOIN modell_attributes matt ON m.modellID = matt.modellID INNER JOIN modell_status ms ON m.statusID = ms.statusID INNER JOIN marke ma ON m.markeID = ma.markeID INNER JOIN typ t ON m.typID = t.typID INNER JOIN kat k ON m.katID = k.katID INNER JOIN plast p ON m.plastID = p.plastID INNER JOIN plastic_quality pq ON p.qualityID = pq.id INNER JOIN order_items oi ON oi.modellID = m.modellID INNER JOIN orders o ON oi.o_id = o.o_id WHERE md.language_id = 2 AND m.statusID != 9 AND mf.fa_type_id = '3' AND YEAR(o.o_timestamp) = '2025' GROUP BY m.modellID ORDER BY qtySold DESC, m.modellID DESC AND mf.fa_type_id = '3' AND mf.family_id != '1' AND k.katID = 1 AND (mf.fa_turn + mf.fa_fade) < 2 AND m.statusID != 9 AND (m.prioID < 50 or m.back_up_qty > 0) AND mf.fa_type_id = '3' AND m.statusID < 12 AND NOT ( m.statusID IN (10,11) AND m.prioID <= 60 AND matt.introduced < NOW() - INTERVAL 1 YEAR AND matt.updated < NOW() - INTERVAL 1 YEAR ) GROUP BY m.modellID ORDER BY tl.placement ASC