products
LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id
products
LEFT JOIN ?:product_features_values as var_val_18 ON var_val_18.product_id = products.product_id AND var_val_18.lang_code = 'ro' AND var_val_18.feature_id = 18 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id
filters
LEFT JOIN ?:products as products ON products.product_id = ?:product_prices.product_id LEFT JOIN ?:product_prices as prices_2 ON ?:product_prices.product_id = prices_2.product_id AND ?:product_prices.price > prices_2.price AND prices_2.lower_limit = 1 AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id LEFT JOIN ?:currencies as currencies ON currencies.currency_code = csc_product_currency_items.currency OR (currencies.is_primary = 'Y' AND (csc_product_currency_items.currency='D' OR csc_product_currency_items.currency IS NULL)) LEFT JOIN ?:ult_product_prices AS shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1
