Self tapping screw cross head, countersunk, UNI 6955 DIN 7982

Self tapping crosshead screw AISI 316

Supplier: Osculati

From:

0.07 €

Choose the model

SHIPPED WITHIN: 1 DAY 4/5 DAYS NOT AVAILABLE
Code Price misure mmpcs
0.07€
PZ
Add
to cart
2.9 x 10200
0.08€
PZ
Add
to cart
2.9 x 13200
0.10€
PZ
Add
to cart
2.9 x 19200
0.09€
PZ
Add
to cart
3.5 x 10200
0.10€
PZ
Add
to cart
3.5 x 13200
0.10€
PZ
Add
to cart
3.5 x 16200
0.12€
PZ
Add
to cart
3.5 x 19100
0.16€
PZ
Add
to cart
3.5 x 25100
0.18€
PZ
Add
to cart
3.5 x 32100
0.22€
PZ
Add
to cart
3.5 x 3850
0.10€
PZ
Add
to cart
3.9 x 10200
0.13€
PZ
Add
to cart
3.9 x 16100
0.15€
PZ
Add
to cart
3.9 x 19100
0.17€
PZ
Add
to cart
3.9 x 22100
0.17€
PZ
Add
to cart
3.9 x 25100
0.26€
PZ
Add
to cart
3.9 x 3250
0.27€
PZ
Add
to cart
3.9 x 3850
0.12€
PZ
Add
to cart
4.2 x 10100
0.15€
PZ
Add
to cart
4.2 x 16100
0.16€
PZ
Add
to cart
4.2 x 19100
0.17€
PZ
Add
to cart
4.2 x 22100
0.19€
PZ
Add
to cart
4.2 x 25100
0.26€
PZ
Add
to cart
4.2 x 3250
0.30€
PZ
Add
to cart
4.2 x 3850
0.37€
PZ
Add
to cart
4.2 x 4550
0.48€
PZ
Add
to cart
4.2 x 5025
0.19€
PZ
Add
to cart
4.8 x 13100
0.21€
PZ
Add
to cart
4.8 x 16100
0.25€
PZ
Add
to cart
4.8 x 1950
0.27€
PZ
Add
to cart
4.8 x 2250
0.28€
PZ
Add
to cart
4.8 x 2550
0.31€
PZ
Add
to cart
4.8 x 3250
0.37€
PZ
Add
to cart
4.8 x 3850
0.52€
PZ
Add
to cart
4.8 x 4525
0.56€
PZ
Add
to cart
4.8 x 5025
0.33€
PZ
Add
to cart
5.5 x 1650
0.39€
PZ
Add
to cart
5.5 x 2250
0.52€
PZ
Add
to cart
5.5 x 3225
0.56€
PZ
Add
to cart
5.5 x 3825
0.80€
PZ
Add
to cart
5.5 x 5025
0.44€
PZ
Add
to cart
6.3 x 1950
0.56€
PZ
Add
to cart
6.3 x 2525
0.64€
PZ
Add
to cart
6.3 x 3225
0.88€
PZ
Add
to cart
6.3 x 4525
1.14€
PZ
Add
to cart
6.3 x 6010

Prices are valid for online shop only

Self tapping screw cross head, countersunk, UNI 6955 DIN 7982

2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF
2026pg666
2026pg666
Download PDF

Subscribe our newsletter

Subscribe to our newsletter to keep up to date with the latest news.

Fast Shipment

90% of the orders are shipped within 24H. Have a look at the availability and shipment time in the product page

Boating professionals

We work on boating since 1982. You will find experienced and polite staff

Secure payments

You can choose between Paypal, Credit Card, Postepay and Transfer

Recycled packaging

We only use packaging from recycled material within our own store

(default) 15 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '4f704b77883b223f5ede0c9004dd2d10' 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` = '100997' ORDER BY `Category`.`name_eng` 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` = '100996' ORDER BY `Category`.`name_eng` 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_eng` 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` = '100999' ORDER BY `Category`.`name_eng` 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` = '24005' ORDER BY `Category`.`name_eng` 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` = 13461 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` = (13461)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` = 13461 AND `ProductsSeries`.`product_id` = `Product`.`id`) 45451
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 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` = 1346145451
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-7982-02.9X010', 'A4-7982-02.9X013', 'A4-7982-02.9X019', 'A4-7982-03.5X010', 'A4-7982-03.5X013', 'A4-7982-03.5X016', 'A4-7982-03.5X019', 'A4-7982-03.5X025', 'A4-7982-03.5X032', 'A4-7982-03.5X038', 'A4-7982-03.9X010', 'A4-7982-03.9X016', 'A4-7982-03.9X019', 'A4-7982-03.9X022', 'A4-7982-03.9X025', 'A4-7982-03.9X032', 'A4-7982-03.9X038', 'A4-7982-04.2X010', 'A4-7982-04.2X016', 'A4-7982-04.2X019', 'A4-7982-04.2X022', 'A4-7982-04.2X025', 'A4-7982-04.2X032', 'A4-7982-04.2X038', 'A4-7982-04.2X045', 'A4-7982-04.2X050', 'A4-7982-04.8X013', 'A4-7982-04.8X016', 'A4-7982-04.8X019', 'A4-7982-04.8X022', 'A4-7982-04.8X025', 'A4-7982-04.8X032', 'A4-7982-04.8X038', 'A4-7982-04.8X045', 'A4-7982-04.8X050', 'A4-7982-05.5X016', 'A4-7982-05.5X022', 'A4-7982-05.5X032', 'A4-7982-05.5X038', 'A4-7982-05.5X050', 'A4-7982-06.3X019', 'A4-7982-06.3X025', 'A4-7982-06.3X032', 'A4-7982-06.3X045', 'A4-7982-06.3X060')1801801
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-7982-02.9X010', 'A4-7982-02.9X013', 'A4-7982-02.9X019', 'A4-7982-03.5X010', 'A4-7982-03.5X013', 'A4-7982-03.5X016', 'A4-7982-03.5X019', 'A4-7982-03.5X025', 'A4-7982-03.5X032', 'A4-7982-03.5X038', 'A4-7982-03.9X010', 'A4-7982-03.9X016', 'A4-7982-03.9X019', 'A4-7982-03.9X022', 'A4-7982-03.9X025', 'A4-7982-03.9X032', 'A4-7982-03.9X038', 'A4-7982-04.2X010', 'A4-7982-04.2X016', 'A4-7982-04.2X019', 'A4-7982-04.2X022', 'A4-7982-04.2X025', 'A4-7982-04.2X032', 'A4-7982-04.2X038', 'A4-7982-04.2X045', 'A4-7982-04.2X050', 'A4-7982-04.8X013', 'A4-7982-04.8X016', 'A4-7982-04.8X019', 'A4-7982-04.8X022', 'A4-7982-04.8X025', 'A4-7982-04.8X032', 'A4-7982-04.8X038', 'A4-7982-04.8X045', 'A4-7982-04.8X050', 'A4-7982-05.5X016', 'A4-7982-05.5X022', 'A4-7982-05.5X032', 'A4-7982-05.5X038', 'A4-7982-05.5X050', 'A4-7982-06.3X019', 'A4-7982-06.3X025', 'A4-7982-06.3X032', 'A4-7982-06.3X045', 'A4-7982-06.3X060') AND `ProductsSeries`.`series_id` = `Serie`.`id`) 45452
15SELECT `Product`.`id`, `Product`.`price`, `Product`.`offer_price`, `Product`.`list_price`, `Product`.`vat`, `Product`.`quantity`, `Product`.`always_available`, `Product`.`photo`, `Product`.`description_eng`, `Product`.`supplier_name`, `Serie`.`id`, `Serie`.`name_eng`, `Serie`.`description_eng` 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` != 13461 AND `Serie`.`category_id` = '13415' ORDER BY rand() ASC LIMIT 1010104