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 md.language_id = 1 AND m.markeID = '73' AND p.plastID = '158' AND k.katID = '1' AND m.editionID NOT IN (7,8,9) 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 )) as t GROUP BY t.family_id ORDER BY direction ASC, distance DESC, t.fa_speed DESC, t.fa_turn DESC, t.prioID ASC LIMIT 0, 250

Streamline Discs - Electron Streamline | Discgolf

Bästsäljare

Nyheter

Påfyllt

Kampanjer

51 605 discar i lager just nu

Populära molds

Streamline Discs Electron Streamline

– Riktning (Hö-Vä) –

US  Founded: 2017  Website:  streamlinediscs.com   
Electron Pilot
1.0

Electron Pilot

2  5  0  1

Putt & Approach

N

149:-

Stabilizer
3.0

Stabilizer

3  3.5  0  3

Putt & Approach

A

149:-

DD (Distance Driver), FD (fairway Driver), MD (Midrange), PA (Putt & Approach).

Välj utifrån din nivå:

E
asy
N
eutral
A
dvanced

2 av 2 st artiklar visas.
permalink

Bonuspoäng på allt du handlar!

Signa upp hos oss och du får bonuspoäng på allt du handlar. För dina poäng kan du köpa rabattkuponger.

discgolfers suppliers logo