Viti testa esagonale interamente filettate UNI 5739 DIN 933

Bull esagonale AISI 304

Fornitore: Osculati

A partire da:

0.16 €
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.16€
PZ
Aggiungi
al carrello
4 x 12100
0.20€
PZ
Aggiungi
al carrello
4 x 20100
0.25€
PZ
Aggiungi
al carrello
4 x 30100
0.34€
PZ
Aggiungi
al carrello
4 x 4050
0.16€
PZ
Aggiungi
al carrello
5 x 16100
0.19€
PZ
Aggiungi
al carrello
5 x 20100
0.23€
PZ
Aggiungi
al carrello
5 x 30100
0.29€
PZ
Aggiungi
al carrello
5 x 4050
0.44€
PZ
Aggiungi
al carrello
5 x 5050
0.19€
PZ
Aggiungi
al carrello
6 x 16100
0.20€
PZ
Aggiungi
al carrello
6 x 20100
0.23€
PZ
Aggiungi
al carrello
6 x 25100
0.28€
PZ
Aggiungi
al carrello
6 x 3050
0.31€
PZ
Aggiungi
al carrello
6 x 3550
0.34€
PZ
Aggiungi
al carrello
6 x 4050
0.37€
PZ
Aggiungi
al carrello
6 x 4550
0.40€
PZ
Aggiungi
al carrello
6 x 5050
0.58€
PZ
Aggiungi
al carrello
6 x 5525
0.60€
PZ
Aggiungi
al carrello
6 x 6025
0.78€
PZ
Aggiungi
al carrello
6 x 6525
0.84€
PZ
Aggiungi
al carrello
6 x 7025
0.96€
PZ
Aggiungi
al carrello
6 x 7525
1.00€
PZ
Aggiungi
al carrello
6 x 8025
1.44€
PZ
Aggiungi
al carrello
6 x 10010
0.46€
PZ
Aggiungi
al carrello
8 x 2525
0.50€
PZ
Aggiungi
al carrello
8 x 3025
0.60€
PZ
Aggiungi
al carrello
8 x 4025
0.72€
PZ
Aggiungi
al carrello
8 x 5025
0.84€
PZ
Aggiungi
al carrello
8 x 6025
1.16€
PZ
Aggiungi
al carrello
8 x 7025
1.32€
PZ
Aggiungi
al carrello
8 x 8025
2.09€
PZ
Aggiungi
al carrello
8 x 10010
2.69€
PZ
Aggiungi
al carrello
8 x 12010
0.92€
PZ
Aggiungi
al carrello
10 x 4025
1.20€
PZ
Aggiungi
al carrello
10 x 5025
1.40€
PZ
Aggiungi
al carrello
10 x 6025
1.99€
PZ
Aggiungi
al carrello
10 x 8010
2.99€
PZ
Aggiungi
al carrello
10 x 10010
4.29€
PZ
Aggiungi
al carrello
10 x 12010
1.56€
PZ
Aggiungi
al carrello
12 x 4525
1.94€
PZ
Aggiungi
al carrello
12 x 6010
2.89€
PZ
Aggiungi
al carrello
12 x 8010
3.69€
PZ
Aggiungi
al carrello
12 x 10010
5.38€
PZ
Aggiungi
al carrello
12 x 1205
6.78€
PZ
Aggiungi
al carrello
12 x 150 parz filet5

Prezzi validi solo per acquisti online

Viti testa esagonale interamente filettate UNI 5739 DIN 933

2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
Scarica PDF
2026pg670
2026pg670
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 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'c5dc7550ccb5e9d9406612be5c629c24' 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` = 13421 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` = (13421)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` = 13421 AND `ProductsSeries`.`product_id` = `Product`.`id`) 76761
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` = '14616' LIMIT 1110
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` = 1342145452
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 ('A2-933-04X012', 'A2-933-04X020', 'A2-933-04X030', 'A2-933-04X040', 'A2-933-05X016', 'A2-933-05X020', 'A2-933-05X030', 'A2-933-05X040', 'A2-933-05X050', 'A2-933-06X016', 'A2-933-06X020', 'A2-933-06X025', 'A2-933-06X030', 'A2-933-06X035', 'A2-933-06X040', 'A2-933-06X045', 'A2-933-06X050', 'A2-933-06X055', 'A2-933-06X060', 'A2-933-06X065', 'A2-933-06X070', 'A2-933-06X075', 'A2-933-06X080', 'A2-933-06X100', 'A2-933-08X025', 'A2-933-08X030', 'A2-933-08X040', 'A2-933-08X050', 'A2-933-08X060', 'A2-933-08X070', 'A2-933-08X080', 'A2-933-08X100', 'A2-933-08X120', 'A2-933-10X040', 'A2-933-10X050', 'A2-933-10X060', 'A2-933-10X080', 'A2-933-10X100', 'A2-933-10X120', 'A2-933-12X045', 'A2-933-12X060', 'A2-933-12X080', 'A2-933-12X100', 'A2-933-12X120', 'A2-933-12X150')45451
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 ('A2-933-04X012', 'A2-933-04X020', 'A2-933-04X030', 'A2-933-04X040', 'A2-933-05X016', 'A2-933-05X020', 'A2-933-05X030', 'A2-933-05X040', 'A2-933-05X050', 'A2-933-06X016', 'A2-933-06X020', 'A2-933-06X025', 'A2-933-06X030', 'A2-933-06X035', 'A2-933-06X040', 'A2-933-06X045', 'A2-933-06X050', 'A2-933-06X055', 'A2-933-06X060', 'A2-933-06X065', 'A2-933-06X070', 'A2-933-06X075', 'A2-933-06X080', 'A2-933-06X100', 'A2-933-08X025', 'A2-933-08X030', 'A2-933-08X040', 'A2-933-08X050', 'A2-933-08X060', 'A2-933-08X070', 'A2-933-08X080', 'A2-933-08X100', 'A2-933-08X120', 'A2-933-10X040', 'A2-933-10X050', 'A2-933-10X060', 'A2-933-10X080', 'A2-933-10X100', 'A2-933-10X120', 'A2-933-12X045', 'A2-933-12X060', 'A2-933-12X080', 'A2-933-12X100', 'A2-933-12X120', 'A2-933-12X150') AND `ProductsSeries`.`series_id` = `Serie`.`id`) 45451
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` != 13421 AND `Serie`.`category_id` = '14616' ORDER BY rand() ASC LIMIT 1010107