Notice: Undefined offset: 1 in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 238Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) GROUP BY p.product_id HAVING c >= '1'' at line 9
Error No: 1064
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, IF( COUNT(DISTINCT filter_group) = 2, 1, 0 ) AS match_filters, COUNT(DISTINCT filter_group) AS c, SUM( DISTINCT CASE filter_group WHEN 'a287' THEN 1 WHEN '/' THEN 2 END ) AS match_filters_mask, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()) AND pd2.customer_group_id = '1') LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id FROM `oc_bf_tax_rate` WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '175' AND zone_id IN ('0', '2688')) OR (based = 'shipping' AND country_id = '175' AND zone_id IN ('0', '2688'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id) WHERE p2s.store_id = '0' AND p2c.category_id = '261' AND f.out_of_stock = 0 AND ((f.filter_group = "a287" AND filter_id IN (11538,1689)) OR (f.filter_group = "/" AND filter_id IN ())) GROUP BY p.product_id HAVING c >= '1' in /home/ffbro/public_html/claumarpescar.ro/system/library/db/mysqli.php on line 41Notice: Error: Table 'ffbro_claumarpescar.oc_bf_tmp_product' doesn't exist
Error No: 1146
SELECT COUNT(*) AS total FROM ( SELECT p.* FROM `oc_bf_tmp_product` AS p WHERE match_filters = 1) AS t in /home/ffbro/public_html/claumarpescar.ro/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/ffbro/public_html/claumarpescar.ro/vqmod/vqcache/vq2-system_modification_catalog_model_catalog_product.php on line 625Notice: Undefined offset: 1 in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 238Notice: Error: Table 'ffbro_claumarpescar.oc_bf_tmp_product' doesn't exist
Error No: 1146
SELECT p.*, pp.sort_order FROM `oc_bf_tmp_product` AS p INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id) WHERE match_filters = 1 AND pd.language_id = '2' ORDER BY pp.sort_order ASC, pd.name ASC LIMIT 0, 26 in /home/ffbro/public_html/claumarpescar.ro/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/ffbro/public_html/claumarpescar.ro/vqmod/vqcache/vq2-system_modification_catalog_model_catalog_product.php on line 93Warning: Invalid argument supplied for foreach() in /home/ffbro/public_html/claumarpescar.ro/vqmod/vqcache/vq2-system_modification_catalog_model_catalog_product.php on line 93Notice: Undefined offset: 1 in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 238Notice: Undefined offset: 1 in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 238Notice: Error: Table 'ffbro_claumarpescar.oc_bf_tmp_product' doesn't exist
Error No: 1146
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max FROM `oc_bf_tmp_product` AS p WHERE match_filters = 1 in /home/ffbro/public_html/claumarpescar.ro/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 884Notice: Trying to get property of non-object in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 886Notice: Error: Table 'ffbro_claumarpescar.oc_bf_tmp_product' doesn't exist
Error No: 1146
SELECT COUNT(*) AS val, filter_group, filter_id FROM `oc_bf_tmp_product` AS p INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) WHERE match_filters = 1 AND f.language_id = '2' AND f.filter_group NOT IN ('a287','/') AND f.out_of_stock = 0 GROUP BY filter_group, filter_id in /home/ffbro/public_html/claumarpescar.ro/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 807Notice: Error: Table 'ffbro_claumarpescar.oc_bf_tmp_product' doesn't exist
Error No: 1146
SELECT COUNT(*) AS val, filter_group, filter_id FROM `oc_bf_tmp_product` AS tp INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id) WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.out_of_stock = 0 AND ((tp.match_filters_mask = 2 AND f.filter_group = 'a287') OR (tp.match_filters_mask = 1 AND f.filter_group = '/')) GROUP BY filter_group, filter_id in /home/ffbro/public_html/claumarpescar.ro/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 841Warning: array_merge(): Argument #1 is not an array in /home/ffbro/public_html/claumarpescar.ro/catalog/model/module/brainyfilter.php on line 844 Vergi (Undite)
Cea mai variata gama de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 100 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

Suport 24/7

In sezon suportul telefonic este 24/7. Orice intrebare ai avea stim ca nu poate astepta. Apeleaza serviciul Suport 24/7! Un consultant asteapta sa iti preia apelul 24 de ore din 24, in fiecare zi a saptamanii.

Vezi mai multe detalii

Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Vergi (Undite)