ERROR DATABASE CONNECT: SELECT COUNT(*) as `rows`, ((ec_products. + (ec_products. * (ec_products.tax / 100))) - (ec_products. + (ec_products. * (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 LEFT JOIN ec_products_clients_discounts ON ec_products_clients_discounts.cd_ec_product_client_discount IN ( SELECT cd_ec_product_client_discount FROM ec_products_clients_discounts_profile WHERE cd_profile = '' AND cd_account = '' ) AND ec_products_clients_discounts.cd_ec_product_client_discount IN ( SELECT cd_ec_product_client_discount FROM ec_products_clients_discounts_product WHERE cd_ec_product = ec_products.cd_ec_product AND cd_account = '' ) AND ec_products_clients_discounts.active = '1' AND ( ec_products_clients_discounts.discount_date_start = '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_end = '0000-00-00 00:00:00' OR ec_products_clients_discounts.discount_date_start != '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_end != '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_start <= '2025-05-01 05:00:25' AND ec_products_clients_discounts.discount_date_end >= '2025-05-01 05:00:25' OR ec_products_clients_discounts.discount_date_start != '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_end = '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_start <= '2025-05-01 05:00:25' OR ec_products_clients_discounts.discount_date_start = '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_end != '0000-00-00 00:00:00' AND ec_products_clients_discounts.discount_date_end >= '2025-05-01 05:00:25' ) WHERE ec_products.cd_account = '' AND ec_products.active = '1' AND ec_products.webstore = '1' AND ec_products.cd_ec_product NOT IN (0) 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 = '' AND cd_ec_category NOT IN (0)) 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 = '' AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0))))) AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND (ec_products.designation LIKE '%%' OR ec_products.description LIKE '%%' OR ec_products.description2 LIKE '%%' OR ec_products.description3 LIKE '%%' OR ec_products.description4 LIKE '%%' OR ec_products.description5 LIKE '%%' OR ec_products.reference LIKE '%%' OR ec_products.tags 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' AND cd_ec_category NOT IN (0)) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) 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' AND cd_ec_category NOT IN (0))) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0))) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0))) 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 cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0)) AND active = '1' AND webstore = '1' AND cd_ec_category NOT IN (0))) ) AND cd_ec_category NOT IN (SELECT cd_ec_category FROM ec_categories WHERE adult_content = '1' AND cd_account = '') 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 = '')) ORDER BY ec_products.designation ASC