Collante per tessuti in neoprene e PVC ADECO per DIY

Fornitore: Adeco
Collanti speciali bicomponente per gommoni in neoprene e in PVC.
I più utilizzati sul mercato da tutte le fabbriche di gommoni.

A partire da:

5.23 €
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 Per gommoni inConfezione daAttivatore daDescrizioneVendibile a
6.91€
PZ
Aggiungi
al carrello
Neoprene65 ml-TubettoDIY
5.23€
PZ
Aggiungi
al carrello
Neoprene30 ml-TubettoDIY
38.90 € 36.90€
PZ
Aggiungi
al carrello
Neoprene850 g50 mlLatta + attivatoreDIY
72.90 € 70.30€
PZ
Aggiungi
al carrello
Neoprene2 kg160 gLatta + attivatoreDIY
95.90 € 92.80€
PZ
Aggiungi
al carrello
Neoprene2 kg160 gLatta + attivatoreProfessionisti
209.50 € 199.60€
PZ
Aggiungi
al carrello
Neoprene4,2 kg750 gLatta + attivatoreProfessionisti
29.90 € 28.70€
PZ
Aggiungi
al carrello
Neoprene500 g30 mlLatta + attivatoreDIY
17.45 € 16.60€
PZ
Aggiungi
al carrello
Neoprene125 ml10 mlLatta + attivatoreDIY
19.95 € 19.20€
PZ
Aggiungi
al carrello
PVC125 ml10 mlLatta + attivatoreDIY
41.90 € 39.80€
PZ
Aggiungi
al carrello
PVC850 g50 mlLatta + attivatoreDIY
79.90 € 77.10€
PZ
Aggiungi
al carrello
PVC2 kg160 gLatta + attivatoreDIY
31.90 € 30.40€
PZ
Aggiungi
al carrello
PVC500 g30 mlLatta + attivatoreDIY

Prezzi validi solo per acquisti online

Collante per tessuti in neoprene e PVC ADECO per DIY

Collanti speciali bicomponente per gommoni in neoprene e in PVC.
I più utilizzati sul mercato da tutte le fabbriche di gommoni.

2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
Scarica PDF
2026pg1171
2026pg1171
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 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '14e4d03a3a061657d9f7b6bcb983333e' 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` = 15864 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` = (15864)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` = 15864 AND `ProductsSeries`.`product_id` = `Product`.`id`) 19191
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` = '15863' 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` = '66' 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` = 1586417171
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 ('66.236.00', '66.236.01', '66.240.01', '66.240.02', '66.240.03', '66.240.04', '66.240.10', '66.240.11', '66.240.21', '66.240.22', '66.240.23', '66.240.24', '66.240.25', '66.240.51', '66.240.52', '66.240.53', '66.240.60')17170
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 ('66.236.00', '66.236.01', '66.240.01', '66.240.02', '66.240.03', '66.240.04', '66.240.10', '66.240.11', '66.240.21', '66.240.22', '66.240.23', '66.240.24', '66.240.25', '66.240.51', '66.240.52', '66.240.53', '66.240.60') AND `ProductsSeries`.`series_id` = `Serie`.`id`) 17171
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` != 15864 AND `Serie`.`category_id` = '15863' ORDER BY rand() ASC LIMIT 1010101