SELECT * FROM ( 
		SELECT
    mf.family_id as id, mf.family_id, mf.slug as dmSlug, mf.family, mf.fa_type_id, mf.fa_release_date, mf.fa_diam,
    mf.fa_speed, mf.fa_glide, mf.fa_turn, mf.fa_fade, mf.rim_thickness, mf.rim_depth, (mf.rim_thickness * 2+ mf.rim_depth) as rim_grip_size,
    (mf.fa_speed + mf.fa_glide) AS distance, (mf.fa_turn + mf.fa_fade) AS direction,
    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,
    CASE
        WHEN m.sale_sek > 0 THEN m.sale_sek
        WHEN m.price_sek > 0 THEN LEAST(m.price_sek, COALESCE(NULLIF(m.sale_sek, 0), 999999))
        WHEN p.p_price_sek > 0 THEN p.p_price_sek
        ELSE 0
    END AS lowest_price_sek,
    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.imgColorIds, matt.img_file_ver, matt.qtyNos, matt.img_color_id, matt.diameter, matt.weight, matt.mf_link, matt.introduced, matt.updated,
		md.slug, md.modell,
		ma.marke, ma.abbrev as bAbbr, ma.catalogue as bCata,
		k.kat, t.typeStatId, t.typ, t.typ_en, p.plast, p.abbrev as pAbbr, p.qualityID, p.flexID, p.p_price_sek, p.p_price_eur, p.p_price_usd
		FROM modell_family mf
    INNER JOIN modell m ON mf.family_id = m.familyID
    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
		WHERE md.modell != ''
	 AND mf.fa_type_id = '2' 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 = '2' AND k.katID = '1' AND rim_depth > 0  AND m.editionID NOT IN (7,8,9) AND m.statusID < 10 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
	)) as t GROUP BY t.family_id ORDER BY  t.rim_depth ASC