Note! Orders shipped outside the EU may be subject to customs duties, VAT, and handling fees charged by your local authorities.
More..
Important information for orders outside the EU:
Deliveries to countries outside the European Union may be subject to customs duties, import taxes (VAT), and handling fees once the shipment reaches your country. These additional costs are set and collected by your local customs authority, and they are not included in the prices or shipping costs shown at Discsport.
We recommend checking with your local customs office for details on possible charges before placing your order. Please note that customs procedures may also affect delivery times.
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
Shop in eur and view this page in english, go to discsport.com