| ERROR DATABASE CONNECT: SELECT COUNT(*) as rows FROM ec_products WHERE ec_products.cd_account = '107936' AND ec_products.active = '1' AND ec_products.webstore = '1' AND ec_products.is_attribute_product = '0' AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND (1 = 1 AND REPLACE(REPLACE(ec_products.[field_designation],'-',''),' ','') LIKE '%aquecimento%' OR 1 = 1 AND REPLACE(REPLACE(ec_products.reference,'-',''),' ','') LIKE '%aquecimento%' OR 1 = 1 AND REPLACE(REPLACE(ec_products.tags,'-',''),' ','') LIKE '%aquecimento%' OR 1 = 1 AND ec_products.cd_ec_brand > 0 AND cd_ec_brand IN (SELECT cd_ec_brand FROM ec_brands WHERE REPLACE(REPLACE([field_designation],'-',''),' ','') LIKE '%aquecimento%') OR 1 = 1 AND (REPLACE(REPLACE(ec_products.[field_designation],'-',''),' ','') LIKE '%aquecimento%' OR ec_products.cd_ec_brand > 0 AND ec_products.cd_ec_brand IN (SELECT cd_ec_brand FROM ec_brands WHERE REPLACE(REPLACE([field_designation],'-',''),' ','') LIKE '%aquecimento%')) ) AND ( cd_ec_category = 0 AND cd_ec_product NOT IN (SELECT cd_ec_product FROM ec_product_category_aux) OR cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE active = '1' AND webstore = '1') OR cd_ec_product IN (SELECT cd_ec_product FROM ec_product_category_aux WHERE cd_ec_category IN ((SELECT cd_ec_category FROM ec_categories WHERE cd_account = '107936' AND active = '1' AND webstore = '1'))) ) AND cd_ec_category NOT IN (SELECT cd_ec_category FROM ec_categories WHERE adult_content = '1' AND cd_account = '107936') AND cd_ec_product NOT IN (SELECT cd_ec_product FROM ec_product_category_aux WHERE cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE adult_content = '1' AND cd_account = '107936')) ORDER BY ec_products.[field_designation] ASC |
