Viti autofilettanti testa cilindrica taglio a croce, UNI 6954 DIN 7981

Auto AISI 316

Fornitore: Osculati

A partire da:

0.07 €
SPEDIZIONE GRATIS DA 99,00 € DI SPESA (In Italia, fino a 5kg)

Scegli il modello

SPEDIZIONE IN: 1 GIORNO 4/5 GIORNI NON DISPONIBILE
Codice Prezzo misure mmpcs
0.07€
PZ
Aggiungi
al carrello
2,9 x 10200
0.08€
PZ
Aggiungi
al carrello
2,9 x 13200
0.10€
PZ
Aggiungi
al carrello
2,9 x 19200
0.09€
PZ
Aggiungi
al carrello
3,5 x 10200
0.10€
PZ
Aggiungi
al carrello
3,5 x 13200
0.10€
PZ
Aggiungi
al carrello
3,5 x 16200
0.12€
PZ
Aggiungi
al carrello
3,5 x 19100
0.16€
PZ
Aggiungi
al carrello
3,5 x 25100
0.18€
PZ
Aggiungi
al carrello
3,5 x 32100
0.10€
PZ
Aggiungi
al carrello
3,9 x 10200
0.13€
PZ
Aggiungi
al carrello
3,9 x 16100
0.15€
PZ
Aggiungi
al carrello
3,9 x 19100
0.17€
PZ
Aggiungi
al carrello
3,9 x 25100
0.26€
PZ
Aggiungi
al carrello
3,9 x 3250
0.27€
PZ
Aggiungi
al carrello
3,9 x 3850
0.12€
PZ
Aggiungi
al carrello
4,2 x 10100
0.15€
PZ
Aggiungi
al carrello
4,2 x 16100
0.16€
PZ
Aggiungi
al carrello
4,2 x 19100
0.17€
PZ
Aggiungi
al carrello
4,2 x 22100
0.19€
PZ
Aggiungi
al carrello
4,2 x 25100
0.26€
PZ
Aggiungi
al carrello
4,2 x 3250
0.30€
PZ
Aggiungi
al carrello
4,2 x 3850
0.37€
PZ
Aggiungi
al carrello
4,2 x 4550
0.48€
PZ
Aggiungi
al carrello
4,2 x 5025
0.19€
PZ
Aggiungi
al carrello
4,8 x 13100
0.21€
PZ
Aggiungi
al carrello
4,8 x 16100
0.25€
PZ
Aggiungi
al carrello
4,8 x 1950
0.27€
PZ
Aggiungi
al carrello
4,8 x 2250
0.28€
PZ
Aggiungi
al carrello
4,8 x 2550
0.31€
PZ
Aggiungi
al carrello
4,8 x 3250
0.37€
PZ
Aggiungi
al carrello
4,8 x 3850
0.52€
PZ
Aggiungi
al carrello
4,8 x 4525
0.56€
PZ
Aggiungi
al carrello
4,8 x 5025
0.33€
PZ
Aggiungi
al carrello
5,5 x 1650
0.52€
PZ
Aggiungi
al carrello
5,5 x 3225
0.56€
PZ
Aggiungi
al carrello
5,5 x 3825
0.80€
PZ
Aggiungi
al carrello
5,5 x 5025
0.44€
PZ
Aggiungi
al carrello
6,3 x 1950
0.56€
PZ
Aggiungi
al carrello
6,3 x 2525
0.64€
PZ
Aggiungi
al carrello
6,3 x 3225

Prezzi validi solo per acquisti online

Viti autofilettanti testa cilindrica taglio a croce, UNI 6954 DIN 7981

2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF
2026pg666
2026pg666
Scarica PDF

Aderisci alla Newsletter

Iscriviti alla nostra newsletter per essere sempre informato sulle ultime novità.

Ordini veloci

Il 90% degli ordini viene spedito in 24H. Vedi subito disponibilità e tempistiche

Professionisti del settore

Lavoriamo e diamo assistenza nautica dal 1982. Troverete personale esperto e gentile nell'assistervi

Pagamenti sicuri

Scegli tra Paypal, Carta di Credito, Postepay e Bonifico Bancario

Imballaggi riciclati

Utilizziamo solamente imballaggi provenienti da materiale riciclato all'interno del nostro stesso negozio

(default) 15 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'a4eefd4a2f6522c53c212dd8f7042124' LIMIT 1110
2SELECT `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` ASC000
3SELECT `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` ASC000
4SELECT `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` ASC000
5SELECT `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` ASC000
6SELECT `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` ASC000
7SELECT `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` = 13460 LIMIT 1110
8SELECT `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` = (13460)000
9SELECT `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` = 13460 AND `ProductsSeries`.`product_id` = `Product`.`id`) 40401
10SELECT `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` = '13415' LIMIT 1111
11SELECT `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` = '37' LIMIT 1110
12SELECT `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` = 1346040402
13SELECT `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 ('A4-7981-02.9X010', 'A4-7981-02.9X013', 'A4-7981-02.9X019', 'A4-7981-03.5X010', 'A4-7981-03.5X013', 'A4-7981-03.5X016', 'A4-7981-03.5X019', 'A4-7981-03.5X025', 'A4-7981-03.5X032', 'A4-7981-03.9X010', 'A4-7981-03.9X016', 'A4-7981-03.9X019', 'A4-7981-03.9X025', 'A4-7981-03.9X032', 'A4-7981-03.9X038', 'A4-7981-04.2X010', 'A4-7981-04.2X016', 'A4-7981-04.2X019', 'A4-7981-04.2X022', 'A4-7981-04.2X025', 'A4-7981-04.2X032', 'A4-7981-04.2X038', 'A4-7981-04.2X045', 'A4-7981-04.2X050', 'A4-7981-04.8X013', 'A4-7981-04.8X016', 'A4-7981-04.8X019', 'A4-7981-04.8X022', 'A4-7981-04.8X025', 'A4-7981-04.8X032', 'A4-7981-04.8X038', 'A4-7981-04.8X045', 'A4-7981-04.8X050', 'A4-7981-05.5X016', 'A4-7981-05.5X032', 'A4-7981-05.5X038', 'A4-7981-05.5X050', 'A4-7981-06.3X019', 'A4-7981-06.3X025', 'A4-7981-06.3X032')1601602
14SELECT `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 ('A4-7981-02.9X010', 'A4-7981-02.9X013', 'A4-7981-02.9X019', 'A4-7981-03.5X010', 'A4-7981-03.5X013', 'A4-7981-03.5X016', 'A4-7981-03.5X019', 'A4-7981-03.5X025', 'A4-7981-03.5X032', 'A4-7981-03.9X010', 'A4-7981-03.9X016', 'A4-7981-03.9X019', 'A4-7981-03.9X025', 'A4-7981-03.9X032', 'A4-7981-03.9X038', 'A4-7981-04.2X010', 'A4-7981-04.2X016', 'A4-7981-04.2X019', 'A4-7981-04.2X022', 'A4-7981-04.2X025', 'A4-7981-04.2X032', 'A4-7981-04.2X038', 'A4-7981-04.2X045', 'A4-7981-04.2X050', 'A4-7981-04.8X013', 'A4-7981-04.8X016', 'A4-7981-04.8X019', 'A4-7981-04.8X022', 'A4-7981-04.8X025', 'A4-7981-04.8X032', 'A4-7981-04.8X038', 'A4-7981-04.8X045', 'A4-7981-04.8X050', 'A4-7981-05.5X016', 'A4-7981-05.5X032', 'A4-7981-05.5X038', 'A4-7981-05.5X050', 'A4-7981-06.3X019', 'A4-7981-06.3X025', 'A4-7981-06.3X032') AND `ProductsSeries`.`series_id` = `Serie`.`id`) 40402
15SELECT `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` != 13460 AND `Serie`.`category_id` = '13415' ORDER BY rand() ASC LIMIT 1010103