Rocker switches with backlit icons for Marina R II switches

Supplier: Osculati
Additional warning light that lights up when connected. Semi-rigid anti-slip surface, polycarbonate coated in black polyurethane.

From:

2.03 €

Choose the model

SHIPPED WITHIN: 1 DAY 4/5 DAYS NOT AVAILABLE
Code Price VarianteDescription
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane01 - Navigation lights
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane02 - Mooring lights
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane03 - Horn
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane04 - Flap
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane05 - Extractor fan
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane06 - Windscreen wiper
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane07 - Bilge pump
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane08 - Autoclave
2.36€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane09 - Neutral, no symbols
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane10 - Bilge pump "2"
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane11 - Panel lights
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane12 - Stereo
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane13 - Cockpit lights, cabin lights
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane14 - Windlass anchor control
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane15 - Hatch opening
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane16 - Battery parallel
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane17 - Fridge
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane18 - High beam light
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane25 - Cabin lights
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane29 - Gangplank lights
2.98€
PZ
Add
to cart
Semi-rigid polycarbonate anti-skid surface covered with black polyurethane30 - Deck courtesy lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface01 - Navigation lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface02 - Mooring lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface03 - Horn
2.50€
PZ
Add
to cart
Rigid polycarbonate surface04 - Flap
2.50€
PZ
Add
to cart
Rigid polycarbonate surface05 - Extractor fan
2.50€
PZ
Add
to cart
Rigid polycarbonate surface06 - Windscreen wiper
2.50€
PZ
Add
to cart
Rigid polycarbonate surface07 - Bilge pump
2.50€
PZ
Add
to cart
Rigid polycarbonate surface08 - Autoclave
2.03€
PZ
Add
to cart
Rigid polycarbonate surface09 - Neutral, no symbols
2.50€
PZ
Add
to cart
Rigid polycarbonate surface10 - Bilge pump "2"
2.50€
PZ
Add
to cart
Rigid polycarbonate surface11 - Panel lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface12 - Stereo
2.50€
PZ
Add
to cart
Rigid polycarbonate surface13 - Cockpit lights, cabin lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface14 - Windlass anchor control
2.50€
PZ
Add
to cart
Rigid polycarbonate surface15 - Hatch opening
2.50€
PZ
Add
to cart
Rigid polycarbonate surface16 - Battery parallel
2.50€
PZ
Add
to cart
Rigid polycarbonate surface17 - Fridge
2.50€
PZ
Add
to cart
Rigid polycarbonate surface18 - High beam light
2.50€
PZ
Add
to cart
Rigid polycarbonate surface25 - Cabin lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface29 - Gangplank lights
2.50€
PZ
Add
to cart
Rigid polycarbonate surface30 - Deck courtesy lights

Prices are valid for online shop only

Rocker switches with backlit icons for Marina R II switches

Additional warning light that lights up when connected. Semi-rigid anti-slip surface, polycarbonate coated in black polyurethane.

2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
Download PDF
2026pg243
2026pg243
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 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '871b05fb8bfb69365dfbdb9b11504b3f' 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` = 42539 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` = (42539)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` = 42539 AND `ProductsSeries`.`product_id` = `Product`.`id`) 42421
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` = '19275' 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` = '14' 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` = 4253942421
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 ('14.299.01', '14.299.02', '14.299.03', '14.299.04', '14.299.05', '14.299.06', '14.299.07', '14.299.08', '14.299.09', '14.299.10', '14.299.11', '14.299.12', '14.299.13', '14.299.14', '14.299.15', '14.299.16', '14.299.17', '14.299.18', '14.299.25', '14.299.29', '14.299.30', '14.299.40', '14.299.41', '14.299.42', '14.299.43', '14.299.44', '14.299.45', '14.299.46', '14.299.47', '14.299.48', '14.299.49', '14.299.50', '14.299.51', '14.299.52', '14.299.53', '14.299.54', '14.299.55', '14.299.56', '14.299.57', '14.299.65', '14.299.69', '14.299.70')84841
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 ('14.299.01', '14.299.02', '14.299.03', '14.299.04', '14.299.05', '14.299.06', '14.299.07', '14.299.08', '14.299.09', '14.299.10', '14.299.11', '14.299.12', '14.299.13', '14.299.14', '14.299.15', '14.299.16', '14.299.17', '14.299.18', '14.299.25', '14.299.29', '14.299.30', '14.299.40', '14.299.41', '14.299.42', '14.299.43', '14.299.44', '14.299.45', '14.299.46', '14.299.47', '14.299.48', '14.299.49', '14.299.50', '14.299.51', '14.299.52', '14.299.53', '14.299.54', '14.299.55', '14.299.56', '14.299.57', '14.299.65', '14.299.69', '14.299.70') AND `ProductsSeries`.`series_id` = `Serie`.`id`) 42421
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` != 42539 AND `Serie`.`category_id` = '19275' ORDER BY rand() ASC LIMIT 1010103