SELECT mf.family_id as id, 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, mf.rim_depth, (mf.fa_speed + mf.fa_glide) AS distance, (mf.fa_turn + mf.fa_fade) AS direction, tl.typeId, tl.period, tl.placement, tl.sold as qtySold, 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, 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.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 top_list tl ON m.modellID = tl.itemId 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.language_id = 2 AND m.statusID != 9 AND tl.period = '2' AND tl.typeId = '1' AND k.katID = '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 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