Italiano
English
From:
117.50 €Choose the model
| Code | Price | Version | Length mm | |
|---|---|---|---|---|
|
|
124.50 €
117.50€
PZ
|
Add to cart |
Fuel | 150 |
|
|
124.50 €
117.50€
PZ
|
Add to cart |
Fuel | 170 |
|
|
124.50 €
117.50€
PZ
|
Add to cart |
Fuel | 200 |
|
|
124.50 €
118.80€
PZ
|
Add to cart |
Fuel | 225 |
|
|
124.50 €
120.10€
PZ
|
Add to cart |
Fuel | 250 |
|
|
129.50 €
121.30€
PZ
|
Add to cart |
Fuel | 275 |
|
|
129.50 €
122.00€
PZ
|
Add to cart |
Fuel | 300 |
|
|
134.50 €
125.90€
PZ
|
Add to cart |
Fuel | 350 |
|
|
134.50 €
128.40€
PZ
|
Add to cart |
Fuel | 400 |
|
|
134.50 €
130.40€
PZ
|
Add to cart |
Fuel | 450 |
|
|
139.50 €
134.20€
PZ
|
Add to cart |
Fuel | 500 |
|
|
144.50 €
140.10€
PZ
|
Add to cart |
Fuel | 550 |
|
|
144.50 €
139.40€
PZ
|
Add to cart |
Fuel | 600 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Water | 150 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Water | 170 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Water | 200 |
|
|
139.50 €
134.60€
PZ
|
Add to cart |
Water | 225 |
|
|
144.50 €
136.10€
PZ
|
Add to cart |
Water | 250 |
|
|
144.50 €
137.50€
PZ
|
Add to cart |
Water | 275 |
|
|
144.50 €
138.30€
PZ
|
Add to cart |
Water | 300 |
|
|
149.50 €
142.60€
PZ
|
Add to cart |
Water | 350 |
|
|
154.50 €
145.50€
PZ
|
Add to cart |
Water | 400 |
|
|
154.50 €
147.70€
PZ
|
Add to cart |
Water | 450 |
|
|
159.50 €
152.10€
PZ
|
Add to cart |
Water | 500 |
|
|
164.50 €
158.60€
PZ
|
Add to cart |
Water | 550 |
|
|
164.50 €
157.90€
PZ
|
Add to cart |
Water | 600 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Grey water | 150 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Grey water | 170 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Grey water | 200 |
|
|
139.50 €
134.60€
PZ
|
Add to cart |
Grey water | 225 |
|
|
144.50 €
136.10€
PZ
|
Add to cart |
Grey water | 250 |
|
|
144.50 €
137.50€
PZ
|
Add to cart |
Grey water | 275 |
|
|
144.50 €
138.30€
PZ
|
Add to cart |
Grey water | 300 |
|
|
149.50 €
142.60€
PZ
|
Add to cart |
Grey water | 350 |
|
|
154.50 €
145.50€
PZ
|
Add to cart |
Grey water | 400 |
|
|
154.50 €
147.70€
PZ
|
Add to cart |
Grey water | 450 |
|
|
159.50 €
152.10€
PZ
|
Add to cart |
Grey water | 500 |
|
|
164.50 €
158.60€
PZ
|
Add to cart |
Grey water | 550 |
|
|
164.50 €
157.90€
PZ
|
Add to cart |
Grey water | 600 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Black water | 150 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Black water | 170 |
|
|
139.50 €
133.20€
PZ
|
Add to cart |
Black water | 200 |
|
|
139.50 €
134.60€
PZ
|
Add to cart |
Black water | 225 |
|
|
144.50 €
136.10€
PZ
|
Add to cart |
Black water | 250 |
|
|
144.50 €
137.50€
PZ
|
Add to cart |
Black water | 275 |
|
|
144.50 €
138.30€
PZ
|
Add to cart |
Black water | 300 |
|
|
149.50 €
142.60€
PZ
|
Add to cart |
Black water | 350 |
|
|
154.50 €
145.50€
PZ
|
Add to cart |
Black water | 400 |
|
|
154.50 €
147.70€
PZ
|
Add to cart |
Black water | 450 |
|
|
159.50 €
152.10€
PZ
|
Add to cart |
Black water | 500 |
|
|
164.50 €
158.60€
PZ
|
Add to cart |
Black water | 550 |
|
|
164.50 €
157.90€
PZ
|
Add to cart |
Black water | 600 |
Prices are valid for online shop only
NMEA 2000 S3 level sensor with output signal
International flange S3. Suitable for systems 12 and 24V. External protection IP65. Made of stainless steel.
Level sensors are programmed to indicate the use of the tank (ex. black/grey/freshwater - fuel) and, if communicated when ordering the items, the volume that will be expressed in litres instead of in percentage. In case more than one tank for the same liquid is present onboard, the order shall also indicate the numbering of the tanks (ex. 1 - 2 - 3).
All sensors can be reprogrammed (e.g., black / grey / white water - fuel) and the tank capacity can be added using the NMEA 2000 programmer (type our article 27.165.00).
Prodotti Correlati
90% of the orders are shipped within 24H. Have a look at the availability and shipment time in the product page
We work on boating since 1982. You will find experienced and polite staff
You can choose between Paypal, Credit Card, Postepay and Transfer
We only use packaging from recycled material within our own store
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '044ae68578f71edc0cacbfd61cdb2709' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `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` ASC | 0 | 0 | 0 | |
| 3 | SELECT `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` ASC | 0 | 0 | 0 | |
| 4 | SELECT `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` ASC | 0 | 0 | 0 | |
| 5 | SELECT `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` ASC | 0 | 0 | 0 | |
| 6 | SELECT `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` ASC | 0 | 0 | 0 | |
| 7 | SELECT `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` = 46936 LIMIT 1 | 1 | 1 | 0 | |
| 8 | SELECT `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` = (46936) | 0 | 0 | 0 | |
| 9 | SELECT `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` = 46936 AND `ProductsSeries`.`product_id` = `Product`.`id`) | 52 | 52 | 1 | |
| 10 | SELECT `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` = '19300' LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `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` = '27' LIMIT 1 | 1 | 1 | 0 | |
| 12 | SELECT `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` = 46936 | 52 | 52 | 1 | |
| 13 | SELECT `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 ('27.174.15', '27.174.17', '27.174.20', '27.174.22', '27.174.25', '27.174.28', '27.174.30', '27.174.35', '27.174.40', '27.174.45', '27.174.50', '27.174.55', '27.174.60', '27.177.15', '27.177.17', '27.177.20', '27.177.22', '27.177.25', '27.177.28', '27.177.30', '27.177.35', '27.177.40', '27.177.45', '27.177.50', '27.177.55', '27.177.60', '27.178.15', '27.178.17', '27.178.20', '27.178.22', '27.178.25', '27.178.28', '27.178.30', '27.178.35', '27.178.40', '27.178.45', '27.178.50', '27.178.55', '27.178.60', '27.179.15', '27.179.17', '27.179.20', '27.179.22', '27.179.25', '27.179.28', '27.179.30', '27.179.35', '27.179.40', '27.179.45', '27.179.50', '27.179.55', '27.179.60') | 104 | 104 | 1 | |
| 14 | SELECT `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 ('27.174.15', '27.174.17', '27.174.20', '27.174.22', '27.174.25', '27.174.28', '27.174.30', '27.174.35', '27.174.40', '27.174.45', '27.174.50', '27.174.55', '27.174.60', '27.177.15', '27.177.17', '27.177.20', '27.177.22', '27.177.25', '27.177.28', '27.177.30', '27.177.35', '27.177.40', '27.177.45', '27.177.50', '27.177.55', '27.177.60', '27.178.15', '27.178.17', '27.178.20', '27.178.22', '27.178.25', '27.178.28', '27.178.30', '27.178.35', '27.178.40', '27.178.45', '27.178.50', '27.178.55', '27.178.60', '27.179.15', '27.179.17', '27.179.20', '27.179.22', '27.179.25', '27.179.28', '27.179.30', '27.179.35', '27.179.40', '27.179.45', '27.179.50', '27.179.55', '27.179.60') AND `ProductsSeries`.`series_id` = `Serie`.`id`) | 52 | 52 | 1 | |
| 15 | SELECT `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` != 46936 AND `Serie`.`category_id` = '19300' ORDER BY rand() ASC LIMIT 10 | 10 | 10 | 2 |
