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

  1. SELECT type FROM cscart_seo_names WHERE name = 'fruit-arrangement-with-cheese-and-crackers-bogota-colombia-delivery'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)

  1. SELECT * FROM cscart_seo_names WHERE name = 'fruit-arrangement-with-cheese-and-crackers-bogota-colombia-delivery'  AND cscart_seo_names.company_id IN (0, 1) AND lang_code = 'es'

  1. SELECT * FROM cscart_seo_names WHERE name = 'fruit-arrangement-with-cheese-and-crackers-bogota-colombia-delivery'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)

  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

  1. SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

  1. SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  LEFT JOIN cscart_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = cscart_languages.lang_id WHERE 1 AND cscart_languages.status = 'A' AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)   

  1. SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (29847)

  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

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

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

  1. SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1

  1. SELECT links.link_id FROM cscart_usergroup_links as links LEFT JOIN cscart_usergroup_privileges as privileges ON privileges.usergroup_id = links.usergroup_id WHERE links.user_id = 0 AND links.status = 'A' AND privileges.privilege = 'delivery_report'

  1. SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

  1. SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

  1. SELECT data FROM cscart_storage_data WHERE data_key = 'debugger_active'

  1. SELECT b.crawler FROM cscart_cp_bd_bots as b              LEFT JOIN cscart_cp_bd_groups as bg ON bg.group_id = b.group_id              WHERE b.type = 'G' AND b.status = 'A' AND bg.status = 'A' AND b.company_id = 1

  1. SELECT b.crawler FROM cscart_cp_bd_bots as b              LEFT JOIN cscart_cp_bd_groups as bg ON bg.group_id = b.group_id              WHERE b.type = 'B' AND b.status = 'A' AND bg.status = 'A' AND b.company_id = 1

  1. SELECT * from cscart_cp_bd_bot_ips WHERE status='A' AND company_id=1

  1. SELECT cscart_cp_speed_optimization_links.* FROM cscart_cp_speed_optimization_links         LEFT JOIN cscart_cp_speed_optimization_locations ON cscart_cp_speed_optimization_locations.link_id = cscart_cp_speed_optimization_links.link_id         WHERE cscart_cp_speed_optimization_links.status = 'A' AND cscart_cp_speed_optimization_locations.loc_hash IN (3059264763, 991457757) ORDER BY cscart_cp_speed_optimization_links.position asc

  1. SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 8

  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 = 'en' WHERE l.layout_id = 8  AND l.dispatch IN ('products.view') AND (FIND_IN_SET(29847, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

  1. SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

  1. SELECT image_path FROM cscart_cp_web_ignore_list

  1. SELECT usergroup_ids FROM cscart_products WHERE product_id = 29847

  1. SELECT category_id FROM cscart_products_categories WHERE product_id = 29847 AND link_type = 'M'

  1. 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( CASE   WHEN (cscart_products_categories.link_type = 'M') THEN CONCAT(cscart_products_categories.category_id, 'M')   ELSE cscart_products_categories.category_id END ORDER BY cscart_categories.storefront_id IN (0, 1) DESC, (cscart_products_categories.link_type = 'M') DESC, cscart_products_categories.category_position ASC, cscart_products_categories.category_id ASC) 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_products.is_returnable, cscart_products.return_period, cscart_product_sales.amount as sales_amount, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, cscart_discussion.type as discussion_type, cscart_product_review_prepared_data.average_rating average_rating, cscart_product_review_prepared_data.reviews_count product_reviews_count 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 = 'en' 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.storefront_id IN (0, 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_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND cscart_product_sales.category_id = 173 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 29847 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = 1 LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND cscart_discussion.object_type = 'P' LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id AND cscart_product_review_prepared_data.storefront_id = 0 WHERE cscart_products.product_id = 29847  AND (companies.status IN ('A') OR cscart_products.company_id = 0) GROUP BY cscart_products.product_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = '29847' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = '29847' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '29847' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '29847' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. 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 = 29847  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit

  1. 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 = 29847  GROUP BY c.company_id LIMIT 2

  1. SELECT id_path FROM cscart_categories WHERE category_id IN (173, 177, 179, 199, 214, 217, 218, 219, 221, 222, 223, 230, 231, 233, 234, 235, 238, 239, 242, 246, 250, 251, 254, 257, 258, 259, 260, 261, 262, 265)

  1. 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.internal_name, 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, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_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 pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN cscart_product_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 29847 AND cscart_product_features_values.lang_code = 'en' WHERE 1=1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(173, pf.categories_path) OR FIND_IN_SET(177, pf.categories_path) OR FIND_IN_SET(230, pf.categories_path) OR FIND_IN_SET(179, pf.categories_path) OR FIND_IN_SET(195, pf.categories_path) OR FIND_IN_SET(199, pf.categories_path) OR FIND_IN_SET(212, pf.categories_path) OR FIND_IN_SET(214, pf.categories_path) OR FIND_IN_SET(217, pf.categories_path) OR FIND_IN_SET(218, pf.categories_path) OR FIND_IN_SET(202, pf.categories_path) OR FIND_IN_SET(219, pf.categories_path) OR FIND_IN_SET(222, pf.categories_path) OR FIND_IN_SET(221, pf.categories_path) OR FIND_IN_SET(223, pf.categories_path) OR FIND_IN_SET(231, pf.categories_path) OR FIND_IN_SET(265, pf.categories_path) OR FIND_IN_SET(233, pf.categories_path) OR FIND_IN_SET(234, pf.categories_path) OR FIND_IN_SET(235, pf.categories_path) OR FIND_IN_SET(238, pf.categories_path) OR FIND_IN_SET(239, pf.categories_path) OR FIND_IN_SET(205, pf.categories_path) OR FIND_IN_SET(242, pf.categories_path) OR FIND_IN_SET(246, pf.categories_path) OR FIND_IN_SET(250, pf.categories_path) OR FIND_IN_SET(251, pf.categories_path) OR FIND_IN_SET(254, pf.categories_path) OR FIND_IN_SET(257, pf.categories_path) OR FIND_IN_SET(258, pf.categories_path) OR FIND_IN_SET(259, pf.categories_path) OR FIND_IN_SET(260, pf.categories_path) OR FIND_IN_SET(261, pf.categories_path) OR FIND_IN_SET(262, pf.categories_path) )  GROUP BY pf.feature_id  ORDER BY group_position asc, pf_groups_description.description asc, pf_groups.feature_id asc, pf.position asc, cscart_product_features_descriptions.description asc, pf.feature_id asc 

  1. SELECT cscart_product_feature_variant_descriptions.variant, cscart_product_feature_variants.variant_id, cscart_product_feature_variants.feature_id, cscart_product_features_values.variant_id as selected, cscart_product_features.feature_type, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_product_feature_variants  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_feature_variant_descriptions.lang_code = 'en' INNER JOIN cscart_product_features_values ON cscart_product_features_values.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_features_values.lang_code = 'en' AND cscart_product_features_values.product_id = 29847 LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_feature_variants.feature_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_product_feature_variants.variant_id AND cscart_seo_names.type = 'e' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0) WHERE 1  AND cscart_product_feature_variants.feature_id IN (21, 25, 29)  GROUP BY cscart_product_feature_variants.variant_id ORDER BY cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant 

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (60, 68, 50) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (60, 68, 50) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT feature_id FROM cscart_product_features WHERE feature_id IN (21, 25, 29) AND feature_type = 'E'

  1. 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.internal_name, 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, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp 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 = 'en' WHERE pf.feature_type = 'G' AND (pf.feature_id IN (23) 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(173, pf.categories_path) OR FIND_IN_SET(177, pf.categories_path) OR FIND_IN_SET(230, pf.categories_path) OR FIND_IN_SET(179, pf.categories_path) OR FIND_IN_SET(195, pf.categories_path) OR FIND_IN_SET(199, pf.categories_path) OR FIND_IN_SET(212, pf.categories_path) OR FIND_IN_SET(214, pf.categories_path) OR FIND_IN_SET(217, pf.categories_path) OR FIND_IN_SET(218, pf.categories_path) OR FIND_IN_SET(202, pf.categories_path) OR FIND_IN_SET(219, pf.categories_path) OR FIND_IN_SET(222, pf.categories_path) OR FIND_IN_SET(221, pf.categories_path) OR FIND_IN_SET(223, pf.categories_path) OR FIND_IN_SET(231, pf.categories_path) OR FIND_IN_SET(265, pf.categories_path) OR FIND_IN_SET(233, pf.categories_path) OR FIND_IN_SET(234, pf.categories_path) OR FIND_IN_SET(235, pf.categories_path) OR FIND_IN_SET(238, pf.categories_path) OR FIND_IN_SET(239, pf.categories_path) OR FIND_IN_SET(205, pf.categories_path) OR FIND_IN_SET(242, pf.categories_path) OR FIND_IN_SET(246, pf.categories_path) OR FIND_IN_SET(250, pf.categories_path) OR FIND_IN_SET(251, pf.categories_path) OR FIND_IN_SET(254, pf.categories_path) OR FIND_IN_SET(257, pf.categories_path) OR FIND_IN_SET(258, pf.categories_path) OR FIND_IN_SET(259, pf.categories_path) OR FIND_IN_SET(260, pf.categories_path) OR FIND_IN_SET(261, pf.categories_path) OR FIND_IN_SET(262, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description

  1. SELECT v.feature_id,         v.value,         v.value_int,         v.variant_id,         f.feature_type,         fd.internal_name,         fd.description,         fd.prefix,         fd.suffix,         vd.variant,         f.parent_id,         f.position,         gf.position as gposition,         f.display_on_header,         f.display_on_catalog,         f.display_on_product,         f.feature_code,         f.purpose 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 = 'en' 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 = 'en' LEFT JOIN cscart_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G'  WHERE f.status IN ('A') AND v.product_id = 29847  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(173, f.categories_path) OR FIND_IN_SET(177, f.categories_path) OR FIND_IN_SET(230, f.categories_path) OR FIND_IN_SET(179, f.categories_path) OR FIND_IN_SET(195, f.categories_path) OR FIND_IN_SET(199, f.categories_path) OR FIND_IN_SET(212, f.categories_path) OR FIND_IN_SET(214, f.categories_path) OR FIND_IN_SET(217, f.categories_path) OR FIND_IN_SET(218, f.categories_path) OR FIND_IN_SET(202, f.categories_path) OR FIND_IN_SET(219, f.categories_path) OR FIND_IN_SET(222, f.categories_path) OR FIND_IN_SET(221, f.categories_path) OR FIND_IN_SET(223, f.categories_path) OR FIND_IN_SET(231, f.categories_path) OR FIND_IN_SET(265, f.categories_path) OR FIND_IN_SET(233, f.categories_path) OR FIND_IN_SET(234, f.categories_path) OR FIND_IN_SET(235, f.categories_path) OR FIND_IN_SET(238, f.categories_path) OR FIND_IN_SET(239, f.categories_path) OR FIND_IN_SET(205, f.categories_path) OR FIND_IN_SET(242, f.categories_path) OR FIND_IN_SET(246, f.categories_path) OR FIND_IN_SET(250, f.categories_path) OR FIND_IN_SET(251, f.categories_path) OR FIND_IN_SET(254, f.categories_path) OR FIND_IN_SET(257, f.categories_path) OR FIND_IN_SET(258, f.categories_path) OR FIND_IN_SET(259, f.categories_path) OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(261, f.categories_path) OR FIND_IN_SET(262, 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 = 'en' ORDER BY fd.internal_name, fv.position

  1. SELECT filter_id, feature_id FROM cscart_product_filters WHERE status = 'A'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (50, 60, 68) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (50, 60, 68) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. 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 = 29847 GROUP BY c.company_id

  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id, products.cp_last_delivery, cscart_aval_statuses_descr.descr as aval_descr FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  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') AND cscart_categories.storefront_id IN (0, 1)  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 = 'en' LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND companies.status IN ('A') 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 = 29847 GROUP BY products.product_id   ORDER BY popularity.total desc, products.product_id ASC 

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29847

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29847) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29847) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_icon' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_icon' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '0' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_background' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '0' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 29847 AND type = 'T'

  1. SELECT cscart_et_quick_info.block_id, cscart_et_quick_info.data as settings, cscart_et_quick_info.status, cscart_et_quick_info.position, cscart_et_quick_info_title.data as data, cscart_et_quick_info_data.content_id as content_id, cscart_et_quick_info_descr.data as v_data FROM cscart_et_quick_info LEFT JOIN cscart_et_quick_info_title  	      ON cscart_et_quick_info_title.block_id = cscart_et_quick_info.block_id LEFT JOIN cscart_et_quick_info_data  	      ON cscart_et_quick_info_data.block_id = cscart_et_quick_info.block_id LEFT JOIN cscart_et_quick_info_descr  	      ON cscart_et_quick_info_descr.content_id = cscart_et_quick_info_data.content_id WHERE 1  AND cscart_et_quick_info_title.lang_code = 'en' AND cscart_et_quick_info_descr.lang_code = 'en' AND cscart_et_quick_info.status = 'A' AND cscart_et_quick_info_data.company_id = 1  ORDER BY cscart_et_quick_info.position asc

  1. SELECT a.*, a1.* FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id = a1.status_id WHERE a.product_id=29847 AND lang_code='en'

  1. SELECT d.descr FROM cscart_aval_statuses_descr d INNER JOIN cscart_aval_statuses s ON s.aval_status_id = d.aval_status_id WHERE s.aval_status_id=0 AND d.lang_code='en' AND s.status='A'

  1. SELECT id_path FROM cscart_categories WHERE category_id IN (173)

  1. SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (173) AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (29847) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (29847) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT a.*, b.option_name, b.internal_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 = 'en'  WHERE a.product_id IN (29847) AND a.status = 'A' ORDER BY a.position

  1. SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_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 = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (29847) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

  1. SELECT cscart_languages.* FROM cscart_languages  LEFT JOIN cscart_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = cscart_languages.lang_id WHERE 1 AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)   

  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('3') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('4') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

  1. SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_product_variation_group_features AS f INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (29847)

  1. 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 = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1748495014, 1) AND IF(to_date, to_date >= 1748495014, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc 

  1. SELECT bundle_id, linked_promotion_id FROM cscart_product_bundles

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT COUNT(*) FROM cscart_countries WHERE code = 'CO' AND status = 'A'

  1. SELECT COUNT(*) FROM cscart_states WHERE country_code = 'CO' AND code = 'Cund' AND status = 'A'

  1. SELECT state_id FROM cscart_states WHERE code = 'Cund' AND country_code = 'CO'

  1. SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE  a.country_code = 'CO' AND a.status = 'A' ORDER BY b.state

  1. SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

  1. SELECT COUNT(*) FROM cscart_countries WHERE code = 'CO' AND status = 'A'

  1. SELECT COUNT(*) FROM cscart_states WHERE country_code = 'CO' AND code = 'Cund' AND status = 'A'

  1. SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax FROM cscart_tax_descriptions WHERE tax_id = 6 AND lang_code = 'en'

  1. SELECT fqp.faq_question_id FROM cscart_faq_questions_products as fqp  WHERE fqp.product_id = 29847 AND fqp.single = 'Y' 

  1. SELECT fsp.faq_section_id FROM cscart_faq_sections_products as fsp  WHERE fsp.product_id = 29847 

  1. 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 = 'en' WHERE 1=1  AND cscart_product_files.product_id = 29847 AND preview_path != '' AND cscart_product_files.status = 'A'  ORDER BY cscart_product_files.position asc, cscart_product_file_descriptions.file_name asc

  1. 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 = 'en'  AND cscart_product_tabs.company_id = 1  ORDER BY position

  1. SELECT cscart_attachments.*, cscart_attachment_descriptions.description FROM cscart_attachments LEFT JOIN cscart_attachment_descriptions ON cscart_attachments.attachment_id = cscart_attachment_descriptions.attachment_id AND lang_code = 'en' WHERE object_type = 'product' AND object_id = 29847 AND type = 'M'  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status = 'A' ORDER BY position

  1. SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE parent_product_id = 29847

  1. 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 = 29847 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 

  1. SELECT a.*, b.option_name, b.internal_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 = 'en'  WHERE a.product_id IN (29847) AND a.status = 'A' ORDER BY a.position

  1. SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_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 = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (29847) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

  1. SELECT req_prod.required_id FROM cscart_product_required_products as req_prod  LEFT JOIN cscart_products ON req_prod.required_id = cscart_products.product_id LEFT JOIN cscart_products_categories ON req_prod.required_id = cscart_products_categories.product_id LEFT JOIN cscart_categories ON cscart_products_categories.category_id = cscart_categories.category_id WHERE  req_prod.product_id = 29847 AND cscart_products.status != 'D' AND cscart_categories.company_id = 1 GROUP BY req_prod.required_id

  1. SELECT zero_price_action FROM cscart_products WHERE product_id = 29847

  1. SELECT company_id FROM cscart_products WHERE product_id = 29847

  1. SELECT * FROM cscart_product_options_exceptions WHERE product_id = 29847 ORDER BY exception_id

  1. SELECT exceptions_type FROM cscart_products WHERE product_id = 29847

  1. SELECT a.*, b.option_name, b.internal_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 = 'en'  WHERE a.product_id IN (29847) AND a.option_type IN('S', 'R', 'C') AND a.status = 'A' ORDER BY a.position

  1. SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_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 = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (29847) AND a.product_id = 0 AND a.option_type IN('S', 'R', 'C') AND a.status = 'A' ORDER BY a.position

  1. SELECT 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 FROM cscart_product_prices WHERE lower_limit <=1 AND cscart_product_prices.product_id = 29847 AND cscart_product_prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit DESC LIMIT 1

  1. 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 = 29847  GROUP BY c.company_id LIMIT 2

  1. SELECT is_edp, options_type, tracking, unlimited_download, updated_timestamp FROM cscart_products WHERE product_id = 29847

  1. SELECT p.tracking, p.amount, p.min_qty, p.max_qty, p.qty_step, p.list_qty_count, p.out_of_stock_actions, p.product_type, pd.product FROM cscart_products AS p LEFT JOIN cscart_product_descriptions AS pd ON pd.product_id = p.product_id AND lang_code = 'en' WHERE p.product_id = 29847

  1. 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 = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1748495014, 1) AND IF(to_date, to_date >= 1748495014, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'cart' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc 

  1. SELECT bundle_id, linked_promotion_id FROM cscart_product_bundles

  1. SELECT COUNT(*) FROM cscart_countries WHERE code = 'CO' AND status = 'A'

  1. SELECT COUNT(*) FROM cscart_states WHERE country_code = 'CO' AND code = 'Cund' AND status = 'A'

  1. SELECT COUNT(*) FROM cscart_countries WHERE code = 'CO' AND status = 'A'

  1. SELECT COUNT(*) FROM cscart_states WHERE country_code = 'CO' AND code = 'Cund' AND status = 'A'

  1. SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE  a.country_code = 'CO' ORDER BY b.state

  1. SELECT a.shipping_id, b.shipping FROM cscart_shippings as a LEFT JOIN cscart_shipping_descriptions as b ON a.shipping_id = b.shipping_id AND b.lang_code = 'en' WHERE 1 AND (a.usergroup_ids = '' OR FIND_IN_SET(0, a.usergroup_ids) OR FIND_IN_SET(1, a.usergroup_ids)) AND a.status = 'A' ORDER BY a.position

  1. SELECT object_id, thread_id, type, object_type, company_id FROM cscart_discussion  WHERE 1  AND object_id = 29847 AND object_type = 'P'  AND cscart_discussion.company_id = 1  

  1. SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 107  AND cscart_discussion.company_id = 1

  1. SELECT AVG (dr.rating_value) FROM cscart_discussion_rating AS dr LEFT JOIN cscart_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN cscart_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 29847 AND d.object_type = 'P' AND type IN ( 'B', 'R' )  AND dp.status = 'A' AND dr.rating_value > 0

  1. SELECT cscart_discussion_rating.* FROM cscart_discussion_rating LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.post_id = cscart_discussion_rating.post_id WHERE 1  AND cscart_discussion_rating.thread_id = 107 AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_rating.rating_value DESC

  1. SELECT add_delivery_date_days FROM cscart_products WHERE product_id = 29847

  1. SELECT (cp_last_delivery + add_delivery_date_days) AS sum FROM cscart_products WHERE product_id = 29847

  1. SELECT product_review_id FROM cscart_product_reviews  LEFT JOIN cscart_users ON cscart_product_reviews.reply_user_id = cscart_users.user_id LEFT JOIN cscart_companies ON cscart_users.company_id = cscart_companies.company_id LEFT JOIN cscart_country_descriptions ON cscart_product_reviews.country_code = cscart_country_descriptions.code AND cscart_country_descriptions.lang_code = 'en' WHERE 1  AND cscart_product_reviews.product_id IN (29847) AND cscart_product_reviews.status = 'A' GROUP BY cscart_product_reviews.product_review_id

  1. SELECT cscart_product_reviews.*,cscart_users.company_id as reply_company_id,cscart_companies.company as reply_company,cscart_country_descriptions.country as country FROM cscart_product_reviews  LEFT JOIN cscart_users ON cscart_product_reviews.reply_user_id = cscart_users.user_id LEFT JOIN cscart_companies ON cscart_users.company_id = cscart_companies.company_id LEFT JOIN cscart_country_descriptions ON cscart_product_reviews.country_code = cscart_country_descriptions.code AND cscart_country_descriptions.lang_code = 'en' WHERE 1  AND cscart_product_reviews.product_id IN (29847) AND cscart_product_reviews.status = 'A'  ORDER BY cscart_product_reviews.product_review_timestamp desc  LIMIT 0, 10

  1. SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'reviews.filtering.with_images'

  1. SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'reviews.filtering.only_buyers'

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

  1. SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1

  1. 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('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position

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

  1. 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, (CASE WHEN company_values.object_id IS NOT NULL THEN company_values.value WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS company_values ON company_values.object_id = cscart_settings_objects.object_id AND company_values.company_id = 1 AND company_values.storefront_id = 1  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND section_id = 384 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position

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

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

  1. SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
Fruit Arrangement with Cheese and Crackers Bogota Colombia Delivery.
Notice Fruit Arrangement with Cheese and Crackers has zero inventory and is removed from the cart 
  1. SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 188

  1. SELECT layout_id FROM cscart_bm_locations WHERE location_id = 188

  1. SELECT c.*, IF (c.location_id != 188, 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 = 8 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')

  1. 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 (739, 740, 749, 742) ORDER BY g.order, g.parent_id, g.grid_id ASC

  1. 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 = 29847 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (1088, 1091, 1089, 1090, 1092, 1093, 1094, 1095, 1096, 1097, 1099, 1100, 1101, 1103, 1104, 1105, 1106, 1108, 1109, 1110, 1112, 1098, 1102, 1107, 1111, 1115, 1116, 1131, 1132, 1135, 1117, 1123, 1128, 1118, 1119, 1120, 1121, 1122, 1124, 1125, 1126, 1127, 1129, 1130, 1133, 1134, 1164, 1165, 1166, 1167)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 

  1. SELECT status FROM cscart_menus WHERE menu_id = 3

  1. SELECT * FROM cscart_menus LEFT JOIN cscart_menus_descriptions ON cscart_menus.menu_id = cscart_menus_descriptions.menu_id  WHERE cscart_menus_descriptions.lang_code = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 3 AND cscart_menus.company_id = 1

  1. SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, 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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position

  1. SELECT * FROM cscart_et_menu        WHERE 1 AND cscart_et_menu.param_id IN (67, 68) AND cscart_et_menu.lang_code = 'en'

  1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

  1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 1 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

  1. SELECT status FROM cscart_menus WHERE menu_id = 3

  1. SELECT * FROM cscart_menus LEFT JOIN cscart_menus_descriptions ON cscart_menus.menu_id = cscart_menus_descriptions.menu_id  WHERE cscart_menus_descriptions.lang_code = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 3 AND cscart_menus.company_id = 1

  1. SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, 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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position

  1. SELECT status FROM cscart_menus WHERE menu_id = 5

  1. SELECT * FROM cscart_menus LEFT JOIN cscart_menus_descriptions ON cscart_menus.menu_id = cscart_menus_descriptions.menu_id  WHERE cscart_menus_descriptions.lang_code = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 5 AND cscart_menus.company_id = 1

  1. SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, 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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '5' ORDER BY sd.position

  1. SELECT * FROM cscart_et_menu        WHERE 1 AND cscart_et_menu.param_id IN (94, 95, 97, 98, 79, 80, 84, 88, 81, 83, 85, 93, 99, 86, 82, 71, 72) AND cscart_et_menu.lang_code = 'en'

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 217  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 217

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '217/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(286, 287, 288) 

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 250  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 250

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '250/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(257, 197, 261, 196, 258, 253, 262, 260, 254, 252, 259, 256, 255, 251) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 250 AND lang_code = 'en'

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

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 167  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 167

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '167/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(280, 249, 270, 269, 272, 268) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 167 AND lang_code = 'en'

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

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 273  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 273

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '273/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(274, 275) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 273 AND lang_code = 'en'

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

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 195  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 195

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '195/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(199, 210, 239, 207, 203, 213, 216, 191, 227, 211, 208, 219, 226, 240, 192, 242, 214, 228, 193, 215, 238) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 195 AND lang_code = 'en'

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

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 229  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 229

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '229/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(266, 267) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 229 AND lang_code = 'en'

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

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 173  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 173

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '173/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 173 AND lang_code = 'en'

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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.level <= 3 AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(217, 194, 199, 266, 257, 274, 210, 197, 237, 261, 239, 286, 207, 203, 278, 213, 216, 191, 277, 167, 229, 227, 196, 267, 211, 258, 208, 219, 275, 226, 287, 273, 240, 192, 253, 262, 198, 288, 242, 214, 228, 260, 254, 173, 236, 218, 193, 252, 259, 256, 280, 230, 215, 195, 238, 291, 255, 251, 178, 265, 172, 175, 177, 174, 232, 233, 234, 235, 249, 270, 269, 272, 284, 268, 179) 

  1. SELECT status FROM cscart_menus WHERE menu_id = 5

  1. SELECT * FROM cscart_menus LEFT JOIN cscart_menus_descriptions ON cscart_menus.menu_id = cscart_menus_descriptions.menu_id  WHERE cscart_menus_descriptions.lang_code = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 5 AND cscart_menus.company_id = 1

  1. SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, 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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '5' ORDER BY sd.position

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 217  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 217

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '217/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(286, 287, 288) 

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 250  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 250

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '250/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(257, 197, 261, 196, 258, 253, 262, 260, 254, 252, 259, 256, 255, 251) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 250 AND lang_code = 'en'

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 167  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 167

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '167/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(280, 249, 270, 269, 272, 268) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 167 AND lang_code = 'en'

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 273  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 273

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '273/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(274, 275) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 273 AND lang_code = 'en'

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 195  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 195

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '195/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(199, 210, 239, 207, 203, 213, 216, 191, 227, 211, 208, 219, 226, 240, 192, 242, 214, 228, 193, 215, 238) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 195 AND lang_code = 'en'

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 229  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 229

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '229/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(266, 267) 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 229 AND lang_code = 'en'

  1. SELECT COUNT(*) FROM cscart_categories WHERE category_id = 173  AND company_id = 1 AND storefront_id IN (0, 1)

  1. SELECT id_path FROM cscart_categories WHERE category_id = 173

  1. 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_categories.storefront_id,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 = 'en'  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 = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1=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 '173/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

  1. SELECT category FROM cscart_category_descriptions WHERE category_id = 173 AND lang_code = 'en'

  1. SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, SUM(cscart_also_bought_products.amount) amnt, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.cp_last_delivery, cscart_aval_statuses_descr.descr as aval_descr FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  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') AND cscart_categories.storefront_id IN (0, 1)  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 = 'en' LEFT JOIN cscart_also_bought_products ON cscart_also_bought_products.related_id = products.product_id  LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' WHERE 1  AND companies.status IN ('A') 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_also_bought_products.product_id IN (29847) GROUP BY product_id   ORDER BY SUM(cscart_also_bought_products.amount) desc, products.product_id ASC  LIMIT 0, 7

  1. SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)  

  1. SELECT cscart_product_prices.product_id, 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 FROM cscart_product_prices  WHERE cscart_product_prices.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id

  1. SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)  AND cscart_product_descriptions.lang_code = 'en' 

  1. SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.storefront_id IN (0, 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', 'H')  WHERE cscart_products_categories.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)   GROUP BY cscart_products_categories.product_id

  1. SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions  WHERE cscart_ult_product_descriptions.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110) AND cscart_ult_product_descriptions.company_id = 1 AND cscart_ult_product_descriptions.lang_code = 'en' 

  1. SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0) 

  1. SELECT cscart_product_review_prepared_data.product_id AS product_id, cscart_product_review_prepared_data.average_rating AS average_rating, cscart_product_review_prepared_data.reviews_count AS reviews_count FROM cscart_product_review_prepared_data  WHERE cscart_product_review_prepared_data.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)  AND cscart_product_review_prepared_data.storefront_id = 0 

  1. SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices  WHERE cscart_ult_product_prices.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)  AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 1 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY cscart_ult_product_prices.product_id

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30097

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30097) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30097) AND type = 'T' ORDER BY position

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30316

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30316) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30316) AND type = 'T' ORDER BY position

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29868

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29868) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29868) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 29868 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30128

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30128) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30128) AND type = 'T' ORDER BY position

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30266

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30266) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30266) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 30266 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29864

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29864) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29864) AND type = 'T' ORDER BY position

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30110

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30110) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30110) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 30110 AND type = 'T'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT a.*, b.option_name, b.internal_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 = 'en'  WHERE a.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110) AND a.status = 'A' ORDER BY a.position

  1. SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_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 = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

  1. SELECT b.variant_name, a.*, 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 b.variant_id = a.variant_id AND b.lang_code = 'en' 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.option_id IN (753) AND a.status='A' ORDER BY  a.position, a.variant_id 

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (3125, 3126, 3127) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (3125, 3126, 3127) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT option_id, option_type FROM cscart_product_options WHERE option_id IN (753)

  1. SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_product_variation_group_features AS f INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (30097, 30316, 29868, 30128, 30266, 29864, 30110)

  1. SELECT * FROM cscart_product_options_exceptions WHERE product_id = 30097 ORDER BY exception_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1121583311' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1121583311' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT option_type as type, option_id FROM cscart_product_options WHERE option_id IN (753)

  1. 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, a.variant_id 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 IN (3125)

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, 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 (prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount) / 100))) as price, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.cp_last_delivery, cscart_aval_statuses_descr.descr as aval_descr FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  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') AND cscart_categories.storefront_id IN (0, 1)  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 = 'en' LEFT JOIN cscart_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 LEFT JOIN cscart_ult_product_prices as shared_prices_2 ON shared_prices.product_id = shared_prices_2.product_id AND shared_prices_2.company_id = 1 AND shared_prices_2.lower_limit = 1 AND shared_prices_2.price < shared_prices.price  AND shared_prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (173) AND products.product_id NOT IN (29847) AND companies.status IN ('A') AND (prices.price >= 89964.00 OR shared_prices.price >= 89964.00) AND (prices.price <= 309876.00 OR shared_prices.price <= 309876.00) AND (products.amount > 0 OR products.tracking = 'D') 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 prices_2.price IS NULL AND shared_prices_2.price IS NULL GROUP BY product_id   ORDER BY popularity.total desc, products.product_id ASC  LIMIT 0, 10

  1. SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)  

  1. SELECT cscart_product_prices.product_id, 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 FROM cscart_product_prices  WHERE cscart_product_prices.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id

  1. SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)  AND cscart_product_descriptions.lang_code = 'en' 

  1. SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.storefront_id IN (0, 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', 'H')  LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 173 WHERE cscart_products_categories.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)   GROUP BY cscart_products_categories.product_id

  1. SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions  WHERE cscart_ult_product_descriptions.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000) AND cscart_ult_product_descriptions.company_id = 1 AND cscart_ult_product_descriptions.lang_code = 'en' 

  1. SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0) 

  1. SELECT cscart_product_review_prepared_data.product_id AS product_id, cscart_product_review_prepared_data.average_rating AS average_rating, cscart_product_review_prepared_data.reviews_count AS reviews_count FROM cscart_product_review_prepared_data  WHERE cscart_product_review_prepared_data.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)  AND cscart_product_review_prepared_data.storefront_id = 0 

  1. SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices  WHERE cscart_ult_product_prices.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)  AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 1 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY cscart_ult_product_prices.product_id

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29796

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29796) AND type = 'I' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (15) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 15 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 15 AND product_id = 29796 AND type = 'I'

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id = 29796 AND type = 'I' AND is_main_img = 'Y'

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29796) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33, 16) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 29796 AND type = 'T'

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 16 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '4' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 16 AND product_id = 29796 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30303

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30303) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30303) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 30303 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30102

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30102) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30102) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 30102 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29999

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29999) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29999) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 29999 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29846

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29846) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29846) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 29846 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 29848

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29848) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (29848) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 29848 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30425

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30425) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30425) AND type = 'T' ORDER BY position

  1. SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en' WHERE 1  AND cscart_cp_videos.company_id = 1 AND cscart_cp_videos.video_id IN (33) AND cscart_cp_videos.status = 'A'  ORDER BY cscart_cp_videos.position asc 

  1. SELECT video_image_id FROM cscart_cp_video_images WHERE video_id = 33 AND lang_code = 'en'

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'video_preview' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '57' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT IFNULL(position, 0) FROM cscart_cp_video_product_links WHERE video_id = 33 AND product_id = 30425 AND type = 'T'

  1. SELECT group_id FROM cscart_product_variation_group_products WHERE product_id = 30000

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30000) AND type = 'I' ORDER BY position

  1. SELECT video_id FROM cscart_cp_video_product_links WHERE product_id IN (30000) AND type = 'T' ORDER BY position

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT a.*, b.option_name, b.internal_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 = 'en'  WHERE a.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000) AND a.status = 'A' ORDER BY a.position

  1. SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_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 = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

  1. SELECT b.variant_name, a.*, 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 b.variant_id = a.variant_id AND b.lang_code = 'en' 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.option_id IN (763) AND a.status='A' ORDER BY  a.position, a.variant_id 

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (3189, 3190, 3191, 3192) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (3189, 3190, 3191, 3192) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT option_id, option_type FROM cscart_product_options WHERE option_id IN (763)

  1. SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_product_variation_group_features AS f INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (29796, 30303, 30102, 29999, 29846, 29848, 30425, 30000)

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9

  1. SELECT * FROM cscart_product_options_exceptions WHERE product_id = 30000 ORDER BY exception_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '226242085' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, 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 = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '226242085' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

  1. SELECT option_type as type, option_id FROM cscart_product_options WHERE option_id IN (763)

  1. 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, a.variant_id 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 IN (3189)

  1. SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority

  1. SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 9
  • FAQ
  • Contact us
WhatsApp
WhatsApp
All categories 
  1. SELECT details_layout FROM cscart_products WHERE product_id = 29847

  1. SELECT category_id FROM cscart_products_categories WHERE product_id = 29847 AND link_type = 'M'

  1. SELECT product_details_view FROM cscart_categories WHERE category_id = 173

  1. SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=0 AND a.product_id = 29847 AND a1.lang_code='en' ORDER BY a.lower_limit DESC LIMIT 1
-20%
Frutero Queso Galletas Envio Bogota

Fruit Arrangement with Cheese and Crackers

FJMFQGLL
Base Type: Wicker Basket, Fruit: Sí, Other Groceries: Sí
COP$199.920
Old price: COP$249.900
You save: COP$49.980
(Including tax)

1- SELECTED PRODUCT

  1. SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=0 AND a.product_id = 29847 AND a1.lang_code='en' ORDER BY a.lower_limit DESC LIMIT 1

Out of Stock

Earliest Delivery: Today Paying Before 12M

Calendar

COP$199.920
Diez Mil Opiniones de Compradores

Opiniones recogidas en un Sitio Externo

Suman cerca de Diez Mil Opiniones.

Muchas de ellas son sobre el producto comprado.

Son Compradores Verificados.

También se tiene opiniones Internas

Es decir aquellas que escriben los clientes.

De esas son mas de Un Mil Doscienteas.

Son Opiniones Generales de los Clientes.

 

 

Shipping costs

 

SHIPPING IS FREE IF FULFILLED:

* Total of the products is greater than COP$79,900 (USD$20)

* Make payment at least nine (9) days prior to delivery.

* Delivery is within the coverage in Bogotá.

For each day you pay in advance, shipping will be cheaper. 

*  If the Total of products is Equal or Less than COP$79,900 the Shipping Price Increases

Payment methods

  • PayPal
  • NEQUI, Daviplata, ScotiaBank
  • Any Credit Card, or PSE
  • Wire transfer (Western Union)
Why us
  • Fair Prices
  • Fast delivery
  • You will know, before you buy, exactly what you will receive
  • Products as in the photos
  • You will be informed all the time
  • 5 Star Rating by Verified Customers
+
-20%
Fruit Arrangement with Cheese and Crackers 
  1. SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=0 AND a.product_id = 29847 AND a1.lang_code='en' ORDER BY a.lower_limit DESC LIMIT 1

Out of Stock

  1. SELECT * FROM cscart_product_bundles as bundles LEFT JOIN cscart_product_bundle_descriptions as descriptions ON bundles.bundle_id = descriptions.bundle_id AND descriptions.lang_code = 'en' LEFT JOIN cscart_product_bundle_product_links as links ON bundles.bundle_id = links.bundle_id WHERE 1=1  AND links.product_id = 29847 AND links.show_on_product_page = 'Y' AND bundles.status = 'A' AND IF(bundles.date_from, bundles.date_from <= 1748495014, 1) AND IF(bundles.date_to, bundles.date_to >= 1748495014, 1) GROUP BY bundles.bundle_id  ORDER BY bundles.bundle_id asc  LIMIT 0, 15

Fruit Arrangement with Cheese and Crackers

Looking for fresh Colombian fruit on a Basket? Or a lovely gift to wish someone a fast recovery? This is the perfect gift when you want to wish the best to a close friend or just any other occasion like Father's Day or even a Birthday... 

Almost a banquet at home.

This product includes:

+ Tropical Fruits (Bananas, Mango, Kiwi, Apples, Pears, Grapes, among others ...) **

+ Gouda Cheese (250gr)

+ RITZ crackers (240 gr.)

+ Reusable Basket

+ Printed Card with your personalized message.

+ Bogota Delivery. *Restrictions Apply

** If you wish to add a different fruit, please contact us or write your preferred choice on "Client Notes" when checking out. 

Basket and contents may vary according to availability.

ORDER NOW!

 

Contenido

Base Type:
Wicker Basket
Fruit:
Sí
Other Groceries:
Sí
  1. SELECT b.*, d.*, c.* FROM cscart_bm_blocks as b LEFT JOIN cscart_bm_blocks_descriptions as d ON b.block_id = d.block_id LEFT JOIN cscart_bm_blocks_content as c ON b.block_id = c.block_id AND d.lang_code=c.lang_code WHERE b.block_id = 141 AND d.lang_code='en'  AND b.company_id = 1 AND ((c.object_id = 29847 AND c.object_type like 'products') OR (c.object_id = 0 AND c.object_type like ''))  ORDER BY snapping_id DESC LIMIT 1

This product is delivered today if you choose today's date, when you place the order, confirm the payment before 12:00 M, Colombian time, and it is not Saturday, Sunday, or a holiday.

Check the coverage of FLORISTERIA JM in the city of Bogotá, looking at this link: Delivery coverage area in Bogotá. (It is delivered between south 50th street (Calle 50 SUR) and north 210th street (Calle 210) and no deliveries are made on "east" roads (carreras ESTE). Orders outside that range cannot be delivered).

If you have an emergency, do not hesitate to contact us by email, FloristeriaJMBogota@gmail.com or by Chat or Whatsapp.

  1. SELECT b.*, d.*, c.* FROM cscart_bm_blocks as b LEFT JOIN cscart_bm_blocks_descriptions as d ON b.block_id = d.block_id LEFT JOIN cscart_bm_blocks_content as c ON b.block_id = c.block_id AND d.lang_code=c.lang_code WHERE b.block_id = 142 AND d.lang_code='en'  AND b.company_id = 1 AND ((c.object_id = 29847 AND c.object_type like 'products') OR (c.object_id = 0 AND c.object_type like ''))  ORDER BY snapping_id DESC LIMIT 1
Home Delivery in Bogotá is Free at Floristería JM, if the following conditions apply:

1. The items in the basket are valued at more than $79,900.
2. Payment is made at least nine (9) days in advance of delivery.
3. The more days you pay in advance, the cheaper the delivery will be.
4. With the Zone Calculator tool, you can find out how much your delivery will cost.

VERY IMPORTANT: Delivery is only available between 50th Street South and 210th Street, and addresses with the term "east" are not included. Orders outside this range cannot be delivered.

During low season, we may be able to cover some neighboring municipalities; however, please contact us before placing your order for deliveries to those municipalities. You can see shipping prices here https://www.floristeriasbogota.net/envio-flores-chia-madrid-cundinamarca.html

How to Reduce Shipping Costs?


+ Make the total amount of the purchased products greater than COP$79,900 (>USD$18)
+ Make payment several days in advance of delivery.

They also Bought

You May Also Like

Buyer reviews