Italiano
English
A partire da:
47.50 €Scegli il modello
| Codice | Prezzo | N. pale | Ø x passo | Ø piede | N. brocciature (denti) | Motore HP | OEM | |
|---|---|---|---|---|---|---|---|---|
|
49.90 €
47.50€
PZ
|
Aggiungi al carrello |
3 | 8 1/2 x 7 1/2 | - | 7 | 8 RAY (4 T); 9,9 PIKE (4 T) | 6G1-45943-00-00 |
|
|
49.90 €
47.50€
PZ
|
Aggiungi al carrello |
3 | 8 1/2 x 8 1/2 | - | 7 | 8 RAY (4 T); 9,9 PIKE (4 T) | 6G1-45941-00-00 |
|
|
49.90 €
47.50€
PZ
|
Aggiungi al carrello |
3 | 8 1/2 x 9 1/4 | - | 7 | 8 RAY (4 T); 9,9 PIKE (4 T) | 6G1-45954-00-00 |
|
|
56.90 €
54.60€
PZ
|
Aggiungi al carrello |
3 | 9 1/4 x 8 | 2" 1/2 | 8 | 9 (4 T) fino a 2007; 15/20 (4 T) WAHOO | 63V-45947-00-00 |
|
|
56.90 €
54.60€
PZ
|
Aggiungi al carrello |
3 | 9 1/4 x 9 | 2" 1/2 | 8 | 9 (4 T) fino a 2007; 15/20 (4 T) WAHOO | 63V-45945-00-00 |
|
|
56.90 €
54.60€
PZ
|
Aggiungi al carrello |
3 | 9 1/4 x 10 | 2" 1/2 | 8 | 9 (4 T) fino a 2007; 15/20 (4 T) WAHOO | 63V-45952-00-00 |
|
|
56.90 €
54.60€
PZ
|
Aggiungi al carrello |
3 | 9 1/4 x 11 | 2" 1/2 | 8 | 9 (4 T) fino a 2007; 15/20 (4 T) WAHOO | 63V-45943-00-00 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 9 7/8 x 9 | 3" | 10 | 25 (4 T) (MORAY/KINGFISH) | 664-45941-01-00 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 9 7/8 x 10 1/2 | 3" | 10 | 25 (4 T) (MORAY/KINGFISH) | 664-45945-00-00 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 9 7/8 x 11 1/4 | 3" | 10 | 25 (4 T) (MORAY/KINGFISH) | 664-45947-01-00 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 9 7/8 x 12 | 3" | 10 | 25 (4 T) (MORAY/KINGFISH) | 664-45954-01-00 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 9 7/8 x 13 | 3" | 10 | 25 (4 T) (MORAY/KINGFISH) | 664-45949-02-00 |
|
|
80.90 €
77.40€
PZ
|
Aggiungi al carrello |
3 | 11 3/4 x 10 | 3" 1/2 | 13 | 40/50 (MANTA-BARRACUDA); 40/60 EFI (ARVANA-DORADO) | 663-45954-01-EL |
|
|
80.90 €
77.40€
PZ
|
Aggiungi al carrello |
3 | 11 5/8 x 11 | 3" 1/2 | 13 | 40/50 (MANTA-BARRACUDA); 40/60 EFI (ARVANA-DORADO) | 69W-45947-00-00 |
|
|
80.90 €
77.40€
PZ
|
Aggiungi al carrello |
3 | 11 3/8 x 12 | 3" 1/2 | 13 | 40/50 (MANTA-BARRACUDA); 40/60 EFI (ARVANA-DORADO) | 69W-45952-00-00 |
|
|
80.90 €
77.40€
PZ
|
Aggiungi al carrello |
3 | 11 1/8 x 13 | 3" 1/2 | 13 | 40/50 (MANTA-BARRACUDA); 40/60 EFI (ARVANA-DORADO) | 69W-45945-00-00 |
|
|
80.90 €
77.40€
PZ
|
Aggiungi al carrello |
3 | 11 1/4 x 14 | 3" 1/2 | 13 | 40/50 (MANTA-BARRACUDA); 40/60 EFI (ARVANA-DORADO) | 69W-45958-00-00 |
|
|
80.90 €
77.40€
PZ
|
Aggiungi al carrello |
3 | 11 x 15 | 3" 1/2 | 13 | 40/50 (MANTA-BARRACUDA); 40/60 EFI (ARVANA-DORADO) | 69W-45943-00-00 |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 14 X 11 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45954-00-EL |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 5/8 x 12 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 5/8 x 13 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45949-00-5 EL |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 5/8 x 14 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45958-00-00 |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 1/2 x 15 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45947-00-EL |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 1/4 x 17 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45945-01-EL |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 x 19 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45941-00-EL |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 12 5/8 x 21 | 4" 1/4 | 15 | 40/70 MURENA (4 T); 80/100 MARLIN (4 T); 115 MARVAL/TARPON (4 T) | 6E5-45943-00-00 |
|
|
169.50 €
161.80€
PZ
|
Aggiungi al carrello |
3 | 15 1/4 x 15 | 4" 3/4 | 15 | 150 (4 T); 200/225; 250 | 6G5-45941-00-98 |
|
|
169.50 €
161.80€
PZ
|
Aggiungi al carrello |
3 | 14 1/2 x 17 | 4" 3/4 | 15 | 150 (4 T); 200/225; 250 | 6G5-45947-01-98 |
|
|
169.50 €
161.80€
PZ
|
Aggiungi al carrello |
3 | 13 3/4 x 21 | 4" 3/4 | 15 | 150 (4 T); 200/225; 250 | 6G5-45945-01-98 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 10 1/4 x 11 | 3" | 14 | 20/25/30/45 (2 T) | 765049 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 10 1/4 x 12 | 3" | 14 | 20/25/30/45 (2 T) | 765050 |
|
|
67.90 €
65.10€
PZ
|
Aggiungi al carrello |
3 | 10 1/4 x 13 | 3" | 14 | 20/25/30/45 (2 T) | 778863 |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 14 x 13 | 4" 1/4 | 13 | 70/80/90/100 (2 T) | 765181 |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 3/4 x 15 | 4" 1/4 | 13 | 70/80/90/100 (2 T) | 765182 |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 1/4 x 17 | 4" 1/4 | 13 | 70/80/90/100 (2 T) | 765183 |
|
|
134.50 €
126.60€
PZ
|
Aggiungi al carrello |
3 | 13 x 19 | 4" 1/4 | 13 | 70/80/90/100 (2 T) | 765184 |
Prezzi validi solo per acquisti online
Per motori SELVA
Prodotti Correlati
Il 90% degli ordini viene spedito in 24H. Vedi subito disponibilità e tempistiche
Lavoriamo e diamo assistenza nautica dal 1982. Troverete personale esperto e gentile nell'assistervi
Scegli tra Paypal, Carta di Credito, Postepay e Bonifico Bancario
Utilizziamo solamente imballaggi provenienti da materiale riciclato all'interno del nostro stesso negozio
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '4da1eafa426b975fd01582842e371a5d' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100996' ORDER BY `Category`.`name_it` ASC | 0 | 0 | 0 | |
| 3 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100997' ORDER BY `Category`.`name_it` ASC | 0 | 0 | 0 | |
| 4 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100993' ORDER BY `Category`.`name_it` ASC | 0 | 0 | 0 | |
| 5 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '24005' ORDER BY `Category`.`name_it` ASC | 0 | 0 | 0 | |
| 6 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100999' ORDER BY `Category`.`name_it` ASC | 0 | 0 | 0 | |
| 7 | SELECT `Serie`.`id`, `Serie`.`name_it`, `Serie`.`name_eng`, `Serie`.`summary_it`, `Serie`.`summary_eng`, `Serie`.`description_it`, `Serie`.`description_eng`, `Serie`.`description_bottom_it`, `Serie`.`description_bottom_eng`, `Serie`.`html_title_it`, `Serie`.`html_title_eng`, `Serie`.`photo`, `Serie`.`category_id`, `Serie`.`upper_category_id`, `Serie`.`start_price`, `Serie`.`active` FROM `dbo610494358_stg`.`series` AS `Serie` LEFT JOIN `dbo610494358_stg`.`categories` AS `Category` ON (`Serie`.`category_id` = `Category`.`id`) WHERE `Serie`.`id` = 45963 LIMIT 1 | 1 | 1 | 0 | |
| 8 | SELECT `Image`.`id`, `Image`.`name`, `Image`.`series_id`, `Image`.`product_id`, `Image`.`wall_product_id`, `Image`.`created`, `Image`.`modified` FROM `dbo610494358_stg`.`images` AS `Image` WHERE `Image`.`series_id` = (45963) | 0 | 0 | 0 | |
| 9 | SELECT `Product`.`id`, `Product`.`father`, `Product`.`ean`, `Product`.`description_it`, `Product`.`description_eng`, `Product`.`description_de`, `Product`.`vat`, `Product`.`measure_unit`, `Product`.`price`, `Product`.`list_price`, `Product`.`list_price_blue`, `Product`.`offer_price`, `Product`.`shop_price`, `Product`.`supplier_code`, `Product`.`supplier_name`, `Product`.`osculati_accessory`, `Product`.`weight`, `Product`.`quantity`, `Product`.`supplier_quantity`, `Product`.`minimum_quantity`, `Product`.`always_available`, `Product`.`category_id`, `Product`.`upper_category_id`, `Product`.`category_id2`, `Product`.`upper_category_id2`, `Product`.`attributes_it`, `Product`.`attributes_eng`, `Product`.`attributes_de`, `Product`.`photo`, `Product`.`alternative_description_it`, `Product`.`alternative_description_eng`, `Product`.`alternative_description_de`, `Product`.`html_title_it`, `Product`.`html_title_eng`, `Product`.`html_title_de`, `Product`.`catalog_page`, `Product`.`suggested`, `Product`.`published`, `Product`.`out_of_production`, `Product`.`ebay_auto_publish`, `Product`.`ebay_sku`, `Product`.`ebay_item_no`, `Product`.`ebay_product_type_it`, `Product`.`ebay_product_type_eng`, `Product`.`ebay_product_type_de`, `Product`.`trovaprezzi`, `Product`.`merchant_center`, `Product`.`slug_ita`, `Product`.`created`, `Product`.`modified`, `Product`.`published_ebay`, `Product`.`published_ebay_world`, `Product`.`waiting_review`, `Product`.`stat_order_count`, `Product`.`stat_total_quantity`, `Product`.`stat_total_price_with_vat`, `Product`.`safety_pictograms`, `Product`.`safety_statements`, `Product`.`safety_component`, `Product`.`manufacturer_id`, `Product`.`metadata`, `ProductsSeries`.`product_id`, `ProductsSeries`.`series_id` FROM `dbo610494358_stg`.`products` AS `Product` JOIN `dbo610494358_stg`.`products_series` AS `ProductsSeries` ON (`ProductsSeries`.`series_id` = 45963 AND `ProductsSeries`.`product_id` = `Product`.`id`) | 36 | 36 | 1 | |
| 10 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de`, `Father`.`id`, `Father`.`name_it`, `Father`.`name_eng`, `Father`.`name_de`, `Father`.`description_it`, `Father`.`description_eng`, `Father`.`description_de`, `Father`.`html_title_it`, `Father`.`html_meta_it`, `Father`.`html_meta_eng`, `Father`.`html_meta_de`, `Father`.`html_title_eng`, `Father`.`html_title_de`, `Father`.`father`, `Father`.`ebay`, `Father`.`ebay2`, `Father`.`ebay_uk`, `Father`.`ebay_uk2`, `Father`.`ebay_de`, `Father`.`ebay_de2`, `Father`.`ebay_us`, `Father`.`ebay_us2`, `Father`.`ebay_store`, `Father`.`merchant_center`, `Father`.`active`, `Father`.`created`, `Father`.`modified`, `Father`.`brands`, `Father`.`description_short_it`, `Father`.`description_short_eng`, `Father`.`description_short_de`, `Father`.`json_ld_schema_it`, `Father`.`json_ld_schema_eng`, `Father`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` LEFT JOIN `dbo610494358_stg`.`categories` AS `Father` ON (`Category`.`father` = `Father`.`id`) WHERE `Category`.`id` = '100200' LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de`, `Father`.`id`, `Father`.`name_it`, `Father`.`name_eng`, `Father`.`name_de`, `Father`.`description_it`, `Father`.`description_eng`, `Father`.`description_de`, `Father`.`html_title_it`, `Father`.`html_meta_it`, `Father`.`html_meta_eng`, `Father`.`html_meta_de`, `Father`.`html_title_eng`, `Father`.`html_title_de`, `Father`.`father`, `Father`.`ebay`, `Father`.`ebay2`, `Father`.`ebay_uk`, `Father`.`ebay_uk2`, `Father`.`ebay_de`, `Father`.`ebay_de2`, `Father`.`ebay_us`, `Father`.`ebay_us2`, `Father`.`ebay_store`, `Father`.`merchant_center`, `Father`.`active`, `Father`.`created`, `Father`.`modified`, `Father`.`brands`, `Father`.`description_short_it`, `Father`.`description_short_eng`, `Father`.`description_short_de`, `Father`.`json_ld_schema_it`, `Father`.`json_ld_schema_eng`, `Father`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` LEFT JOIN `dbo610494358_stg`.`categories` AS `Father` ON (`Category`.`father` = `Father`.`id`) WHERE `Category`.`id` = '07007' LIMIT 1 | 1 | 1 | 0 | |
| 12 | SELECT `Product`.`id`, `Product`.`father`, `Product`.`ean`, `Product`.`description_it`, `Product`.`description_eng`, `Product`.`description_de`, `Product`.`vat`, `Product`.`measure_unit`, `Product`.`price`, `Product`.`list_price`, `Product`.`list_price_blue`, `Product`.`offer_price`, `Product`.`shop_price`, `Product`.`supplier_code`, `Product`.`supplier_name`, `Product`.`osculati_accessory`, `Product`.`weight`, `Product`.`quantity`, `Product`.`supplier_quantity`, `Product`.`minimum_quantity`, `Product`.`always_available`, `Product`.`category_id`, `Product`.`upper_category_id`, `Product`.`category_id2`, `Product`.`upper_category_id2`, `Product`.`attributes_it`, `Product`.`attributes_eng`, `Product`.`attributes_de`, `Product`.`photo`, `Product`.`alternative_description_it`, `Product`.`alternative_description_eng`, `Product`.`alternative_description_de`, `Product`.`html_title_it`, `Product`.`html_title_eng`, `Product`.`html_title_de`, `Product`.`catalog_page`, `Product`.`suggested`, `Product`.`published`, `Product`.`out_of_production`, `Product`.`ebay_auto_publish`, `Product`.`ebay_sku`, `Product`.`ebay_item_no`, `Product`.`ebay_product_type_it`, `Product`.`ebay_product_type_eng`, `Product`.`ebay_product_type_de`, `Product`.`trovaprezzi`, `Product`.`merchant_center`, `Product`.`slug_ita`, `Product`.`created`, `Product`.`modified`, `Product`.`published_ebay`, `Product`.`published_ebay_world`, `Product`.`waiting_review`, `Product`.`stat_order_count`, `Product`.`stat_total_quantity`, `Product`.`stat_total_price_with_vat`, `Product`.`safety_pictograms`, `Product`.`safety_statements`, `Product`.`safety_component`, `Product`.`manufacturer_id`, `Product`.`metadata`, `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`products` AS `Product` LEFT JOIN `dbo610494358_stg`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) INNER JOIN `dbo610494358_stg`.`products_series` AS `ProductsSeries` ON (`Product`.`id` = `ProductsSeries`.`product_id` AND `Product`.`published` = 1) WHERE `ProductsSeries`.`series_id` = 45963 | 36 | 36 | 1 | |
| 13 | SELECT `Image`.`id`, `Image`.`name`, `Image`.`series_id`, `Image`.`product_id`, `Image`.`wall_product_id`, `Image`.`created`, `Image`.`modified` FROM `dbo610494358_stg`.`images` AS `Image` WHERE `Image`.`product_id` IN ('52.431.02', '52.431.04', '52.431.06', '52.432.01', '52.432.02', '52.432.03', '52.432.04', '52.433.01', '52.433.02', '52.433.03', '52.433.04', '52.433.05', '52.434.01', '52.434.02', '52.434.03', '52.434.04', '52.434.05', '52.434.06', '52.435.01', '52.435.02', '52.435.03', '52.435.04', '52.435.05', '52.435.06', '52.435.07', '52.435.08', '52.436.01', '52.436.02', '52.436.04', '52.478.03', '52.478.04', '52.478.05', '52.479.04', '52.479.05', '52.479.06', '52.479.07') | 36 | 36 | 1 | |
| 14 | SELECT `Serie`.`id`, `Serie`.`name_it`, `Serie`.`name_eng`, `Serie`.`name_de`, `Serie`.`summary_it`, `Serie`.`summary_eng`, `Serie`.`summary_de`, `Serie`.`description_it`, `Serie`.`description_eng`, `Serie`.`description_de`, `Serie`.`html_title_it`, `Serie`.`html_meta_it`, `Serie`.`html_meta_eng`, `Serie`.`html_meta_de`, `Serie`.`html_title_eng`, `Serie`.`html_title_de`, `Serie`.`category_id`, `Serie`.`category_id2`, `Serie`.`upper_category_id2`, `Serie`.`upper_category_id`, `Serie`.`photo`, `Serie`.`attributes_it`, `Serie`.`attributes_eng`, `Serie`.`attributes_de`, `Serie`.`active`, `Serie`.`start_price`, `Serie`.`end_price`, `Serie`.`supplier_name`, `Serie`.`created`, `Serie`.`modified`, `Serie`.`attribute_variants`, `Serie`.`description_bottom_de`, `Serie`.`description_bottom_eng`, `Serie`.`description_bottom_it`, `Serie`.`brands`, `ProductsSeries`.`product_id`, `ProductsSeries`.`series_id` FROM `dbo610494358_stg`.`series` AS `Serie` JOIN `dbo610494358_stg`.`products_series` AS `ProductsSeries` ON (`ProductsSeries`.`product_id` IN ('52.431.02', '52.431.04', '52.431.06', '52.432.01', '52.432.02', '52.432.03', '52.432.04', '52.433.01', '52.433.02', '52.433.03', '52.433.04', '52.433.05', '52.434.01', '52.434.02', '52.434.03', '52.434.04', '52.434.05', '52.434.06', '52.435.01', '52.435.02', '52.435.03', '52.435.04', '52.435.05', '52.435.06', '52.435.07', '52.435.08', '52.436.01', '52.436.02', '52.436.04', '52.478.03', '52.478.04', '52.478.05', '52.479.04', '52.479.05', '52.479.06', '52.479.07') AND `ProductsSeries`.`series_id` = `Serie`.`id`) | 36 | 36 | 1 | |
| 15 | SELECT `Product`.`id`, `Product`.`price`, `Product`.`offer_price`, `Product`.`list_price`, `Product`.`vat`, `Product`.`quantity`, `Product`.`always_available`, `Product`.`photo`, `Product`.`description_it`, `Product`.`supplier_name`, `Serie`.`id`, `Serie`.`name_it`, `Serie`.`description_it` FROM `dbo610494358_stg`.`products` AS `Product` LEFT JOIN `dbo610494358_stg`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) INNER JOIN `dbo610494358_stg`.`products_series` AS `ProductsSeries` ON (`Product`.`id` = `ProductsSeries`.`product_id`) INNER JOIN `dbo610494358_stg`.`series` AS `Serie` ON (`Serie`.`id` = `ProductsSeries`.`series_id`) WHERE `Serie`.`active` = '1' AND `Product`.`published` = '1' AND `ProductsSeries`.`series_id` != 45963 AND `Serie`.`category_id` = '100200' ORDER BY rand() ASC LIMIT 10 | 10 | 10 | 2 |
