SELECT ((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, ec_products.is_attribute_product, ec_products.flash_sale, ec_products.delivery_time_message, ec_products.discount_date_start, ec_products.discount_date_end, ec_products.cd_unit_of_measure, ec_products.price, ec_products.discount_type, ec_products.discount, ec_products.tax, ec_products.is_attribute_configurable, ec_products.stock, ec_products.cd_ec_product, ec_products.cd_ec_brand, ec_products.cd_ec_supplier, ec_products.cd_ec_category, ec_products.friendly_url, ec_products.allow_order, ec_products.novelty, ec_products.campaign, ec_products.picture_file1, ec_products.picture_file2, ec_products.designation, ec_products.designation, ec_products.reference, ec_products.description , ec_products.notes FROM ec_products LEFT JOIN ec_brands ON ec_products.cd_ec_brand = ec_brands.cd_ec_brand
WHERE ec_products.cd_account = '101717'
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 = '101717') 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 = '101717' 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.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 designation LIKE '%%') OR 1 = 1 AND (ec_products.designation LIKE '%%' OR ec_products.cd_ec_brand > 0 AND ec_products.cd_ec_brand IN (SELECT cd_ec_brand FROM ec_brands WHERE designation LIKE '%%') OR ec_products.cd_ec_category IN (SELECT cd_ec_category FROM ec_categories WHERE designation LIKE '%%' OR cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE designation LIKE '%%' OR cd_ec_category_parent IN (SELECT cd_ec_category FROM ec_categories WHERE 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 = '101717')
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 = '101717'))
ORDER BY ec_products.price ASC
LIMIT 0,48
|
Profissionais