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
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
AND o.o_timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY)
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 = '4' AND m.markeID = '4' AND p.plastID = '370' 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
Innova - Halo Champion | Disc Golf
INNOVA bildades 1983 och skapade då världens första disc speciellt designad för discgolf: Eagle. Idag är INNOVA ett av de ledande företagen på golfdiscar och innehar världsrekordet i längd med sin modell Valkyrie.
Pick up at the warehouse:
Select "Pick Up Warehouse" as the delivery option at checkout. Your order will be placed in our parcel locker outside the entrance when it is ready.
More info