Cross-recessed raised countersunk head self-tapping screws - UNI 6956 DIN 7983

Cross-recessed raised countersunk head self-tapping screws - UNI DIN

Supplier: Osculati

From:

0.05 €

Choose the model

SHIPPED WITHIN: 1 DAY 4/5 DAYS NOT AVAILABLE
Code Price misure mmpcs
0.05€
PZ
Add
to cart
2.9 x 13200
0.05€
PZ
Add
to cart
2.9 x 19200
0.05€
PZ
Add
to cart
3.5 x 10200
0.05€
PZ
Add
to cart
3.5 x 13200
0.05€
PZ
Add
to cart
3.5 x 16200
0.06€
PZ
Add
to cart
3.5 x 19200
0.09€
PZ
Add
to cart
3.5 x 25100
0.10€
PZ
Add
to cart
3.5 x 32100
0.12€
PZ
Add
to cart
3.5 x 38100
0.06€
PZ
Add
to cart
3,9 x 10 mm200
0.07€
PZ
Add
to cart
3.9 x 16200
0.08€
PZ
Add
to cart
3.9 x 19200
0.10€
PZ
Add
to cart
3.9 x 22100
0.10€
PZ
Add
to cart
3.9 x 25100
0.13€
PZ
Add
to cart
3.9 x 32100
0.14€
PZ
Add
to cart
3.9 x 38100
0.07€
PZ
Add
to cart
4,2 x 10 mm200
0.07€
PZ
Add
to cart
4,2 x 13 mm200
0.08€
PZ
Add
to cart
4.2 x 16200
0.09€
PZ
Add
to cart
4.2 x 19100
0.10€
PZ
Add
to cart
4.2 x 22100
0.10€
PZ
Add
to cart
4.2 x 25100
0.13€
PZ
Add
to cart
4.2 x 32100
0.16€
PZ
Add
to cart
4.2 x 38100
0.20€
PZ
Add
to cart
4.2 x 45100
0.25€
PZ
Add
to cart
4.2 x 5050
0.11€
PZ
Add
to cart
4.8 x 13100
0.12€
PZ
Add
to cart
4.8 x 16100
0.13€
PZ
Add
to cart
4.8 x 19100
0.14€
PZ
Add
to cart
4.8 x 22100
0.15€
PZ
Add
to cart
4.8 x 25100
0.16€
PZ
Add
to cart
4.8 x 32100
0.21€
PZ
Add
to cart
4.8 x 3850
0.27€
PZ
Add
to cart
4.8 x 4550
0.30€
PZ
Add
to cart
4.8 x 5050
0.18€
PZ
Add
to cart
5.5 x 1650
0.22€
PZ
Add
to cart
5.5 x 2250
0.28€
PZ
Add
to cart
5.5 x 3250
0.30€
PZ
Add
to cart
5.5 x 3850
0.46€
PZ
Add
to cart
5.5 x 5025
0.25€
PZ
Add
to cart
6.3 x 1950
0.30€
PZ
Add
to cart
6.3 x 2550
0.36€
PZ
Add
to cart
6.3 x 3225
0.50€
PZ
Add
to cart
6.3 x 4525
0.60€
PZ
Add
to cart
6.3 x 6025

Prices are valid for online shop only

Cross-recessed raised countersunk head self-tapping screws - UNI 6956 DIN 7983

2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2024pg609
2024pg609
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2024pg609
2024pg609
Download PDF
2024pg609
2024pg609
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
Download PDF
2026pg669
2026pg669
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 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '6ccc451a26dca1c092ad31815e9a6c9f' 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` = 13417 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` = (13417)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` = 13417 AND `ProductsSeries`.`product_id` = `Product`.`id`) 61612
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 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` = 1341745451
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-7983-02.9X013', 'A2-7983-02.9X019', 'A2-7983-03.5X010', 'A2-7983-03.5X013', 'A2-7983-03.5X016', 'A2-7983-03.5X019', 'A2-7983-03.5X025', 'A2-7983-03.5X032', 'A2-7983-03.5X038', 'A2-7983-03.9X010', 'A2-7983-03.9X016', 'A2-7983-03.9X019', 'A2-7983-03.9X022', 'A2-7983-03.9X025', 'A2-7983-03.9X032', 'A2-7983-03.9X038', 'A2-7983-04.2X010', 'A2-7983-04.2X013', 'A2-7983-04.2X016', 'A2-7983-04.2X019', 'A2-7983-04.2X022', 'A2-7983-04.2X025', 'A2-7983-04.2X032', 'A2-7983-04.2X038', 'A2-7983-04.2X045', 'A2-7983-04.2X050', 'A2-7983-04.8X013', 'A2-7983-04.8X016', 'A2-7983-04.8X019', 'A2-7983-04.8X022', 'A2-7983-04.8X025', 'A2-7983-04.8X032', 'A2-7983-04.8X038', 'A2-7983-04.8X045', 'A2-7983-04.8X050', 'A2-7983-05.5X016', 'A2-7983-05.5X022', 'A2-7983-05.5X032', 'A2-7983-05.5X038', 'A2-7983-05.5X050', 'A2-7983-06.3X019', 'A2-7983-06.3X025', 'A2-7983-06.3X032', 'A2-7983-06.3X045', 'A2-7983-06.3X060')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-7983-02.9X013', 'A2-7983-02.9X019', 'A2-7983-03.5X010', 'A2-7983-03.5X013', 'A2-7983-03.5X016', 'A2-7983-03.5X019', 'A2-7983-03.5X025', 'A2-7983-03.5X032', 'A2-7983-03.5X038', 'A2-7983-03.9X010', 'A2-7983-03.9X016', 'A2-7983-03.9X019', 'A2-7983-03.9X022', 'A2-7983-03.9X025', 'A2-7983-03.9X032', 'A2-7983-03.9X038', 'A2-7983-04.2X010', 'A2-7983-04.2X013', 'A2-7983-04.2X016', 'A2-7983-04.2X019', 'A2-7983-04.2X022', 'A2-7983-04.2X025', 'A2-7983-04.2X032', 'A2-7983-04.2X038', 'A2-7983-04.2X045', 'A2-7983-04.2X050', 'A2-7983-04.8X013', 'A2-7983-04.8X016', 'A2-7983-04.8X019', 'A2-7983-04.8X022', 'A2-7983-04.8X025', 'A2-7983-04.8X032', 'A2-7983-04.8X038', 'A2-7983-04.8X045', 'A2-7983-04.8X050', 'A2-7983-05.5X016', 'A2-7983-05.5X022', 'A2-7983-05.5X032', 'A2-7983-05.5X038', 'A2-7983-05.5X050', 'A2-7983-06.3X019', 'A2-7983-06.3X025', 'A2-7983-06.3X032', 'A2-7983-06.3X045', 'A2-7983-06.3X060') 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_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` != 13417 AND `Serie`.`category_id` = '14616' ORDER BY rand() ASC LIMIT 1010109