Table 'enita_db.SC_products_opt_val_variants' doesn't exist
SELECT
(
SELECT COUNT(`SC_products_opt_val_variants`.`variantID`)
FROM `SC_products_opt_val_variants`
WHERE `SC_products_opt_val_variants`.`optionID` = `SC_product_options`.`optionID`
) as `count_variants`,
`SC_product_options`.*,
IF(LENGTH(SC_product_options.name_ua), SC_product_options.name_ua, SC_product_options.name_ru) AS _name_sort,IF(LENGTH(SC_product_options.description_title_ua), SC_product_options.description_title_ua, SC_product_options.description_title_ru) AS _description_title_sort,IF(LENGTH(SC_product_options.description_text_ua), SC_product_options.description_text_ua, SC_product_options.description_text_ru) AS _description_text_sort,IF(LENGTH(SC_product_options.slider_prefix_ua), SC_product_options.slider_prefix_ua, SC_product_options.slider_prefix_ru) AS _slider_prefix_sort
FROM `SC_product_options`
ORDER BY `SC_product_options`.`sort_order`, _name_sort