Prodotto 18/39

Precedente
Categoria
Successivo

LAVERDA 75 cc 4 TEMPI 3 MARCE 1954

2,750.00EUR

LAVERDA 75 cc 4 TEMPI 3 MARCE 1954 , ALLESTITA PER GARE IN SALITA , SENZA DOCUMENTI , MOTORE IN PERFETTO STATO GRAZIE AD INTERVENTI COME SOSTITUZIONE FASCE ELASTICHE AL PISTONE , SPINOTTO PISTONE , VALVOLE E SEDI IN TESTA RIFATTE , IN ORIGINE ALBERO A CAMME PER GARE MOTORE BRILLANTE GRAZIE AD UN CARBURATORE DELL'ORTO 20 MM .

Prodotto inserito in catalogo luned́ 16 giugno, 2014.


Da inserire:

  • 1 disponibilità in magazzino












 
1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'Sql1635852_1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6650' and opa.orders_id = opb.orders_id and opb.products_id != '6650' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]