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 < '1751813252'
AND (d_items.data_caducitat > '1751813252'
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='10' AND id_valor='6367' ) 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
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.
The exhaust has a removable db killer (noise restrictor) for racing use. Removing 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. This kit includes the specific link pipe or half-manifold with specific appropriate brackets and accessories. This allows for installation without any structural modifications.
Benelli
BE.14.DE
Deeptone Inox
Slip-on exhaust including removable db killer and link pipe, EPA-compliant BE.14.DE
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.
The exhaust has a removable db killer (noise restrictor) for racing use. Removing 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. This kit includes the specific link pipe or half-manifold with specific appropriate brackets and accessories. This allows for installation without any structural modifications.
Benelli
E4.BE.14.M3.INOX
M3 Inox
Slip-on exhaust including removable db killer and link pipe, EPA-compliant E4.BE.14.M3.INOX
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.
The exhaust has a removable db killer (noise restrictor) for racing use. Removing 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. This kit includes the specific link pipe or half-manifold with specific appropriate brackets and accessories. This allows for installation without any structural modifications.
Benelli
E4.BE.14.PCEV
Powercone Evo
Slip-on exhaust including removable db killer and link pipe, EPA-compliant E4.BE.14.PCEV
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.
The exhaust has a removable db killer (noise restrictor) for racing use. Removing 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. This kit includes the specific link pipe or half-manifold with specific appropriate brackets and accessories. This allows for installation without any structural modifications.
Benelli
BE.14.SAT
Satinox
Slip-on exhaust including removable db killer and link pipe, EPA-compliant BE.14.SAT
It mounts without the need for modifications Screws and spacers included It is compatible ONLY with Alpi-Tech GPR TECH top cases Ergonomic shockproof and not sharp, Titanium made, 100% Italian technology
Benelli
TIT.PIA.BENE.5.UNI
compatible with original luggage rack,titanium made with 4 anchor points
SPECIFIC TITANIUM PLATE TOP CASE-ALPITECH 35/55 LT TIT.PIA.BENE.5.UNI
It mounts without the need for modifications Screws and spacers included It is compatible ONLY with Alpi-Tech GPR TECH top cases Ergonomic shockproof and not sharp Stainless steel made Italian technology
Benelli
PIA.BENE.5.SP.45
compatible with original luggage rack,stainless steel made with 4 anchor points
Specific fitting plate Top Case ALPITECH 35 LT PIA.BENE.5.SP.45
It mounts without the need for modifications Screws and spacers included It is compatible ONLY with Alpi-Tech GPR TECH top cases Ergonomic shockproof and not sharp Stainless steel made Italian technology
Benelli
PIA.BENE.5.SP.55
compatible with original luggage rack,stainless steel made with 4 anchor points
Specific fitting plate Top Case ALPITECH 55 LT PIA.BENE.5.SP.55
GPR TECH TOP CASE ALPI-TECH, capacity 35 Liters, 5052 aluminum made,with reinforced corners, Silver color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.5.BA.35.ALP.A
Capacity 35 LT.
Top case in aluminum, silver color with specific plate included BENE.5.BA.35.ALP.A
GPR TECH TOP CASE ALPI-TECH,capacity 35 Liters, 5052 aluminum made,with reinforced corners, Black color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.5.BA.35.ALP.B
Capacity 35 LT.
Top case in aluminum, black color with specific plate included BENE.5.BA.35.ALP.B
GPR TECH TOP CASE ALPI-TECH, capacity 45 Liters, 5052 aluminum made,with reinforced corners, Silver color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.5.BA.45.ALP.A
Capacity 45 LT.
Top case in aluminum, silver color with specific plate included BENE.5.BA.45.ALP.A
GPR TECH TOP CASE ALPI-TECH,capacity 45 Liters, 5052 aluminum made,with reinforced corners, Black color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.5.BA.45.ALP.B
Capacity 45 LT.
Top case in aluminum, black color with specific plate included BENE.5.BA.45.ALP.B
GPR TECH TOP CASE ALPI-TECH,capacity 55 Liters, 5052 aluminum made,with reinforced corners,silver color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.5.BA.55.ALP.A
Capacity 55 LT.
Top case in aluminum, silver color with specific plate included BENE.5.BA.55.ALP.A
GPR TECH TOP CASE ALPI-TECH,capacity 55 Liters, 5052 aluminum made,with reinforced corners,black color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.5.BA.55.ALP.B
Capacity 55 LT.
Top case in aluminum, black color with specific plate included BENE.5.BA.55.ALP.B
It mounts without the need for modifications Screws and spacers included It is compatible ONLY with Alpi-Tech GPR TECH top cases Ergonomic shockproof and not sharp, Titanium made, 100% Italian technology
Benelli
TIT.PIA.BENE.6.UNI
compatible with original luggage rack,titanium made with 4 anchor points
SPECIFIC TITANIUM PLATE TOP CASE-ALPITECH 35/55 LT TIT.PIA.BENE.6.UNI
It mounts without the need for modifications Screws and spacers included It is compatible ONLY with Alpi-Tech GPR TECH top cases Ergonomic shockproof and not sharp Stainless steel made Italian technology
Benelli
PIA.BENE.6.SP.45
compatible with original luggage rack,stainless steel made with 4 anchor points
Specific fitting plate Top Case ALPITECH 35 LT PIA.BENE.6.SP.45
It mounts without the need for modifications Screws and spacers included It is compatible ONLY with Alpi-Tech GPR TECH top cases Ergonomic shockproof and not sharp Stainless steel made Italian technology
Benelli
PIA.BENE.6.SP.55
compatible with original luggage rack,stainless steel made with 4 anchor points
Specific fitting plate Top Case ALPITECH 55 LT PIA.BENE.6.SP.55
GPR TECH TOP CASE ALPI-TECH, capacity 35 Liters, 5052 aluminum made,with reinforced corners, Silver color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.6.BA.35.ALP.A
Capacity 35 LT.
Top case in aluminum, silver color with specific plate included BENE.6.BA.35.ALP.A
GPR TECH TOP CASE ALPI-TECH,capacity 35 Liters, 5052 aluminum made,with reinforced corners, Black color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.6.BA.35.ALP.B
Capacity 35 LT.
Top case in aluminum, black color with specific plate included BENE.6.BA.35.ALP.B
GPR TECH TOP CASE ALPI-TECH, capacity 45 Liters, 5052 aluminum made,with reinforced corners, Silver color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.6.BA.45.ALP.A
Capacity 45 LT.
Top case in aluminum, silver color with specific plate included BENE.6.BA.45.ALP.A
GPR TECH TOP CASE ALPI-TECH,capacity 45 Liters, 5052 aluminum made,with reinforced corners, Black color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.6.BA.45.ALP.B
Capacity 45 LT.
Top case in aluminum, black color with specific plate included BENE.6.BA.45.ALP.B
GPR TECH TOP CASE ALPI-TECH,capacity 55 Liters, 5052 aluminum made,with reinforced corners,silver color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.6.BA.55.ALP.A
Capacity 55 LT.
Top case in aluminum, silver color with specific plate included BENE.6.BA.55.ALP.A
GPR TECH TOP CASE ALPI-TECH,capacity 55 Liters, 5052 aluminum made,with reinforced corners,black color with specific plate an hardware included to can mount the product on original rear rack without any modification. This Top Case allow to place an Enduro helmet. The GPR TECH top case includes a washable and removable lining for helmet protection. The backrest protection amd the removable object bag be purchased separately.
Benelli
BENE.6.BA.55.ALP.B
Capacity 55 LT.
Top case in aluminum, black color with specific plate included BENE.6.BA.55.ALP.B
We inform you that we use first- and third-party cookies in order to improve the performance of the page and for analytical and advertising purposes. If you want more information or would like to manage them, please go to the Cookie settings.
Manage preferences
MandatoryAnalytics and advertising
Técnicas: son aquellas necesarias para la navegación y el buen funcionamiento de nuestro website. Permiten, por ejemplo, controlar el tráfico y la comunicación de datos, acceder a partes de acceso restringido, realizar el proceso de compra de un pedido, utilizar elementos de seguridad, almacenar contenidos para poder difundir vídeos o compartir contenidos a través de redes sociales.
De personalización: son aquellas que permiten al Usuario acceder al servicio con unas características predefinidas en función de una serie de criterios, como por ejemplo el idioma, el tipo de navegador a través del cual se accede al servicio, la configuración regional desde donde se accede al servicio, etc.
Finalidad
Proveedor
Nombre
Gestión
Función
Vigencia
Técnicas
Cookie Propia
validacions_cookies
Propia
Gestión de la aceptación de las cookies.
1 año.
Personalización
Cookie Propia
(Aleatorio)
Propia
Gestión de la sesión del visitante..
Al finalizar la sesión en el navegador.
De análisis: son aquellas que, tratadas por nosotros o por terceros, nos permiten cuantificar el número de usuarios y así realizar la medición y análisis estadístico de la utilización que hacen los usuarios del servicio ofertado. Para ello se analiza su navegación en nuestra página web con el fin de mejorar la oferta de productos o servicios que le ofrecemos.