SELECT SUM(IF(rating = 5, 1,0)) AS fiveStars, AVG(r.rating) as avgRating, COUNT(r.rating) as qtyReviews, m.modellID, m.art_no, m.familyID, m.plastID, m.markeID, m.katID, m.typID, m.editionID, m.playerID, 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_color_id, matt.diameter, matt.weight, matt.mf_link, matt.introduced, matt.updated, md.slug, md.modell, 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, ma.marke, ma.catalogue as bCata, (mf.fa_speed + mf.fa_glide) AS distance, (mf.fa_turn + mf.fa_fade) AS direction, k.kat, t.typ, t.typ_en, t.typ_dk, p.plast, p.qualityID, p.p_price_sek, p.p_price_eur, p.p_price_usd FROM modell_family mf INNER JOIN (modell m, modell_description md, modell_attributes matt, marke ma, typ t, kat k, plast p, modell_status ms, reviews r ) ON (mf.family_id = m.familyID AND m.modellID = md.modellID AND m.modellID = matt.modellID AND m.statusID = ms.statusID AND m.markeID = ma.markeID AND m.typID = t.typID AND m.katID = k.katID AND m.plastID = p.plastID AND m.modellID = r.art_id) WHERE md.language_id = 1 AND r.stat_id = '1' AND m.markeID = '73' AND p.plastID = '158' SELECT SUM(IF(rating = 5, 1,0)) AS fiveStars, AVG(r.rating) as avgRating, COUNT(r.rating) as qtyReviews, m.modellID, m.art_no, m.familyID, m.plastID, m.markeID, m.katID, m.typID, m.editionID, m.playerID, 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_color_id, matt.diameter, matt.weight, matt.mf_link, matt.introduced, matt.updated, md.slug, md.modell, 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, ma.marke, ma.catalogue as bCata, (mf.fa_speed + mf.fa_glide) AS distance, (mf.fa_turn + mf.fa_fade) AS direction, k.kat, t.typ, t.typ_en, t.typ_dk, p.plast, p.qualityID, p.p_price_sek, p.p_price_eur, p.p_price_usd FROM modell_family mf INNER JOIN (modell m, modell_description md, modell_attributes matt, marke ma, typ t, kat k, plast p, modell_status ms, reviews r ) ON (mf.family_id = m.familyID AND m.modellID = md.modellID AND m.modellID = matt.modellID AND m.statusID = ms.statusID AND m.markeID = ma.markeID AND m.typID = t.typID AND m.katID = k.katID AND m.plastID = p.plastID AND m.modellID = r.art_id) WHERE md.language_id = 1 AND r.stat_id = '1' 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 r.art_id ORDER BY fiveStars DESC, qtyReviews DESC, avgRating DESC LIMIT 0, 50 Streamline Discs - Electron Streamline | Discgolf

Bästsäljare

Nyheter

Påfyllt

Kampanjer

51 605 discar i lager just nu

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