Registrati   Accedi   Ricerca Avanzata Carrello 0 Prodotto(i) EUR 0,00 Chi siamo   Sistema F.I.T.   Pagamenti   Spedizioni   Condizioni e Garanzie   Partners

Naviga per Categorie Novità di maggio Giacca Uomo Marrone con Capuccio - Tessuto Impermeabile Cuciture Rinforzate EUR 99,00 EUR 68,00 Offerte Coppa olio originale per Moto Guzzi 350 750 EUR 277,00 EUR 199,00 Articoli in offerta per la categoria FRECCE Freccia Ant SX Post DX per Moto Guzzi Breva 750IE Codice: AO067 - 32751611 Consegna Immediata EUR 48,00 EUR 38,00 Staffa Cromata porta Frecce Ant. per Moto Guzzi 850 GT California Codice: AO091-1 - Disponibile in 2/4/6 giorni lavorativi EUR 50,00 EUR 45,00 Freccia ant dx post sx Guzzi Nevada Classic 750 Codice: AO063 - 32750660 Consegna Immediata EUR 38,00 EUR 27,00 Trasparente freccia ant e post per Moto Guzzi Breva 750 Codice: AO097 - 32753711 Consegna Immediata EUR 9,00 EUR 7,00 Freccia ant sx post dx Guzzi Nevada Classic 750 Codice: AO064 - 32751660 Consegna Immediata EUR 38,00 EUR 27,00 Coppia Staffe Cromate Porta Frecce Anteriore per Moto Guzzi V7 850 GT California Codice: AO091-2 - Consegna Immediata EUR 65,00 EUR 57,00 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'limit 0, 20' at line 1 select DISTINCT p.products_image, p.products_image_hot_linking_small, p.products_image_hot_linking, pd.products_name, p.products_model, p.products_details_original_prod_code,p.products_quantity,p.products_master_status, p.products_listing_status,p.products_date_added, p.products_date_available, p.products_import_module_codes, pd.main_image_alt_tag, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from oscpro_products_description pd, oscpro_products p left join oscpro_manufacturers m on p.manufacturers_id = m.manufacturers_id, oscpro_products_to_categories p2c left join oscpro_categories c on p2c.categories_id = c.categories_id where ((p.products_master_status != '0') or (p.products_listing_status != '0')) and c.categories_status = '1' and (c.categories_allowed_customers_gid = '0' or (c.categories_allowed_customers_gid = '-1') or (c.categories_allowed_customers_gid = '-2')) and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '6' and p2c.categories_id = '48' order by limit 0, 20 [TEP STOP]