|
ERROR DATABASE CONNECT: SELECT COUNT(*) as rows, ((ec_products.price + (ec_products.price * (ec_products.tax / 100))) - (ec_products.price + (ec_products.price * (ec_products.tax / 100)))* (ec_products.discount / 100)) as pvp FROM ec_products LEFT JOIN ec_brands ON ec_products.cd_ec_brand = ec_brands.cd_ec_brand WHERE ec_products.cd_account = '106153' 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 (ec_products.cd_ec_category > 0 AND ec_products.cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE webstore = '1' AND active = '1' AND cd_account = '106153') 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_ec_category_parent = '0' AND cd_account = '106153' AND active = '1' AND webstore = '1')))) AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND (1 = 1 OR 1 = 1 OR 1 = 1 OR 1 = 1 OR 1 = 1 OR 1 = 1 AND ec_products.[field_designation] LIKE '%%' OR 1 = 1 AND ec_products.reference LIKE '%%' OR 1 = 1 AND ec_products.tags LIKE '%%' OR 1 = 1 AND ec_products.cd_ec_brand > 0 AND ec_products.cd_ec_brand IN (SELECT cd_ec_brand FROM ec_brands WHERE [field_designation] LIKE '%%') OR 1 = 1 AND (ec_products.[field_designation] LIKE '%%' OR ec_products.cd_ec_brand > 0 AND ec_products.cd_ec_brand IN (SELECT cd_ec_brand FROM ec_brands WHERE [field_designation] LIKE '%%') OR ec_products.cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE [field_designation] LIKE '%%' OR cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE [field_designation] LIKE '%%' OR cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE [field_designation] LIKE '%%')))) ) 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 cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') OR cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') OR cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') OR cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') OR cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND 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_ec_category_parent = '0' AND 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_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND 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_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND 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_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE cd_ec_category_parent = '0' AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') AND active = '1' AND webstore = '1') 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 = '106153') 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 = '106153')) ORDER BY ec_products.[field_designation] ASC |
