SELECT art_subarticles.*,d_items_idioma.titol AS titol_idioma,d_items.*,d_items_idioma.*
,caract_1 as marca, caract_2 as modelo,caract_3 as acabat, art_subarticles.id_article as tipus, IF(art_subarticle_tarifa.preu_oferta > 0,art_subarticle_tarifa.preu_oferta,art_subarticles.preu_oferta) as preu_oferta, art_subarticle_tarifa.pvp, IF(art_subarticle_tarifa.preu_oferta > 0,
IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp,
art_subarticle_tarifa.preu_oferta,
art_subarticle_tarifa.pvp),
/* ELSE */
IF(art_subarticles.preu_oferta > 0,
IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp,
art_subarticles.preu_oferta,
art_subarticle_tarifa.pvp),
art_subarticle_tarifa.pvp)) AS preu_final
FROM art_subarticles
LEFT JOIN d_items_idioma ON art_subarticles.id_item = d_items_idioma.id
LEFT JOIN d_items ON d_items.id=art_subarticles.id_item
LEFT JOIN art_articles ON art_articles.id = art_subarticles.id_article
LEFT JOIN art_families ON art_families.id = art_subarticles.id_familia
LEFT JOIN art_area ON art_area.id = art_subarticles.id_area
LEFT JOIN art_subarticle_tarifa ON art_subarticle_tarifa.id_subarticle=art_subarticles.id
LEFT JOIN d_items_idioma_tema ON d_items_idioma_tema.id=d_items.id AND d_items_idioma_tema.id_idioma='en' AND d_items_idioma_tema.id_tema = '1'
WHERE art_subarticles.arxivat<>'Y'
AND art_subarticles.web='Y'
AND d_items_idioma.id_idioma='en'
AND d_items.data_publicacio < '1751830247'
AND (d_items.data_caducitat > '1751830247'
OR d_items.data_caducitat <= 0)
AND art_subarticle_tarifa.id_tarifa='PVP' AND art_subarticle_tarifa.hores='0'
AND art_subarticles.id IN(
SELECT id_tabla FROM art_caracteristiques_relacions WHERE 1<= (
SELECT count( distinct art_caracteristiques_relacions.id_carac) as total
FROM art_caracteristiques_relacions WHERE ( (id_carac='5' AND id_valor='8175' ) AND art_caracteristiques_relacions.tabla='art_subarticles'
)
AND art_caracteristiques_relacions.id_tabla=art_subarticles.id AND art_caracteristiques_relacions.tabla='art_subarticles')
AND art_caracteristiques_relacions.id_tabla=art_subarticles.id AND art_caracteristiques_relacions.tabla='art_subarticles'
) AND (IF(art_subarticle_tarifa.preu_oferta > 0,
IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp,
art_subarticle_tarifa.preu_oferta,
art_subarticle_tarifa.pvp),
/* ELSE */
IF(art_subarticles.preu_oferta > 0,
IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp,
art_subarticles.preu_oferta,
art_subarticle_tarifa.pvp),
art_subarticle_tarifa.pvp))) >= 0.1
AND (d_items_idioma_tema.actiu<>'N' OR d_items_idioma_tema.actiu IS NULL)
ORDER BY marca,modelo,tipus,acabat,art_subarticles.model
LIMIT 0,99999999
YAMAHA Tenere 700 2019>2020
To install, no structural modifications are required. GPR recommends reading the included instructions or tutorial on http://www.gpr.it or the GPR channel on Youtube.
For on-line purchases, activate the warranty by sending the installation receipt from the mechanic / shop via email to certificato@gpr.it, or sending the sales receipt from the physical or online store.
As racing exhaust, there is not a removable db killer (noise restrictor), large part of time is possible buy as spare parts, not use the DB Killer is ILLEGAL and the customer assumes the responsibility if they use the motorbike as on the circuits only, without bags, without flash lights, number plate holder or other parts that would conflict with the different angle of the gas following the transformation into the racing version. Abuse of this situation on the road will result in the loss of the product warranty and any refund request will be rejected.
The warranty is two years from the purchase, with right of reparation with a return to the GPR factory, or the nearest official distributor at the customer's expense.
GPR will not provide a new silencer, but will repair the original silencer. The customer must accept to remount the original exhaust or wait the standard time for the repair.
Catalyst Eliminator: The GPR manifold eliminates the original catalyst.
For on-line purchases, activate the warranty by sending the installation receipt from the mechanic / shop via email to certificato@gpr.it, or sending the sales receipt from the physical or online store.
As racing exhaust, there is not a removable db killer (noise restrictor), large part of time is possible buy as spare parts, not use the DB Killer is ILLEGAL and the customer assumes the responsibility if they use the motorbike as on the circuits only, without bags, without flash lights, number plate holder or other parts that would conflict with the different angle of the gas following the transformation into the racing version. Abuse of this situation on the road will result in the loss of the product warranty and any refund request will be rejected.
The warranty is two years from the purchase, with right of reparation with a return to the GPR factory, or the nearest official distributor at the customer's expense.
GPR will not provide a new silencer, but will repair the original silencer. The customer must accept to remount the original exhaust or wait the standard time for the repair.
Catalyst Eliminator: The GPR manifold eliminates the original catalyst.
YAMAHA
CO.Y.208.DECPAR
Decatalizzatore + Paracoppa Titanio
Decat pipe more titanium skid plateCO.Y.208.DECPAR
InStock
31/12/2039
USD $696.51
USD $522.38
YAMAHA Tenere 700 2021>2024
To install, no structural modifications are required. GPR recommends reading the included instructions or tutorial on http://www.gpr.it or the GPR channel on Youtube.
For on-line purchases, activate the warranty by sending the installation receipt from the mechanic / shop via email to certificato@gpr.it, or sending the sales receipt from the physical or online store.
As racing exhaust, there is not a removable db killer (noise restrictor), large part of time is possible buy as spare parts, not use the DB Killer is ILLEGAL and the customer assumes the responsibility if they use the motorbike as on the circuits only, without bags, without flash lights, number plate holder or other parts that would conflict with the different angle of the gas following the transformation into the racing version. Abuse of this situation on the road will result in the loss of the product warranty and any refund request will be rejected.
The warranty is two years from the purchase, with right of reparation with a return to the GPR factory, or the nearest official distributor at the customer's expense.
GPR will not provide a new silencer, but will repair the original silencer. The customer must accept to remount the original exhaust or wait the standard time for the repair.
Catalyst Eliminator: The GPR manifold eliminates the original catalyst.
For on-line purchases, activate the warranty by sending the installation receipt from the mechanic / shop via email to certificato@gpr.it, or sending the sales receipt from the physical or online store.
As racing exhaust, there is not a removable db killer (noise restrictor), large part of time is possible buy as spare parts, not use the DB Killer is ILLEGAL and the customer assumes the responsibility if they use the motorbike as on the circuits only, without bags, without flash lights, number plate holder or other parts that would conflict with the different angle of the gas following the transformation into the racing version. Abuse of this situation on the road will result in the loss of the product warranty and any refund request will be rejected.
The warranty is two years from the purchase, with right of reparation with a return to the GPR factory, or the nearest official distributor at the customer's expense.
GPR will not provide a new silencer, but will repair the original silencer. The customer must accept to remount the original exhaust or wait the standard time for the repair.
Catalyst Eliminator: The GPR manifold eliminates the original catalyst.
YAMAHA
CO.Y.232.DECPAR
Decatalizzatore + Paracoppa Titanio
Decat pipe more titanium skid plateCO.Y.232.DECPAR
InStock
31/12/2039
USD $696.51
USD $522.38