Kit navigazione MARSUPIO aggiornato al DM n°133 del 21/09/2024

Kit marsupio persone entro miglia

Fornitore: Osculati
Kit di navigazione entro le 3 miglia / 12 miglia da 4 o da 6 persone completo di borsa che può servire da morbido cuscino.

A partire da:

155.20 €
SPEDIZIONE GRATIS DA 99,00 € DI SPESA (In Italia, fino a 5kg)

Scegli il modello

SPEDIZIONE IN: 1 GIORNO 4/5 GIORNI NON DISPONIBILE
Codice Prezzo Regolamentare entroContenuto - n.giubbetti CEContenuto - estitntoreContenuto - bandiera italianaContenuto - cima per ancoraContenuto - ancora a ombrelloContenuto - segnali di soccorso contenuti nel kitContenuto - cima per anulariContenuto - gancio accostoContenuto - segnale acusticoContenuto - boettaContenuto - segnalatore luminoso automaticoContenuto - tabella segnali visivi (Colreg)Contenuto - pallone nero di fonda
194.50 € 190.20€
PZ
Aggiungi
al carrello
3 miglia4 x 22.60.02[31.450.00][35.459.01][01.106.00][01.139.25][30.230.01][22.408.06][34.171.40][21.462.30]-NONO[30.654.00]
239.50 € 239.00€
PZ
Aggiungi
al carrello
3 miglia6 x 22.460.02[31.450.00][35.459.01][01.106.00][01.139.04][30.230.01][22.408.06][34.171.40][21.462.30]-NONO[30.654.00]
159.50 € 155.20€
PZ
Aggiungi
al carrello
3 miglia4 x 22.460.02[31.450.00][35.459.01][01.106.00][01.139.25]NO[22.408.06][34.171.40][21.462.30]-NONO[30.654.00]
204.50 € 197.70€
PZ
Aggiungi
al carrello
3 miglia6 x 22.460.02[31.450.00][35.459.01][01.106.00][01.139.04]NO[22.408.06][34.171.40][21.462.30]-NONO[30.654.00]
174.50 € 168.50€
PZ
Aggiungi
al carrello
6 miglia4 x 22.460.02[31.450.00][35.459.01][01.106.00][01.139.25]NO[22.408.06][34.171.40][21.462.30][30.583.00] [30.584.00]NONO[30.654.00]
214.50 € 210.60€
PZ
Aggiungi
al carrello
6 miglia6 x 22.460.02[31.450.00][35.459.01][01.106.00][01.139.04]NO[22.408.06][34.171.40][21.462.30][30.583.00] [30.584.00]NONO[30.654.00]
264.50 € 258.20€
PZ
Aggiungi
al carrello
12 miglia4 x 22.461.02[31.450.00][35.459.02][01.106.00][01.139.04]NO[22.408.06][34.171.40][21.462.30][30.583.00] [30.584.00][22.409.23][30.654.00]

Prezzi validi solo per acquisti online

Kit navigazione MARSUPIO aggiornato al DM n°133 del 21/09/2024

Kit di navigazione entro le 3 miglia / 12 miglia da 4 o da 6 persone completo di borsa che può servire da morbido cuscino.

2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF
2026pg512
2026pg512
Scarica PDF

Aderisci alla Newsletter

Iscriviti alla nostra newsletter per essere sempre informato sulle ultime novità.

Ordini veloci

Il 90% degli ordini viene spedito in 24H. Vedi subito disponibilità e tempistiche

Professionisti del settore

Lavoriamo e diamo assistenza nautica dal 1982. Troverete personale esperto e gentile nell'assistervi

Pagamenti sicuri

Scegli tra Paypal, Carta di Credito, Postepay e Bonifico Bancario

Imballaggi riciclati

Utilizziamo solamente imballaggi provenienti da materiale riciclato all'interno del nostro stesso negozio

(default) 15 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '2d4f1311476c9ebd1d5417f9ba1eba82' 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` = '100996' ORDER BY `Category`.`name_it` 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` = '100997' ORDER BY `Category`.`name_it` 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_it` 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` = '24005' ORDER BY `Category`.`name_it` 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` = '100999' ORDER BY `Category`.`name_it` 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` = 14659 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` = (14659)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` = 14659 AND `ProductsSeries`.`product_id` = `Product`.`id`) 13131
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` = '23431' 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` = '02002' 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` = 1465910101
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 ('22.409.33', '22.409.35', '22.409.37', '22.411.32', '22.411.34', '22.412.32', '22.412.34', '22.412.40', '22.412.41', '22.412.43')20200
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 ('22.409.33', '22.409.35', '22.409.37', '22.411.32', '22.411.34', '22.412.32', '22.412.34', '22.412.40', '22.412.41', '22.412.43') AND `ProductsSeries`.`series_id` = `Serie`.`id`) 10100
15SELECT `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` != 14659 AND `Serie`.`category_id` = '23431' ORDER BY rand() ASC LIMIT 1010101