Suportul telefonic este 10-18.
Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.
SELECTCOUNT(1) AS total FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters 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_description` AS pd ON (pd.product_id = p.product_id) WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%protectie%' AND pd.tag LIKE '%si%' AND pd.tag LIKE '%degetare%' AND pd.tag LIKE '%wolf%')) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity 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_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id) WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%protectie%' AND pd.tag LIKE '%si%' AND pd.tag LIKE '%degetare%' AND pd.tag LIKE '%wolf%')) AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASCLIMIT 0, 20
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max 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_description` AS pd ON (pd.product_id = p.product_id) WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%protectie%' AND pd.tag LIKE '%si%' AND pd.tag LIKE '%degetare%' AND pd.tag LIKE '%wolf%')) AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
SELECTCOUNT(1) AS val, filter_group, filter_id 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_description` AS pd ON (pd.product_id = p.product_id) WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%protectie%' AND pd.tag LIKE '%si%' AND pd.tag LIKE '%degetare%' AND pd.tag LIKE '%wolf%')) AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1