Italiano
English
A partire da:
46.00 €Scegli il modello
| Codice | Prezzo | Modello | Materiale | Peso | Dimensioni - A (mm) | Dimensioni - B (mm) | Dimensioni - C (mm) | Dimensioni - D (mm) | Dimensioni - E (mm) | Borsa per stivaggio | Dimensioni borsa mm | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
90.90 €
88.70€
PZ
|
Aggiungi al carrello |
AP1ST | Acciaio inox | 1,5 | 412 | 199 | 206 | 5 | 3 | [01.163.01] | 48x24 |
|
|
309.50 €
302.60€
PZ
|
Aggiungi al carrello |
AP5ST | Acciaio inox | 5,1 | 595 | 291 | 301 | 8 | 4 | [01.163.02] | 70x31 |
|
|
464.50 €
455.10€
PZ
|
Aggiungi al carrello |
AP8ST | Acciaio inox | 8 | 664 | 325 | 335 | 10 | 5 | [01.163.02] | 70x31 |
|
|
604.00 €
590.00€
PZ
|
Aggiungi al carrello |
AP11ST | Acciaio inox | 11,4 | 794 | 389 | 402 | 10 | 5 | [01.163.03] | 87x43 |
|
|
824.00 €
805.30€
PZ
|
Aggiungi al carrello |
AP16ST | Acciaio inox | 16,6 | 876 | 428 | 443 | 12 | 6 | [01.163.03] | 87x43 |
|
|
994.00 €
972.40€
PZ
|
Aggiungi al carrello |
AP20ST | Acciaio inox | 19,8 | 955 | 467 | 482 | 12 | 6 | [01.163.04] | 110x50 |
|
|
1349.00 €
1323.50€
PZ
|
Aggiungi al carrello |
AP27ST | Acciaio inox | 27,2 | 1004 | 491 | 506 | 15 | 8 | [01.163.04] | 110x50 |
|
|
46.90 €
46.00€
PZ
|
Aggiungi al carrello |
AP1GZ | HDG | 1,5 | 412 | 199 | 206 | 5 | 3 | [01.163.01] | 48x24 |
|
|
119.50 €
114.50€
PZ
|
Aggiungi al carrello |
AP5GZ | HDG | 5 | 595 | 291 | 301 | 8 | 4 | [01.163.02] | 70x31 |
|
|
179.50 €
173.10€
PZ
|
Aggiungi al carrello |
AP8GZ | HDG | 7,8 | 664 | 325 | 335 | 10 | 5 | [01.163.02] | 70x31 |
|
|
244.50 €
236.70€
PZ
|
Aggiungi al carrello |
AP11GZ | HDG | 11,2 | 794 | 389 | 402 | 10 | 5 | [01.163.03] | 87x43 |
|
|
324.50 €
318.60€
PZ
|
Aggiungi al carrello |
AP16GZ | HDG | 16,3 | 876 | 428 | 443 | 12 | 6 | [01.163.03] | 87x43 |
|
|
399.50 €
389.10€
PZ
|
Aggiungi al carrello |
AP20GZ | HDG | 19,4 | 955 | 467 | 482 | 12 | 6 | [01.163.04] | 110x50 |
|
|
584.00 €
573.20€
PZ
|
Aggiungi al carrello |
AP27GZ | HDG | 26,8 | 1004 | 491 | 506 | 15 | 8 | [01.163.04] | 110x50 |
|
|
204.50 €
197.30€
PZ
|
Aggiungi al carrello |
AP5AL | Alluminio | 1,7 | 595 | 291 | 301 | 8 | 4 | [01.163.02] | 70x31 |
|
|
299.50 €
294.40€
PZ
|
Aggiungi al carrello |
AP8AL | Alluminio | 2,6 | 664 | 325 | 335 | 10 | 5 | [01.163.02] | 70x31 |
|
|
494.50 €
484.80€
PZ
|
Aggiungi al carrello |
AP11AL | Alluminio | 4,5 | 794 | 389 | 402 | 10 | 5 | [01.163.03] | 87x43 |
|
|
634.00 €
619.70€
PZ
|
Aggiungi al carrello |
AP16AL | Alluminio | 6,9 | 876 | 428 | 443 | 12 | 6 | [01.163.03] | 87x43 |
|
|
829.00 €
810.20€
PZ
|
Aggiungi al carrello |
AP20AL | Alluminio | 8,2 | 955 | 467 | 482 | 12 | 6 | [01.163.04] | 110x50 |
|
|
1279.00 €
1256.00€
PZ
|
Aggiungi al carrello |
AP27AL | Alluminio | 11,9 | 1004 | 491 | 506 | 15 | 8 | [01.163.04] | 110x50 |
|
|
1444.00 €
1414.30€
PZ
|
Aggiungi al carrello |
AP31AL | Alluminio | 13,7 | 1075 | 525 | 540 | 20 | 10 | [01.163.05] | 133x63 |
|
|
1714.00 €
1680.10€
PZ
|
Aggiungi al carrello |
AP50AL | Alluminio | 16,5 | 1180 | 577 | 595 | 20 | 10 | [01.163.05] | 133x63 |
|
|
2184.00 €
2141.60€
PZ
|
Aggiungi al carrello |
AP60AL | Alluminio | 20 | 1298 | 635 | 655 | 20 | 10 | [01.163.05] | 133x63 |
| Codice | Prezzo | |
|---|---|---|
|
|
46.90 €
45.50€
PZ
|
Aggiungi al carrello |
|
|
52.90 €
51.60€
PZ
|
Aggiungi al carrello |
|
|
61.90 €
60.70€
PZ
|
Aggiungi al carrello |
|
|
85.90 €
84.30€
PZ
|
Aggiungi al carrello |
|
|
104.50 €
98.30€
PZ
|
Aggiungi al carrello |
Prezzi validi solo per acquisti online
Ancore ANKERPLEX smontabili
Ancore pieghevoli ad alte prestazioni, realizzate in HDG (ferro zincato a caldo), acciaio inox o alluminio anodizzato. Il design brevettato a tre elementi piani garantisce massima tenuta, leggerezza e rapidità di montaggio senza utensili. Ultra-piatta e salvaspazio, è ideale come ancora principale, secondaria o di emergenza per imbarcazioni di ogni tipo.
Prodotti Correlati
Il 90% degli ordini viene spedito in 24H. Vedi subito disponibilità e tempistiche
Lavoriamo e diamo assistenza nautica dal 1982. Troverete personale esperto e gentile nell'assistervi
Scegli tra Paypal, Carta di Credito, Postepay e Bonifico Bancario
Utilizziamo solamente imballaggi provenienti da materiale riciclato all'interno del nostro stesso negozio
| 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` = '9c586b07cb93f1e3378ebc1ae0c77825' 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` = '100996' ORDER BY `Category`.`name_it` 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` = '100997' ORDER BY `Category`.`name_it` 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_it` 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` = '24005' ORDER BY `Category`.`name_it` 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` = '100999' ORDER BY `Category`.`name_it` 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` = 47143 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` = (47143) | 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` = 47143 AND `ProductsSeries`.`product_id` = `Product`.`id`) | 28 | 28 | 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` = '13563' 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` = '1' 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` = 47143 | 28 | 28 | 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 ('01.160.01', '01.160.05', '01.160.08', '01.160.11', '01.160.16', '01.160.20', '01.160.27', '01.161.01', '01.161.05', '01.161.08', '01.161.11', '01.161.16', '01.161.20', '01.161.27', '01.162.05', '01.162.08', '01.162.11', '01.162.16', '01.162.20', '01.162.27', '01.162.31', '01.162.50', '01.162.60', '01.163.01', '01.163.02', '01.163.03', '01.163.04', '01.163.05') | 23 | 23 | 0 | |
| 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 ('01.160.01', '01.160.05', '01.160.08', '01.160.11', '01.160.16', '01.160.20', '01.160.27', '01.161.01', '01.161.05', '01.161.08', '01.161.11', '01.161.16', '01.161.20', '01.161.27', '01.162.05', '01.162.08', '01.162.11', '01.162.16', '01.162.20', '01.162.27', '01.162.31', '01.162.50', '01.162.60', '01.163.01', '01.163.02', '01.163.03', '01.163.04', '01.163.05') AND `ProductsSeries`.`series_id` = `Serie`.`id`) | 28 | 28 | 1 | |
| 15 | SELECT `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` != 47143 AND `Serie`.`category_id` = '13563' ORDER BY rand() ASC LIMIT 10 | 10 | 10 | 1 |
