SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'

SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority

SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position

SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'storage' 

SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 291 ORDER BY cscart_settings_objects.position

SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'cdn' 

SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 294 ORDER BY cscart_settings_objects.position

SELECT company_id, storefront FROM cscart_companies WHERE storefront RLIKE '^(www[0-9]*.)?fish.ee'

SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1

SELECT company_id, storefront FROM cscart_companies WHERE FIND_IN_SET('US', countries_list) LIMIT 1

SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')

SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')

SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'

SELECT company_id FROM cscart_companies

SELECT type FROM cscart_seo_names WHERE name = 'midii-ee'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)

SELECT * FROM cscart_seo_names WHERE name = 'midii-ee'  AND cscart_seo_names.company_id IN (0, 1) AND lang_code = 'ee'

SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 

SELECT object_id, name FROM cscart_seo_names WHERE name IN ('shop', 'gourmet', 'seafood-ee') AND type = 'c' AND lang_code = 'ee'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)

SELECT * FROM cscart_settings_sections WHERE name = 'seo' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))

SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '47' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 7 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 4 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 3 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)

SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 

SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'ee' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position

SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 

SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 

SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position

SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'

SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 

SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position

SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'

SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 1, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'RusCaviar', 1, 0))  AND company_id = 1

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (7, 8, 9, 10) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'

SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 1

SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ee' WHERE l.layout_id = 1  AND l.dispatch = 'products.view'  ORDER BY l.object_ids desc  LIMIT 1

SElECT usergroup_ids FROM cscart_products WHERE product_id = 7

SELECT cscart_products.*, cscart_product_descriptions.*, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT(IF(cscart_products_categories.link_type = 'M', CONCAT(cscart_products_categories.category_id, 'M'), cscart_products_categories.category_id)) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) as price, companies.company as company_name, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'ee'  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 1 AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id  AND cscart_categories.company_id = 1 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_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 7 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' AND cscart_seo_names.company_id = 1 WHERE cscart_products.product_id = 7  AND (companies.status = 'A' OR cscart_products.company_id = 0)  GROUP BY cscart_products.product_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 7 ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 7 ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 7 ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 7 ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_product_prices prices WHERE prices.product_id = 7  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit

SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 7  GROUP BY c.company_id LIMIT 2

SELECT company_id FROM cscart_products WHERE product_id = 7

SELECT id_path FROM cscart_categories WHERE category_id = 9

SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'ee' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 7 AND cscart_product_features_values.lang_code = 'ee' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(4, pf.categories_path) OR FIND_IN_SET(3, pf.categories_path) OR FIND_IN_SET(9, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description 

SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'ee' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(4, pf.categories_path) OR FIND_IN_SET(3, pf.categories_path) OR FIND_IN_SET(9, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description

SELECT id_path FROM cscart_categories WHERE category_id = 9

SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 7  GROUP BY c.company_id LIMIT 2

SELECT company_id FROM cscart_products WHERE product_id = 7

SELECT v.feature_id, v.value, v.value_int, v.variant_id, f.feature_type, fd.description, fd.prefix, fd.suffix, vd.variant, f.parent_id, f.position, gf.position as gposition FROM cscart_product_features as f LEFT JOIN cscart_product_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'ee' LEFT JOIN cscart_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'ee' LEFT JOIN cscart_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = f.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 7  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(4, f.categories_path) OR FIND_IN_SET(3, f.categories_path) OR FIND_IN_SET(9, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'ee' ORDER BY fd.description, fv.position

SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 7  GROUP BY c.company_id LIMIT 2

SELECT company_id FROM cscart_products WHERE product_id = 7

SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 7 GROUP BY c.company_id

SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ee'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_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')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ee' LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id WHERE 1  AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND cscart_product_required_products.product_id = 7 GROUP BY products.product_id   ORDER BY NULL asc 

SELECT id_path FROM cscart_categories WHERE category_id = 9

SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (4, 3, 9) AND lang_code = 'ee'

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (7) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (7) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'ee'  WHERE a.product_id IN (7) AND status = 'A' ORDER BY a.position

SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'ee' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (7) AND a.product_id = 0 AND status = 'A' ORDER BY a.position

SELECT a.variant_id, a.option_id, a.position, a.modifier, a.modifier_type, a.weight_modifier, a.weight_modifier_type,  b.variant_name, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type FROM cscart_product_option_variants as a LEFT JOIN cscart_product_option_variants_descriptions as b ON a.variant_id = b.variant_id AND b.lang_code = 'ee' LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 1 WHERE a.option_id IN (12)  AND a.status='A' ORDER BY a.position, a.variant_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (35) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (35) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT * FROM cscart_product_options_exceptions WHERE product_id = 7 ORDER BY exception_id

SELECT inventory FROM cscart_product_options WHERE option_id = 12

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1790921346 ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ee' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1790921346 ORDER BY cscart_images_links.position, cscart_images_links.pair_id

SELECT * FROM cscart_product_options_exceptions WHERE product_id = 7 ORDER BY exception_id

SELECT option_type as type, option_id FROM cscart_product_options INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_options') WHERE option_id IN (12) 

SELECT a.modifier, a.modifier_type, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type FROM cscart_product_option_variants a  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 1 WHERE 1 AND a.variant_id = 35

SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'ee' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_promotions.promotion_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1675182802, 1) AND IF(to_date, to_date >= 1675182802, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc 

SELECT cscart_product_files.*, cscart_product_file_descriptions.file_name, cscart_product_file_descriptions.license, cscart_product_file_descriptions.readme FROM cscart_product_files  LEFT JOIN cscart_product_file_descriptions ON cscart_product_file_descriptions.file_id = cscart_product_files.file_id AND cscart_product_file_descriptions.lang_code = 'ee' WHERE cscart_product_files.product_id = 7 AND preview_path != '' AND cscart_product_files.status = 'A' ORDER BY position, file_name

SELECT *,cscart_product_tabs.status as status,cscart_product_tabs.block_id as block_id,cscart_product_tabs.company_id as company_id,cscart_product_tabs_descriptions.name as name  FROM cscart_product_tabs LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id  WHERE cscart_product_tabs_descriptions.lang_code = 'ee'  AND cscart_product_tabs.company_id = 1  ORDER BY position

SHOW COLUMNS FROM cscart_product_popularity

INSERT INTO cscart_product_popularity (`product_id`, `viewed`, `total`) VALUES (7, 1, 3) ON DUPLICATE KEY UPDATE viewed = viewed + 1, total = total + 3

SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 7 AND user_id = 0

SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tags.tag, cscart_tags.status, COUNT(cscart_tag_links.tag_id) as popularity FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1  AND cscart_tags.company_id = 1 AND cscart_tag_links.object_type = 'P' AND cscart_tags.status IN ('A') AND cscart_tag_links.object_id = 7 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 

SELECT c.category_id, IF(pc.link_type = 'M', 1, 0) as is_main FROM cscart_categories AS c LEFT JOIN cscart_products_categories AS pc ON c.category_id = pc.category_id WHERE pc.product_id = 7  AND c.company_id = 1 ORDER BY is_main DESC

SET @r = 0;

SELECT b.row FROM (SELECT product_id, @r := @r + 1 as row FROM(SELECT products.product_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ee'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_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')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ee' WHERE 1  AND cscart_categories.category_id IN (9) AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc) AS a) AS b WHERE b.product_id = 7

SELECT SQL_CALC_FOUND_ROWS products.product_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ee'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_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')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ee' WHERE 1  AND cscart_categories.category_id IN (9) AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc  LIMIT 0, 30

SELECT FOUND_ROWS()

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 13 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 18 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)

SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)

SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'

SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 1

SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ee' WHERE l.layout_id = 1  AND l.dispatch = 'products.view' AND (FIND_IN_SET(7, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 3

SELECT layout_id FROM cscart_bm_locations WHERE location_id = 3

SELECT c.*, IF (c.location_id != 3, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')

SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 11, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC

SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'products' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 7 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 7, 10, 14, 15, 16, 17, 19, 20, 13, 18, 29, 30, 125)  AND cscart_bm_blocks_descriptions.lang_code='ee'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 

SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 

SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;

SELECT status FROM cscart_menus WHERE menu_id = 3

SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'ee' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position

SELECT id_path FROM cscart_categories WHERE category_id = 4

SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'ee'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1  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') AND cscart_categories.id_path LIKE '4/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(9, 1, 10, 2, 3, 11, 18, 21, 26, 6, 30, 27, 28, 31, 32, 29) 

SELECT id_path FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 12 

SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'ee' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.id_path LIKE '12/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1675182802 AND avail_till_timestamp >= 1675182802)) ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 12 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'ee' 

SELECT id_path FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 15 

SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'ee' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.id_path LIKE '15/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1675182802 AND avail_till_timestamp >= 1675182802)) ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 

SELECT details_layout FROM cscart_products WHERE product_id = 7

SELECT c.product_details_view FROM cscart_products_categories as pc LEFT JOIN cscart_categories as c ON pc.category_id = c.category_id WHERE pc.product_id = 7 AND pc.link_type = 'M'