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.
4
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,
0 as typeId, 0 as period, 0 as placement, sx.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 (
SELECT oi.modellID, SUM(oi.qty) AS qtySold
FROM order_items oi
INNER JOIN orders o ON o.o_id = oi.o_id
WHERE 1=1
GROUP BY oi.modellID
) sx ON sx.modellID = m.modellID
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 = 1
AND m.statusID != 9 AND m.markeID = '73' AND m.markeID = '73' AND p.plastID = '158' 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 qtySold DESC LIMIT 0, 50
Streamline Discs - Electron Streamline | Discgolf
Shop in eur and view this page in english, go to discsport.com