1. SET NAMES 'utf8', sql_mode = '', SESSION group_concat_max_len = 3000
    
  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev2.mpdev.finleo.ru' OR storefronts.url = 'www.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev2.mpdev.finleo.ru' DESC, storefronts.url = 'www.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%' desc 
    
  1. SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
    
  1. SET time_zone = '+03:00'
    
  1. SELECT url FROM cscart_bitrix
    
  1. SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'spectehnika'
    
  1. SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'spectehnika'
    
  1. SELECT city_id, city, link FROM cscart_custom_city WHERE link = '?brand_id=3059%2Fpage-2%2F%2F%2F%2F%2Fpage-2%2F'
    
  1. SELECT `brand_id` FROM `cscart_brands` WHERE `link` = '?brand_id=3059%2Fpage-2%2F%2F%2F%2F%2Fpage-2%2F'
    
  1. SELECT `feature_id` 
                    FROM cscart_product_features_descriptions 
                    WHERE `link` = '?brand'
    
  1. SELECT PFVD.variant_id, PFVD.variant 
                    FROM cscart_product_feature_variant_descriptions AS PFVD
                    LEFT JOIN cscart_product_feature_variants AS PFV
                    ON PFVD.variant_id = PFV.variant_id
                    WHERE PFVD.link = 'id=3059%2Fpage-2%2F%2F%2F%2F%2Fpage-2%2F' AND PFV.feature_id = 0
    
  1. SELECT type FROM cscart_seo_names WHERE name = 'spectehnika' 
    
  1. SELECT `hash` FROM `hash_filters` WHERE `link` = 'spectehnika'
    
  1. SELECT `link`, `company_id` FROM `price_list` WHERE `link` = 'spectehnika'
    
  1. SELECT * FROM cscart_seo_names WHERE name = 'spectehnika'  
    
  1. SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
    
  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 name, path FROM cscart_seo_names WHERE `object_id` = 506 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' 
    
  1. SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1
    
  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 * FROM cscart_abt__ut2_settings WHERE lang_code = 'ru' AND storefront_id = 1
    
  1. SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'Cobalt.less'
    
  1. SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 3
    
  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 = 'ru'  LEFT JOIN cscart_tilda_locations ON l.location_id = cscart_tilda_locations.inner_location_id WHERE l.layout_id = 3  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(506, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
    
  1. SELECT robots FROM cscart_category_descriptions WHERE category_id = 506
    
  1. SELECT `timestamp` FROM `cscart_currencies` WHERE `currency_code` = 'USD'
    
  1. SELECT category_id FROM cscart_categories WHERE category_id = 506  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)
    
  1. SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
    
  1. SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'ru'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 506  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE cscart_categories.category_id = 506 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))
    
  1. SELECT id_path FROM cscart_categories WHERE category_id = 506
    
  1. SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_category_descriptions.products_count,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_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 = 'ru'  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 = 'ru'  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.parent_id IN (506) AND cscart_categories.id_path LIKE '506/%' AND cscart_categories.storefront_id IN (0, 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(564, 568, 597, 566, 732, 577, 591, 592, 628, 662, 753, 755) 
    
  1. SELECT `L`.`location_id`, `LD`.`tilda_link` FROM cscart_bm_locations AS L
                         LEFT JOIN cscart_bm_locations_descriptions AS LD
                                                ON L.location_id = LD.location_id
                         WHERE `L`.`object_ids` LIKE '%506%' AND `LD`.`is_tilda_page` = 'Y'
    
  1. SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.tabs, cscart_banners.status, cscart_banners.timestamp, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.mini FROM cscart_banners  LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru'WHERE 1  AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.category_id = 506 AND cscart_banners.status = 'A' AND IF (cscart_banners.type not like 'abt__ut2', 'available', IF ( cscart_banners.type like 'abt__ut2' AND ( cscart_banners.abt__ut2_use_avail_period = 'N'
    OR
    (
    cscart_banners.abt__ut2_use_avail_period = 'Y'
    AND (cscart_banners.abt__ut2_avail_from = 0 OR cscart_banners.abt__ut2_avail_from <= 1750942794)
    AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1750942794)
    )
    ), 'available', 'not available') ) = 'available'  AND (cscart_banners.abt__ut2_usergroup_ids = '' OR FIND_IN_SET(0, cscart_banners.abt__ut2_usergroup_ids) OR FIND_IN_SET(1, cscart_banners.abt__ut2_usergroup_ids))  ORDER BY cscart_banner_descriptions.banner asc 
    
  1.                 SELECT * FROM `banners__images` AS `B` 
                        LEFT JOIN `files` AS `F` 
                            ON `F`.`id` = `B`.`file_id` 
                             WHERE `B`.`banner_id` = 71 AND `B`.`breakpoint` = 'desktop'
    
  1.                 SELECT * FROM `banners__images` AS `B` 
                        LEFT JOIN `files` AS `F` 
                            ON `F`.`id` = `B`.`file_id` 
                             WHERE `B`.`banner_id` = 71 AND `B`.`breakpoint` = 'mobile'
    
  1.                 SELECT * FROM `banners__images` AS `B` 
                        LEFT JOIN `files` AS `F` 
                            ON `F`.`id` = `B`.`file_id` 
                             WHERE `B`.`banner_id` = 72 AND `B`.`breakpoint` = 'desktop'
    
  1.                 SELECT * FROM `banners__images` AS `B` 
                        LEFT JOIN `files` AS `F` 
                            ON `F`.`id` = `B`.`file_id` 
                             WHERE `B`.`banner_id` = 72 AND `B`.`breakpoint` = 'mobile'
    
  1.                 SELECT * FROM `banners__images` AS `B` 
                        LEFT JOIN `files` AS `F` 
                            ON `F`.`id` = `B`.`file_id` 
                             WHERE `B`.`banner_id` = 70 AND `B`.`breakpoint` = 'desktop'
    
  1.                 SELECT * FROM `banners__images` AS `B` 
                        LEFT JOIN `files` AS `F` 
                            ON `F`.`id` = `B`.`file_id` 
                             WHERE `B`.`banner_id` = 70 AND `B`.`breakpoint` = 'mobile'
    
  1. SELECT cscart_banners.banner_id, cscart_banners.status, cscart_banner_descriptions.banner, cscart_banners.type, cscart_banners.target, cscart_banners.category_id, cscart_banners.localization, cscart_banners.timestamp, cscart_banner_descriptions.description, cscart_banners.button_name, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.page, cscart_banners.tabs, cscart_banners.mini, cscart_banners.place, cscart_abt__ut2_banner_images.abt__ut2_banner_image_id, cscart_banners.abt__ut2_usergroup_ids, cscart_banners.abt__ut2_use_avail_period, cscart_banners.abt__ut2_avail_from, cscart_banners.abt__ut2_avail_till, cscart_banners.abt__ut2_button_use, cscart_banners.abt__ut2_button_text_color, cscart_banners.abt__ut2_button_text_color_use, cscart_banners.abt__ut2_button_color, cscart_banners.abt__ut2_button_color_use, cscart_banners.abt__ut2_title_color, cscart_banners.abt__ut2_title_color_use, cscart_banners.abt__ut2_title_font_size, cscart_banners.abt__ut2_title_font_weight, cscart_banners.abt__ut2_title_tag, cscart_banners.abt__ut2_background_image_size, cscart_banners.abt__ut2_title_shadow, cscart_banners.abt__ut2_description_font_size, cscart_banners.abt__ut2_description_color, cscart_banners.abt__ut2_description_color_use, cscart_banners.abt__ut2_description_bg_color, cscart_banners.abt__ut2_description_bg_color_use, cscart_banners.abt__ut2_object, cscart_banners.abt__ut2_background_color, cscart_banners.abt__ut2_background_color_use, cscart_banners.abt__ut2_class, cscart_banners.abt__ut2_color_scheme, cscart_banners.abt__ut2_content_valign, cscart_banners.abt__ut2_content_align, cscart_banners.abt__ut2_content_full_width, cscart_banners.abt__ut2_content_bg, cscart_banners.abt__ut2_content_bg_position, cscart_banners.abt__ut2_content_bg_opacity, cscart_banners.abt__ut2_content_bg_color, cscart_banners.abt__ut2_content_bg_color_use, cscart_banners.abt__ut2_padding, cscart_banners.abt__ut2_how_to_open, cscart_banners.abt__ut2_data_type, cscart_banners.abt__ut2_youtube_use, cscart_banners.abt__ut2_youtube_autoplay, cscart_banners.abt__ut2_youtube_hide_controls, cscart_banners.abt__ut2_background_type, cscart_banners.abt__ut2_background_mp4_video, cscart_banner_descriptions.abt__ut2_button_text, cscart_banner_descriptions.abt__ut2_title, cscart_banner_descriptions.abt__ut2_url, cscart_banner_descriptions.abt__ut2_description, cscart_banner_descriptions.abt__ut2_youtube_id, cscart_banners.abt__ut2_tablet_use, cscart_banners.abt__ut2_tablet_content_valign, cscart_banners.abt__ut2_tablet_content_valign_use_own, cscart_banners.abt__ut2_tablet_content_align, cscart_banners.abt__ut2_tablet_content_align_use_own, cscart_banners.abt__ut2_tablet_padding, cscart_banners.abt__ut2_tablet_padding_use_own, cscart_banners.abt__ut2_tablet_content_full_width, cscart_banners.abt__ut2_tablet_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_tablet_title, cscart_banner_descriptions.abt__ut2_tablet_title_use_own, cscart_banners.abt__ut2_tablet_title_font_size, cscart_banners.abt__ut2_tablet_title_font_size_use_own, cscart_banners.abt__ut2_tablet_title_shadow, cscart_banners.abt__ut2_tablet_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_tablet_description, cscart_banner_descriptions.abt__ut2_tablet_description_use_own, cscart_banners.abt__ut2_tablet_description_font_size, cscart_banners.abt__ut2_tablet_description_font_size_use_own, cscart_banners.abt__ut2_tablet_main_image_use_own, cscart_banners.abt__ut2_tablet_background_type, cscart_banners.abt__ut2_tablet_background_type_use_own, cscart_banners.abt__ut2_tablet_background_mp4_video, cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, cscart_banners.abt__ut2_tablet_background_image_use_own, cscart_banners.abt__ut2_tablet_background_image_size, cscart_banners.abt__ut2_tablet_background_image_size_use_own, cscart_banners.abt__ut2_tablet_button_use, cscart_banners.abt__ut2_tablet_button_use_use_own, cscart_banner_descriptions.abt__ut2_tablet_button_text, cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, cscart_banners.abt__ut2_tablet_content_bg, cscart_banners.abt__ut2_tablet_content_bg_use_own, cscart_banners.abt__ut2_tablet_content_bg_position, cscart_banners.abt__ut2_tablet_content_bg_position_use_own, cscart_banners.abt__ut2_tablet_content_bg_opacity, cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, cscart_banners.abt__ut2_tablet_content_bg_color, cscart_banners.abt__ut2_tablet_content_bg_color_use_own, cscart_banners.abt__ut2_tablet_content_bg_color_use, cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, cscart_banners.abt__ut2_tablet_button_text_color, cscart_banners.abt__ut2_tablet_button_text_color_use_own, cscart_banners.abt__ut2_tablet_button_text_color_use, cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, cscart_banners.abt__ut2_tablet_button_color, cscart_banners.abt__ut2_tablet_button_color_use_own, cscart_banners.abt__ut2_tablet_button_color_use, cscart_banners.abt__ut2_tablet_button_color_use_use_own, cscart_banners.abt__ut2_tablet_content_valign, cscart_banners.abt__ut2_tablet_content_valign_use_own, cscart_banners.abt__ut2_tablet_content_align, cscart_banners.abt__ut2_tablet_content_align_use_own, cscart_banners.abt__ut2_tablet_padding, cscart_banners.abt__ut2_tablet_padding_use_own, cscart_banners.abt__ut2_tablet_content_full_width, cscart_banners.abt__ut2_tablet_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_tablet_title, cscart_banner_descriptions.abt__ut2_tablet_title_use_own, cscart_banners.abt__ut2_tablet_title_font_size, cscart_banners.abt__ut2_tablet_title_font_size_use_own, cscart_banners.abt__ut2_tablet_title_shadow, cscart_banners.abt__ut2_tablet_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_tablet_description, cscart_banner_descriptions.abt__ut2_tablet_description_use_own, cscart_banners.abt__ut2_tablet_description_font_size, cscart_banners.abt__ut2_tablet_description_font_size_use_own, cscart_banners.abt__ut2_tablet_main_image_use_own, cscart_banners.abt__ut2_tablet_background_type, cscart_banners.abt__ut2_tablet_background_type_use_own, cscart_banners.abt__ut2_tablet_background_mp4_video, cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, cscart_banners.abt__ut2_tablet_background_image_use_own, cscart_banners.abt__ut2_tablet_background_image_size, cscart_banners.abt__ut2_tablet_background_image_size_use_own, cscart_banners.abt__ut2_tablet_button_use, cscart_banners.abt__ut2_tablet_button_use_use_own, cscart_banner_descriptions.abt__ut2_tablet_button_text, cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, cscart_banners.abt__ut2_tablet_content_bg, cscart_banners.abt__ut2_tablet_content_bg_use_own, cscart_banners.abt__ut2_tablet_content_bg_position, cscart_banners.abt__ut2_tablet_content_bg_position_use_own, cscart_banners.abt__ut2_tablet_content_bg_opacity, cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, cscart_banners.abt__ut2_tablet_content_bg_color, cscart_banners.abt__ut2_tablet_content_bg_color_use_own, cscart_banners.abt__ut2_tablet_content_bg_color_use, cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, cscart_banners.abt__ut2_tablet_button_text_color, cscart_banners.abt__ut2_tablet_button_text_color_use_own, cscart_banners.abt__ut2_tablet_button_text_color_use, cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, cscart_banners.abt__ut2_tablet_button_color, cscart_banners.abt__ut2_tablet_button_color_use_own, cscart_banners.abt__ut2_tablet_button_color_use, cscart_banners.abt__ut2_tablet_button_color_use_use_own, cscart_banners.abt__ut2_mobile_use, cscart_banners.abt__ut2_mobile_content_valign, cscart_banners.abt__ut2_mobile_content_valign_use_own, cscart_banners.abt__ut2_mobile_content_align, cscart_banners.abt__ut2_mobile_content_align_use_own, cscart_banners.abt__ut2_mobile_padding, cscart_banners.abt__ut2_mobile_padding_use_own, cscart_banners.abt__ut2_mobile_content_full_width, cscart_banners.abt__ut2_mobile_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_mobile_title, cscart_banner_descriptions.abt__ut2_mobile_title_use_own, cscart_banners.abt__ut2_mobile_title_font_size, cscart_banners.abt__ut2_mobile_title_font_size_use_own, cscart_banners.abt__ut2_mobile_title_shadow, cscart_banners.abt__ut2_mobile_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_mobile_description, cscart_banner_descriptions.abt__ut2_mobile_description_use_own, cscart_banners.abt__ut2_mobile_description_font_size, cscart_banners.abt__ut2_mobile_description_font_size_use_own, cscart_banners.abt__ut2_mobile_main_image_use_own, cscart_banners.abt__ut2_mobile_background_type, cscart_banners.abt__ut2_mobile_background_type_use_own, cscart_banners.abt__ut2_mobile_background_mp4_video, cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, cscart_banners.abt__ut2_mobile_background_image_use_own, cscart_banners.abt__ut2_mobile_background_image_size, cscart_banners.abt__ut2_mobile_background_image_size_use_own, cscart_banners.abt__ut2_mobile_button_use, cscart_banners.abt__ut2_mobile_button_use_use_own, cscart_banner_descriptions.abt__ut2_mobile_button_text, cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, cscart_banners.abt__ut2_mobile_content_bg, cscart_banners.abt__ut2_mobile_content_bg_use_own, cscart_banners.abt__ut2_mobile_content_bg_position, cscart_banners.abt__ut2_mobile_content_bg_position_use_own, cscart_banners.abt__ut2_mobile_content_bg_opacity, cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, cscart_banners.abt__ut2_mobile_content_bg_color, cscart_banners.abt__ut2_mobile_content_bg_color_use_own, cscart_banners.abt__ut2_mobile_content_bg_color_use, cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, cscart_banners.abt__ut2_mobile_button_text_color, cscart_banners.abt__ut2_mobile_button_text_color_use_own, cscart_banners.abt__ut2_mobile_button_text_color_use, cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, cscart_banners.abt__ut2_mobile_button_color, cscart_banners.abt__ut2_mobile_button_color_use_own, cscart_banners.abt__ut2_mobile_button_color_use, cscart_banners.abt__ut2_mobile_button_color_use_use_own, cscart_banners.abt__ut2_mobile_content_valign, cscart_banners.abt__ut2_mobile_content_valign_use_own, cscart_banners.abt__ut2_mobile_content_align, cscart_banners.abt__ut2_mobile_content_align_use_own, cscart_banners.abt__ut2_mobile_padding, cscart_banners.abt__ut2_mobile_padding_use_own, cscart_banners.abt__ut2_mobile_content_full_width, cscart_banners.abt__ut2_mobile_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_mobile_title, cscart_banner_descriptions.abt__ut2_mobile_title_use_own, cscart_banners.abt__ut2_mobile_title_font_size, cscart_banners.abt__ut2_mobile_title_font_size_use_own, cscart_banners.abt__ut2_mobile_title_shadow, cscart_banners.abt__ut2_mobile_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_mobile_description, cscart_banner_descriptions.abt__ut2_mobile_description_use_own, cscart_banners.abt__ut2_mobile_description_font_size, cscart_banners.abt__ut2_mobile_description_font_size_use_own, cscart_banners.abt__ut2_mobile_main_image_use_own, cscart_banners.abt__ut2_mobile_background_type, cscart_banners.abt__ut2_mobile_background_type_use_own, cscart_banners.abt__ut2_mobile_background_mp4_video, cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, cscart_banners.abt__ut2_mobile_background_image_use_own, cscart_banners.abt__ut2_mobile_background_image_size, cscart_banners.abt__ut2_mobile_background_image_size_use_own, cscart_banners.abt__ut2_mobile_button_use, cscart_banners.abt__ut2_mobile_button_use_use_own, cscart_banner_descriptions.abt__ut2_mobile_button_text, cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, cscart_banners.abt__ut2_mobile_content_bg, cscart_banners.abt__ut2_mobile_content_bg_use_own, cscart_banners.abt__ut2_mobile_content_bg_position, cscart_banners.abt__ut2_mobile_content_bg_position_use_own, cscart_banners.abt__ut2_mobile_content_bg_opacity, cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, cscart_banners.abt__ut2_mobile_content_bg_color, cscart_banners.abt__ut2_mobile_content_bg_color_use_own, cscart_banners.abt__ut2_mobile_content_bg_color_use, cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, cscart_banners.abt__ut2_mobile_button_text_color, cscart_banners.abt__ut2_mobile_button_text_color_use_own, cscart_banners.abt__ut2_mobile_button_text_color_use, cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, cscart_banners.abt__ut2_mobile_button_color, cscart_banners.abt__ut2_mobile_button_color_use_own, cscart_banners.abt__ut2_mobile_button_color_use, cscart_banners.abt__ut2_mobile_button_color_use_use_own FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru' LEFT JOIN cscart_abt__ut2_banner_images ON cscart_abt__ut2_banner_images.banner_id = cscart_banners.banner_id AND cscart_abt__ut2_banner_images.lang_code = 'ru' WHERE cscart_banners.banner_id = 71 AND cscart_banners.status IN ('A', 'H') 
    
  1. SELECT cscart_banners.banner_id, cscart_banners.status, cscart_banner_descriptions.banner, cscart_banners.type, cscart_banners.target, cscart_banners.category_id, cscart_banners.localization, cscart_banners.timestamp, cscart_banner_descriptions.description, cscart_banners.button_name, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.page, cscart_banners.tabs, cscart_banners.mini, cscart_banners.place, cscart_abt__ut2_banner_images.abt__ut2_banner_image_id, cscart_banners.abt__ut2_usergroup_ids, cscart_banners.abt__ut2_use_avail_period, cscart_banners.abt__ut2_avail_from, cscart_banners.abt__ut2_avail_till, cscart_banners.abt__ut2_button_use, cscart_banners.abt__ut2_button_text_color, cscart_banners.abt__ut2_button_text_color_use, cscart_banners.abt__ut2_button_color, cscart_banners.abt__ut2_button_color_use, cscart_banners.abt__ut2_title_color, cscart_banners.abt__ut2_title_color_use, cscart_banners.abt__ut2_title_font_size, cscart_banners.abt__ut2_title_font_weight, cscart_banners.abt__ut2_title_tag, cscart_banners.abt__ut2_background_image_size, cscart_banners.abt__ut2_title_shadow, cscart_banners.abt__ut2_description_font_size, cscart_banners.abt__ut2_description_color, cscart_banners.abt__ut2_description_color_use, cscart_banners.abt__ut2_description_bg_color, cscart_banners.abt__ut2_description_bg_color_use, cscart_banners.abt__ut2_object, cscart_banners.abt__ut2_background_color, cscart_banners.abt__ut2_background_color_use, cscart_banners.abt__ut2_class, cscart_banners.abt__ut2_color_scheme, cscart_banners.abt__ut2_content_valign, cscart_banners.abt__ut2_content_align, cscart_banners.abt__ut2_content_full_width, cscart_banners.abt__ut2_content_bg, cscart_banners.abt__ut2_content_bg_position, cscart_banners.abt__ut2_content_bg_opacity, cscart_banners.abt__ut2_content_bg_color, cscart_banners.abt__ut2_content_bg_color_use, cscart_banners.abt__ut2_padding, cscart_banners.abt__ut2_how_to_open, cscart_banners.abt__ut2_data_type, cscart_banners.abt__ut2_youtube_use, cscart_banners.abt__ut2_youtube_autoplay, cscart_banners.abt__ut2_youtube_hide_controls, cscart_banners.abt__ut2_background_type, cscart_banners.abt__ut2_background_mp4_video, cscart_banner_descriptions.abt__ut2_button_text, cscart_banner_descriptions.abt__ut2_title, cscart_banner_descriptions.abt__ut2_url, cscart_banner_descriptions.abt__ut2_description, cscart_banner_descriptions.abt__ut2_youtube_id, cscart_banners.abt__ut2_tablet_use, cscart_banners.abt__ut2_tablet_content_valign, cscart_banners.abt__ut2_tablet_content_valign_use_own, cscart_banners.abt__ut2_tablet_content_align, cscart_banners.abt__ut2_tablet_content_align_use_own, cscart_banners.abt__ut2_tablet_padding, cscart_banners.abt__ut2_tablet_padding_use_own, cscart_banners.abt__ut2_tablet_content_full_width, cscart_banners.abt__ut2_tablet_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_tablet_title, cscart_banner_descriptions.abt__ut2_tablet_title_use_own, cscart_banners.abt__ut2_tablet_title_font_size, cscart_banners.abt__ut2_tablet_title_font_size_use_own, cscart_banners.abt__ut2_tablet_title_shadow, cscart_banners.abt__ut2_tablet_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_tablet_description, cscart_banner_descriptions.abt__ut2_tablet_description_use_own, cscart_banners.abt__ut2_tablet_description_font_size, cscart_banners.abt__ut2_tablet_description_font_size_use_own, cscart_banners.abt__ut2_tablet_main_image_use_own, cscart_banners.abt__ut2_tablet_background_type, cscart_banners.abt__ut2_tablet_background_type_use_own, cscart_banners.abt__ut2_tablet_background_mp4_video, cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, cscart_banners.abt__ut2_tablet_background_image_use_own, cscart_banners.abt__ut2_tablet_background_image_size, cscart_banners.abt__ut2_tablet_background_image_size_use_own, cscart_banners.abt__ut2_tablet_button_use, cscart_banners.abt__ut2_tablet_button_use_use_own, cscart_banner_descriptions.abt__ut2_tablet_button_text, cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, cscart_banners.abt__ut2_tablet_content_bg, cscart_banners.abt__ut2_tablet_content_bg_use_own, cscart_banners.abt__ut2_tablet_content_bg_position, cscart_banners.abt__ut2_tablet_content_bg_position_use_own, cscart_banners.abt__ut2_tablet_content_bg_opacity, cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, cscart_banners.abt__ut2_tablet_content_bg_color, cscart_banners.abt__ut2_tablet_content_bg_color_use_own, cscart_banners.abt__ut2_tablet_content_bg_color_use, cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, cscart_banners.abt__ut2_tablet_button_text_color, cscart_banners.abt__ut2_tablet_button_text_color_use_own, cscart_banners.abt__ut2_tablet_button_text_color_use, cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, cscart_banners.abt__ut2_tablet_button_color, cscart_banners.abt__ut2_tablet_button_color_use_own, cscart_banners.abt__ut2_tablet_button_color_use, cscart_banners.abt__ut2_tablet_button_color_use_use_own, cscart_banners.abt__ut2_tablet_content_valign, cscart_banners.abt__ut2_tablet_content_valign_use_own, cscart_banners.abt__ut2_tablet_content_align, cscart_banners.abt__ut2_tablet_content_align_use_own, cscart_banners.abt__ut2_tablet_padding, cscart_banners.abt__ut2_tablet_padding_use_own, cscart_banners.abt__ut2_tablet_content_full_width, cscart_banners.abt__ut2_tablet_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_tablet_title, cscart_banner_descriptions.abt__ut2_tablet_title_use_own, cscart_banners.abt__ut2_tablet_title_font_size, cscart_banners.abt__ut2_tablet_title_font_size_use_own, cscart_banners.abt__ut2_tablet_title_shadow, cscart_banners.abt__ut2_tablet_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_tablet_description, cscart_banner_descriptions.abt__ut2_tablet_description_use_own, cscart_banners.abt__ut2_tablet_description_font_size, cscart_banners.abt__ut2_tablet_description_font_size_use_own, cscart_banners.abt__ut2_tablet_main_image_use_own, cscart_banners.abt__ut2_tablet_background_type, cscart_banners.abt__ut2_tablet_background_type_use_own, cscart_banners.abt__ut2_tablet_background_mp4_video, cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, cscart_banners.abt__ut2_tablet_background_image_use_own, cscart_banners.abt__ut2_tablet_background_image_size, cscart_banners.abt__ut2_tablet_background_image_size_use_own, cscart_banners.abt__ut2_tablet_button_use, cscart_banners.abt__ut2_tablet_button_use_use_own, cscart_banner_descriptions.abt__ut2_tablet_button_text, cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, cscart_banners.abt__ut2_tablet_content_bg, cscart_banners.abt__ut2_tablet_content_bg_use_own, cscart_banners.abt__ut2_tablet_content_bg_position, cscart_banners.abt__ut2_tablet_content_bg_position_use_own, cscart_banners.abt__ut2_tablet_content_bg_opacity, cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, cscart_banners.abt__ut2_tablet_content_bg_color, cscart_banners.abt__ut2_tablet_content_bg_color_use_own, cscart_banners.abt__ut2_tablet_content_bg_color_use, cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, cscart_banners.abt__ut2_tablet_button_text_color, cscart_banners.abt__ut2_tablet_button_text_color_use_own, cscart_banners.abt__ut2_tablet_button_text_color_use, cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, cscart_banners.abt__ut2_tablet_button_color, cscart_banners.abt__ut2_tablet_button_color_use_own, cscart_banners.abt__ut2_tablet_button_color_use, cscart_banners.abt__ut2_tablet_button_color_use_use_own, cscart_banners.abt__ut2_mobile_use, cscart_banners.abt__ut2_mobile_content_valign, cscart_banners.abt__ut2_mobile_content_valign_use_own, cscart_banners.abt__ut2_mobile_content_align, cscart_banners.abt__ut2_mobile_content_align_use_own, cscart_banners.abt__ut2_mobile_padding, cscart_banners.abt__ut2_mobile_padding_use_own, cscart_banners.abt__ut2_mobile_content_full_width, cscart_banners.abt__ut2_mobile_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_mobile_title, cscart_banner_descriptions.abt__ut2_mobile_title_use_own, cscart_banners.abt__ut2_mobile_title_font_size, cscart_banners.abt__ut2_mobile_title_font_size_use_own, cscart_banners.abt__ut2_mobile_title_shadow, cscart_banners.abt__ut2_mobile_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_mobile_description, cscart_banner_descriptions.abt__ut2_mobile_description_use_own, cscart_banners.abt__ut2_mobile_description_font_size, cscart_banners.abt__ut2_mobile_description_font_size_use_own, cscart_banners.abt__ut2_mobile_main_image_use_own, cscart_banners.abt__ut2_mobile_background_type, cscart_banners.abt__ut2_mobile_background_type_use_own, cscart_banners.abt__ut2_mobile_background_mp4_video, cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, cscart_banners.abt__ut2_mobile_background_image_use_own, cscart_banners.abt__ut2_mobile_background_image_size, cscart_banners.abt__ut2_mobile_background_image_size_use_own, cscart_banners.abt__ut2_mobile_button_use, cscart_banners.abt__ut2_mobile_button_use_use_own, cscart_banner_descriptions.abt__ut2_mobile_button_text, cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, cscart_banners.abt__ut2_mobile_content_bg, cscart_banners.abt__ut2_mobile_content_bg_use_own, cscart_banners.abt__ut2_mobile_content_bg_position, cscart_banners.abt__ut2_mobile_content_bg_position_use_own, cscart_banners.abt__ut2_mobile_content_bg_opacity, cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, cscart_banners.abt__ut2_mobile_content_bg_color, cscart_banners.abt__ut2_mobile_content_bg_color_use_own, cscart_banners.abt__ut2_mobile_content_bg_color_use, cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, cscart_banners.abt__ut2_mobile_button_text_color, cscart_banners.abt__ut2_mobile_button_text_color_use_own, cscart_banners.abt__ut2_mobile_button_text_color_use, cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, cscart_banners.abt__ut2_mobile_button_color, cscart_banners.abt__ut2_mobile_button_color_use_own, cscart_banners.abt__ut2_mobile_button_color_use, cscart_banners.abt__ut2_mobile_button_color_use_use_own, cscart_banners.abt__ut2_mobile_content_valign, cscart_banners.abt__ut2_mobile_content_valign_use_own, cscart_banners.abt__ut2_mobile_content_align, cscart_banners.abt__ut2_mobile_content_align_use_own, cscart_banners.abt__ut2_mobile_padding, cscart_banners.abt__ut2_mobile_padding_use_own, cscart_banners.abt__ut2_mobile_content_full_width, cscart_banners.abt__ut2_mobile_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_mobile_title, cscart_banner_descriptions.abt__ut2_mobile_title_use_own, cscart_banners.abt__ut2_mobile_title_font_size, cscart_banners.abt__ut2_mobile_title_font_size_use_own, cscart_banners.abt__ut2_mobile_title_shadow, cscart_banners.abt__ut2_mobile_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_mobile_description, cscart_banner_descriptions.abt__ut2_mobile_description_use_own, cscart_banners.abt__ut2_mobile_description_font_size, cscart_banners.abt__ut2_mobile_description_font_size_use_own, cscart_banners.abt__ut2_mobile_main_image_use_own, cscart_banners.abt__ut2_mobile_background_type, cscart_banners.abt__ut2_mobile_background_type_use_own, cscart_banners.abt__ut2_mobile_background_mp4_video, cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, cscart_banners.abt__ut2_mobile_background_image_use_own, cscart_banners.abt__ut2_mobile_background_image_size, cscart_banners.abt__ut2_mobile_background_image_size_use_own, cscart_banners.abt__ut2_mobile_button_use, cscart_banners.abt__ut2_mobile_button_use_use_own, cscart_banner_descriptions.abt__ut2_mobile_button_text, cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, cscart_banners.abt__ut2_mobile_content_bg, cscart_banners.abt__ut2_mobile_content_bg_use_own, cscart_banners.abt__ut2_mobile_content_bg_position, cscart_banners.abt__ut2_mobile_content_bg_position_use_own, cscart_banners.abt__ut2_mobile_content_bg_opacity, cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, cscart_banners.abt__ut2_mobile_content_bg_color, cscart_banners.abt__ut2_mobile_content_bg_color_use_own, cscart_banners.abt__ut2_mobile_content_bg_color_use, cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, cscart_banners.abt__ut2_mobile_button_text_color, cscart_banners.abt__ut2_mobile_button_text_color_use_own, cscart_banners.abt__ut2_mobile_button_text_color_use, cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, cscart_banners.abt__ut2_mobile_button_color, cscart_banners.abt__ut2_mobile_button_color_use_own, cscart_banners.abt__ut2_mobile_button_color_use, cscart_banners.abt__ut2_mobile_button_color_use_use_own FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru' LEFT JOIN cscart_abt__ut2_banner_images ON cscart_abt__ut2_banner_images.banner_id = cscart_banners.banner_id AND cscart_abt__ut2_banner_images.lang_code = 'ru' WHERE cscart_banners.banner_id = 72 AND cscart_banners.status IN ('A', 'H') 
    
  1. SELECT cscart_banners.banner_id, cscart_banners.status, cscart_banner_descriptions.banner, cscart_banners.type, cscart_banners.target, cscart_banners.category_id, cscart_banners.localization, cscart_banners.timestamp, cscart_banner_descriptions.description, cscart_banners.button_name, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.page, cscart_banners.tabs, cscart_banners.mini, cscart_banners.place, cscart_abt__ut2_banner_images.abt__ut2_banner_image_id, cscart_banners.abt__ut2_usergroup_ids, cscart_banners.abt__ut2_use_avail_period, cscart_banners.abt__ut2_avail_from, cscart_banners.abt__ut2_avail_till, cscart_banners.abt__ut2_button_use, cscart_banners.abt__ut2_button_text_color, cscart_banners.abt__ut2_button_text_color_use, cscart_banners.abt__ut2_button_color, cscart_banners.abt__ut2_button_color_use, cscart_banners.abt__ut2_title_color, cscart_banners.abt__ut2_title_color_use, cscart_banners.abt__ut2_title_font_size, cscart_banners.abt__ut2_title_font_weight, cscart_banners.abt__ut2_title_tag, cscart_banners.abt__ut2_background_image_size, cscart_banners.abt__ut2_title_shadow, cscart_banners.abt__ut2_description_font_size, cscart_banners.abt__ut2_description_color, cscart_banners.abt__ut2_description_color_use, cscart_banners.abt__ut2_description_bg_color, cscart_banners.abt__ut2_description_bg_color_use, cscart_banners.abt__ut2_object, cscart_banners.abt__ut2_background_color, cscart_banners.abt__ut2_background_color_use, cscart_banners.abt__ut2_class, cscart_banners.abt__ut2_color_scheme, cscart_banners.abt__ut2_content_valign, cscart_banners.abt__ut2_content_align, cscart_banners.abt__ut2_content_full_width, cscart_banners.abt__ut2_content_bg, cscart_banners.abt__ut2_content_bg_position, cscart_banners.abt__ut2_content_bg_opacity, cscart_banners.abt__ut2_content_bg_color, cscart_banners.abt__ut2_content_bg_color_use, cscart_banners.abt__ut2_padding, cscart_banners.abt__ut2_how_to_open, cscart_banners.abt__ut2_data_type, cscart_banners.abt__ut2_youtube_use, cscart_banners.abt__ut2_youtube_autoplay, cscart_banners.abt__ut2_youtube_hide_controls, cscart_banners.abt__ut2_background_type, cscart_banners.abt__ut2_background_mp4_video, cscart_banner_descriptions.abt__ut2_button_text, cscart_banner_descriptions.abt__ut2_title, cscart_banner_descriptions.abt__ut2_url, cscart_banner_descriptions.abt__ut2_description, cscart_banner_descriptions.abt__ut2_youtube_id, cscart_banners.abt__ut2_tablet_use, cscart_banners.abt__ut2_tablet_content_valign, cscart_banners.abt__ut2_tablet_content_valign_use_own, cscart_banners.abt__ut2_tablet_content_align, cscart_banners.abt__ut2_tablet_content_align_use_own, cscart_banners.abt__ut2_tablet_padding, cscart_banners.abt__ut2_tablet_padding_use_own, cscart_banners.abt__ut2_tablet_content_full_width, cscart_banners.abt__ut2_tablet_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_tablet_title, cscart_banner_descriptions.abt__ut2_tablet_title_use_own, cscart_banners.abt__ut2_tablet_title_font_size, cscart_banners.abt__ut2_tablet_title_font_size_use_own, cscart_banners.abt__ut2_tablet_title_shadow, cscart_banners.abt__ut2_tablet_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_tablet_description, cscart_banner_descriptions.abt__ut2_tablet_description_use_own, cscart_banners.abt__ut2_tablet_description_font_size, cscart_banners.abt__ut2_tablet_description_font_size_use_own, cscart_banners.abt__ut2_tablet_main_image_use_own, cscart_banners.abt__ut2_tablet_background_type, cscart_banners.abt__ut2_tablet_background_type_use_own, cscart_banners.abt__ut2_tablet_background_mp4_video, cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, cscart_banners.abt__ut2_tablet_background_image_use_own, cscart_banners.abt__ut2_tablet_background_image_size, cscart_banners.abt__ut2_tablet_background_image_size_use_own, cscart_banners.abt__ut2_tablet_button_use, cscart_banners.abt__ut2_tablet_button_use_use_own, cscart_banner_descriptions.abt__ut2_tablet_button_text, cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, cscart_banners.abt__ut2_tablet_content_bg, cscart_banners.abt__ut2_tablet_content_bg_use_own, cscart_banners.abt__ut2_tablet_content_bg_position, cscart_banners.abt__ut2_tablet_content_bg_position_use_own, cscart_banners.abt__ut2_tablet_content_bg_opacity, cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, cscart_banners.abt__ut2_tablet_content_bg_color, cscart_banners.abt__ut2_tablet_content_bg_color_use_own, cscart_banners.abt__ut2_tablet_content_bg_color_use, cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, cscart_banners.abt__ut2_tablet_button_text_color, cscart_banners.abt__ut2_tablet_button_text_color_use_own, cscart_banners.abt__ut2_tablet_button_text_color_use, cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, cscart_banners.abt__ut2_tablet_button_color, cscart_banners.abt__ut2_tablet_button_color_use_own, cscart_banners.abt__ut2_tablet_button_color_use, cscart_banners.abt__ut2_tablet_button_color_use_use_own, cscart_banners.abt__ut2_tablet_content_valign, cscart_banners.abt__ut2_tablet_content_valign_use_own, cscart_banners.abt__ut2_tablet_content_align, cscart_banners.abt__ut2_tablet_content_align_use_own, cscart_banners.abt__ut2_tablet_padding, cscart_banners.abt__ut2_tablet_padding_use_own, cscart_banners.abt__ut2_tablet_content_full_width, cscart_banners.abt__ut2_tablet_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_tablet_title, cscart_banner_descriptions.abt__ut2_tablet_title_use_own, cscart_banners.abt__ut2_tablet_title_font_size, cscart_banners.abt__ut2_tablet_title_font_size_use_own, cscart_banners.abt__ut2_tablet_title_shadow, cscart_banners.abt__ut2_tablet_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_tablet_description, cscart_banner_descriptions.abt__ut2_tablet_description_use_own, cscart_banners.abt__ut2_tablet_description_font_size, cscart_banners.abt__ut2_tablet_description_font_size_use_own, cscart_banners.abt__ut2_tablet_main_image_use_own, cscart_banners.abt__ut2_tablet_background_type, cscart_banners.abt__ut2_tablet_background_type_use_own, cscart_banners.abt__ut2_tablet_background_mp4_video, cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, cscart_banners.abt__ut2_tablet_background_image_use_own, cscart_banners.abt__ut2_tablet_background_image_size, cscart_banners.abt__ut2_tablet_background_image_size_use_own, cscart_banners.abt__ut2_tablet_button_use, cscart_banners.abt__ut2_tablet_button_use_use_own, cscart_banner_descriptions.abt__ut2_tablet_button_text, cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, cscart_banners.abt__ut2_tablet_content_bg, cscart_banners.abt__ut2_tablet_content_bg_use_own, cscart_banners.abt__ut2_tablet_content_bg_position, cscart_banners.abt__ut2_tablet_content_bg_position_use_own, cscart_banners.abt__ut2_tablet_content_bg_opacity, cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, cscart_banners.abt__ut2_tablet_content_bg_color, cscart_banners.abt__ut2_tablet_content_bg_color_use_own, cscart_banners.abt__ut2_tablet_content_bg_color_use, cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, cscart_banners.abt__ut2_tablet_button_text_color, cscart_banners.abt__ut2_tablet_button_text_color_use_own, cscart_banners.abt__ut2_tablet_button_text_color_use, cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, cscart_banners.abt__ut2_tablet_button_color, cscart_banners.abt__ut2_tablet_button_color_use_own, cscart_banners.abt__ut2_tablet_button_color_use, cscart_banners.abt__ut2_tablet_button_color_use_use_own, cscart_banners.abt__ut2_mobile_use, cscart_banners.abt__ut2_mobile_content_valign, cscart_banners.abt__ut2_mobile_content_valign_use_own, cscart_banners.abt__ut2_mobile_content_align, cscart_banners.abt__ut2_mobile_content_align_use_own, cscart_banners.abt__ut2_mobile_padding, cscart_banners.abt__ut2_mobile_padding_use_own, cscart_banners.abt__ut2_mobile_content_full_width, cscart_banners.abt__ut2_mobile_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_mobile_title, cscart_banner_descriptions.abt__ut2_mobile_title_use_own, cscart_banners.abt__ut2_mobile_title_font_size, cscart_banners.abt__ut2_mobile_title_font_size_use_own, cscart_banners.abt__ut2_mobile_title_shadow, cscart_banners.abt__ut2_mobile_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_mobile_description, cscart_banner_descriptions.abt__ut2_mobile_description_use_own, cscart_banners.abt__ut2_mobile_description_font_size, cscart_banners.abt__ut2_mobile_description_font_size_use_own, cscart_banners.abt__ut2_mobile_main_image_use_own, cscart_banners.abt__ut2_mobile_background_type, cscart_banners.abt__ut2_mobile_background_type_use_own, cscart_banners.abt__ut2_mobile_background_mp4_video, cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, cscart_banners.abt__ut2_mobile_background_image_use_own, cscart_banners.abt__ut2_mobile_background_image_size, cscart_banners.abt__ut2_mobile_background_image_size_use_own, cscart_banners.abt__ut2_mobile_button_use, cscart_banners.abt__ut2_mobile_button_use_use_own, cscart_banner_descriptions.abt__ut2_mobile_button_text, cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, cscart_banners.abt__ut2_mobile_content_bg, cscart_banners.abt__ut2_mobile_content_bg_use_own, cscart_banners.abt__ut2_mobile_content_bg_position, cscart_banners.abt__ut2_mobile_content_bg_position_use_own, cscart_banners.abt__ut2_mobile_content_bg_opacity, cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, cscart_banners.abt__ut2_mobile_content_bg_color, cscart_banners.abt__ut2_mobile_content_bg_color_use_own, cscart_banners.abt__ut2_mobile_content_bg_color_use, cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, cscart_banners.abt__ut2_mobile_button_text_color, cscart_banners.abt__ut2_mobile_button_text_color_use_own, cscart_banners.abt__ut2_mobile_button_text_color_use, cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, cscart_banners.abt__ut2_mobile_button_color, cscart_banners.abt__ut2_mobile_button_color_use_own, cscart_banners.abt__ut2_mobile_button_color_use, cscart_banners.abt__ut2_mobile_button_color_use_use_own, cscart_banners.abt__ut2_mobile_content_valign, cscart_banners.abt__ut2_mobile_content_valign_use_own, cscart_banners.abt__ut2_mobile_content_align, cscart_banners.abt__ut2_mobile_content_align_use_own, cscart_banners.abt__ut2_mobile_padding, cscart_banners.abt__ut2_mobile_padding_use_own, cscart_banners.abt__ut2_mobile_content_full_width, cscart_banners.abt__ut2_mobile_content_full_width_use_own, cscart_banner_descriptions.abt__ut2_mobile_title, cscart_banner_descriptions.abt__ut2_mobile_title_use_own, cscart_banners.abt__ut2_mobile_title_font_size, cscart_banners.abt__ut2_mobile_title_font_size_use_own, cscart_banners.abt__ut2_mobile_title_shadow, cscart_banners.abt__ut2_mobile_title_shadow_use_own, cscart_banner_descriptions.abt__ut2_mobile_description, cscart_banner_descriptions.abt__ut2_mobile_description_use_own, cscart_banners.abt__ut2_mobile_description_font_size, cscart_banners.abt__ut2_mobile_description_font_size_use_own, cscart_banners.abt__ut2_mobile_main_image_use_own, cscart_banners.abt__ut2_mobile_background_type, cscart_banners.abt__ut2_mobile_background_type_use_own, cscart_banners.abt__ut2_mobile_background_mp4_video, cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, cscart_banners.abt__ut2_mobile_background_image_use_own, cscart_banners.abt__ut2_mobile_background_image_size, cscart_banners.abt__ut2_mobile_background_image_size_use_own, cscart_banners.abt__ut2_mobile_button_use, cscart_banners.abt__ut2_mobile_button_use_use_own, cscart_banner_descriptions.abt__ut2_mobile_button_text, cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, cscart_banners.abt__ut2_mobile_content_bg, cscart_banners.abt__ut2_mobile_content_bg_use_own, cscart_banners.abt__ut2_mobile_content_bg_position, cscart_banners.abt__ut2_mobile_content_bg_position_use_own, cscart_banners.abt__ut2_mobile_content_bg_opacity, cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, cscart_banners.abt__ut2_mobile_content_bg_color, cscart_banners.abt__ut2_mobile_content_bg_color_use_own, cscart_banners.abt__ut2_mobile_content_bg_color_use, cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, cscart_banners.abt__ut2_mobile_button_text_color, cscart_banners.abt__ut2_mobile_button_text_color_use_own, cscart_banners.abt__ut2_mobile_button_text_color_use, cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, cscart_banners.abt__ut2_mobile_button_color, cscart_banners.abt__ut2_mobile_button_color_use_own, cscart_banners.abt__ut2_mobile_button_color_use, cscart_banners.abt__ut2_mobile_button_color_use_use_own FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ru' LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ru' LEFT JOIN cscart_abt__ut2_banner_images ON cscart_abt__ut2_banner_images.banner_id = cscart_banners.banner_id AND cscart_abt__ut2_banner_images.lang_code = 'ru' WHERE cscart_banners.banner_id = 70 AND cscart_banners.status IN ('A', 'H') 
    
  1. SELECT * FROM faqs WHERE object_id = 506 AND object_type = 'category' ORDER BY `id` ASC
    
  1.                 SELECT * FROM `advantage`
                             WHERE `object_id` = 506
                               AND `object_type` = 'category'
                               AND `status` = 'A'
                             ORDER BY `pos` ASC
    
  1. SELECT PF.data_type, F.filter_id,F.feature_id,PVD.variant,PVD.variant_id FROM `cscart_product_filters` AS `F` JOIN `cscart_product_feature_variants` AS `PV` ON PV.feature_id = F.feature_id JOIN `cscart_product_feature_variant_descriptions` AS `PVD` ON PVD.variant_id = PV.variant_id JOIN `cscart_product_features` AS `PF` ON PF.feature_id = PV.feature_id JOIN `cscart_product_features_values` AS `PFV` ON PFV.variant_id = PV.variant_id AND PFV.feature_id = PV.feature_id JOIN `cscart_products` AS `P` ON P.product_id = PFV.product_id WHERE 1 AND FIND_IN_SET(506, F.categories_path) AND F.display = 'Y' AND P.status = 'A' AND EXISTS (SELECT `PFV2`.* FROM `cscart_product_features_values` AS `PFV2` LEFT JOIN `cscart_products` AS `P2` ON P2.product_id = PFV2.product_id LEFT JOIN `cscart_products_categories` AS `PC` ON PC.product_id = PFV2.product_id AND PC.link_type = 'M' WHERE 1 AND PFV2.feature_id = F.feature_id AND PFV2.variant_id = PV.variant_id AND P2.status = 'A' AND PC.category_id = 506 ) GROUP BY PV.variant_id ORDER BY PVD.variant ASC 
    
  1. SELECT F.filter_id,F.feature_id,FD.range_input,FD.filter as description FROM `cscart_product_filters` AS `F` JOIN `cscart_product_filter_descriptions` AS `FD` ON FD.filter_id = F.filter_id AND FD.lang_code = 'ru' WHERE 1 AND F.filter_id IN ('') 
    
  1. SELECT DISTINCT csc.* FROM cscart_product_stocks AS cps 
                 JOIN  cscart_company_stocks AS ccs 
                     ON cps.stock_id = ccs.stock_id 
                 JOIN cscart_custom_city AS csc
                     ON ccs.fias_id = csc.fias_id
                     ORDER BY csc.`position` ASC, csc.`city` ASC
    
  1. SELECT brand_id FROM cscart_category_brands WHERE `category_id` = 506
    
  1. SELECT `B`.`brand_id`,`B`.`brand`,`B`.`link`,`B`.`status`,`CB`.`id` AS brand_category_id,F.path AS logo FROM `cscart_brands` AS `B` LEFT JOIN `cscart_category_brands` AS `CB` ON `B`.`brand_id` = `CB`.`brand_id` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` WHERE 1 AND `CB`.`category_id` = 506 AND `FI`.`object_type` = "brand" GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY `CB`.`pos` ASC,`B`.`brand` ASC 
    
  1. SELECT a.category_id
                             FROM cscart_categories as a
                             LEFT JOIN cscart_categories as b
                             ON b.category_id IN (506)
                             WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
    
  1. SELECT `B`.`brand_id`,`B`.`brand`,`B`.`link`,`B`.`status`,`BR`.`current_position`,COALESCE(F.path, "") AS image,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` AND `FI`.`object_type` = "brand" LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `brands_rating` AS `BR` ON `BR`.`brand_id` = `B`.`brand_id` AND `BR`.`category_id` = 506 AND `BR`.`current_position` > 0 LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `PC`.`category_id` IN (506, 564, 565, 572, 574, 576, 605, 607, 610, 612, 613, 627, 663, 692, 708, 742, 810, 815, 816, 898, 817, 899, 900, 901, 909, 921, 566, 567, 593, 752, 811, 812, 813, 910, 911, 912, 913, 914, 915, 916, 568, 569, 575, 655, 656, 657, 658, 659, 661, 702, 704, 756, 902, 705, 809, 577, 312, 381, 382, 383, 384, 385, 697, 746, 590, 633, 691, 741, 743, 747, 904, 903, 905, 591, 596, 606, 694, 707, 748, 749, 750, 808, 814, 592, 611, 660, 690, 700, 701, 597, 598, 599, 600, 601, 602, 603, 608, 609, 631, 687, 688, 689, 738, 906, 908, 920, 922, 628, 629, 907, 917, 662, 698, 699, 732, 733, 745, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 753, 754, 755) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY BR.current_position DESC,`B`.`brand` ASC 
    
  1. SELECT a.category_id
                             FROM cscart_categories as a
                             LEFT JOIN cscart_categories as b
                             ON b.category_id IN (506)
                             WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
    
  1. SELECT SQL_CALC_FOUND_ROWS `B`.`brand_id`,`B`.`brand`,`B`.`link`,`B`.`status`,F.path AS logo,`PC`.`category_id` FROM `cscart_brands` AS `B` LEFT JOIN `files__images` AS `FI` ON `B`.`brand_id` = `FI`.`object_id` LEFT JOIN `files` AS `F` ON `F`.`id` = `FI`.`file_id` LEFT JOIN `cscart_products` AS `P` ON `B`.`brand_id` = `P`.`brand_id` LEFT JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' WHERE 1 AND `B`.`brand_id` != 3059 AND `FI`.`object_type` = "brand" AND `PC`.`category_id` IN (506, 564, 565, 572, 574, 576, 605, 607, 610, 612, 613, 627, 663, 692, 708, 742, 810, 815, 816, 898, 817, 899, 900, 901, 909, 921, 566, 567, 593, 752, 811, 812, 813, 910, 911, 912, 913, 914, 915, 916, 568, 569, 575, 655, 656, 657, 658, 659, 661, 702, 704, 756, 902, 705, 809, 577, 312, 381, 382, 383, 384, 385, 697, 746, 590, 633, 691, 741, 743, 747, 904, 903, 905, 591, 596, 606, 694, 707, 748, 749, 750, 808, 814, 592, 611, 660, 690, 700, 701, 597, 598, 599, 600, 601, 602, 603, 608, 609, 631, 687, 688, 689, 738, 906, 908, 920, 922, 628, 629, 907, 917, 662, 698, 699, 732, 733, 745, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 753, 754, 755) AND `P`.`status` = 'A' GROUP BY `B`.`brand_id`, `B`.`brand` ORDER BY `B`.`brand` ASC LIMIT 0,20
    
  1. SELECT FOUND_ROWS()
    
  1. SELECT a.category_id
                             FROM cscart_categories as a
                             LEFT JOIN cscart_categories as b
                             ON b.category_id IN (506)
                             WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
    
  1. SELECT SQL_CALC_FOUND_ROWS DISTINCT `C`.`services`,`C`.`category_id`,`CD`.`category`,`COM`.`company`,`CUR`.`price` AS `currency_rate`,IF(`HP`.`created_at`, MAX(`HP`.`created_at`), `P`.`timestamp`) AS `price_update_time`,`P`.`amount`,`P`.`city_id`,`P`.`brand_id`,`P`.`company_id`,`P`.`city_place`,`P`.`conditions`,`P`.`guarantee_id`,`P`.`type_of_sale`,`P`.`product_code`,`P`.`product_id`,`P`.`status`,`P`.`year`,`P`.`uniqueSale`,`P`.`is_confiscated`,`P`.`updated_timestamp`,`PC`.`category_id` AS `main_category`,`PD`.`full_description`,`PD`.`short_description`,`PD`.`leasingCount`,`PD`.`leasingPrice`,`PD`.`product`,`PP`.`currency`,`PP`.`discount_percent`,`PP`.`price`,`PP`.`recycling_price_rub`,((PP.price * COALESCE(CUR.price, 1)) * (1 - PP.discount_percent / 100) + PP.recycling_price_rub) AS total_price,CASE WHEN `GC`.`compare_id` IS NOT NULL THEN "Y" ELSE "N" END AS `compare`,CASE WHEN `GW`.`wishlist_id` IS NOT NULL THEN "Y" ELSE "N" END AS `wish`,IF(`CITY`.`city_id` IS NULL, 0, 1) as city_priority,CITY.address,(select count(*) from `cscart_product_stocks` where product_id = P.product_id) as stockCount,`B`.`brand`,`B`.`has_subsidy`,COALESCE(FILE.path, "") AS image,COALESCE(IMG.alt, "") AS image_alt FROM `cscart_products` AS `P` LEFT JOIN `cscart_guest__wishlist` AS `GW` ON `P`.`product_id` = `GW`.`product_id` AND `GW`.`guest_id` = 0 LEFT JOIN `cscart_guest__compare` AS `GC` ON `P`.`product_id` = `GC`.`product_id` AND `GC`.`guest_id` = 0 LEFT JOIN `cscart_product_stocks` AS `PST` ON `P`.`product_id` = `PST`.`product_id` LEFT JOIN `cscart_company_stocks` AS `CST` ON `PST`.`stock_id` = `CST`.`stock_id` LEFT JOIN `cscart_custom_city` AS `CITY` ON `CITY`.`fias_id` = `CST`.`fias_id` LEFT JOIN `cscart_product_prices_history` AS `HP` ON `HP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_products__images` AS `IMG` ON `P`.`product_id` = `IMG`.`product_id` LEFT JOIN `files` AS `FILE` ON `FILE`.`id` = `IMG`.`watermark_small_file_id` LEFT JOIN `cscart_companies` AS `COM` ON `COM`.`company_id` = `P`.`company_id` INNER JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' INNER JOIN `cscart_categories` AS `C` ON `C`.`category_id` = `PC`.`category_id` INNER JOIN `cscart_category_descriptions` AS `CD` ON `C`.`category_id` = `CD`.`category_id` LEFT JOIN `cscart_product_prices` AS `PP` ON `PP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_product_descriptions` AS `PD` ON `PD`.`product_id` = `P`.`product_id` AND `PD`.`lang_code` = 'ru' LEFT JOIN `cscart_currencies` AS `CUR` ON `PP`.`currency` = `CUR`.`currency_code` LEFT JOIN `cscart_brands` AS `B` ON `P`.`brand_id` = `B`.`brand_id` WHERE 1 AND `C`.`category_id` IN (506, 564, 565, 572, 574, 576, 605, 607, 610, 612, 613, 627, 663, 692, 708, 742, 810, 815, 816, 898, 817, 899, 900, 901, 909, 921, 566, 567, 593, 752, 811, 812, 813, 910, 911, 912, 913, 914, 915, 916, 568, 569, 575, 655, 656, 657, 658, 659, 661, 702, 704, 756, 902, 705, 809, 577, 312, 381, 382, 383, 384, 385, 697, 746, 590, 633, 691, 741, 743, 747, 904, 903, 905, 591, 596, 606, 694, 707, 748, 749, 750, 808, 814, 592, 611, 660, 690, 700, 701, 597, 598, 599, 600, 601, 602, 603, 608, 609, 631, 687, 688, 689, 738, 906, 908, 920, 922, 628, 629, 907, 917, 662, 698, 699, 732, 733, 745, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 753, 754, 755) AND `P`.`status` = 'A' AND `B`.`brand_id` = 3059 AND `COM`.`status` = 'A' GROUP BY `P`.`product_id` ORDER BY city_priority DESC,sort_index DESC LIMIT 0, 11
    
  1. SELECT FOUND_ROWS()
    
  1. SELECT `F`.`path`, `PI`.`product_id`, `PI`.`alt` 
            FROM `cscart_products__images` AS `PI`
            LEFT JOIN `files` AS `F` 
                ON `PI`.`watermark_small_file_id` = `F`.`id`
            WHERE `PI`.`product_id` IN ('28547', '30781', '14667', '28535', '30783', '30779', '28541', '28533', '28543', '28545', '30785')
    
  1.                 SELECT 
                        c.category_id, 
                        cd.category, 
                        (
                            SELECT COUNT(DISTINCT p.product_id) 
                            FROM cscart_products p
                            INNER JOIN cscart_products_categories pc ON pc.product_id = p.product_id
                            INNER JOIN cscart_categories sub_c ON pc.category_id = sub_c.category_id
                            WHERE (sub_c.id_path LIKE '506/%' OR sub_c.category_id = c.category_id)
                            AND p.status = 'A'
                        ) AS product_count
                    FROM cscart_categories c
                    INNER JOIN cscart_category_descriptions cd ON c.category_id = cd.category_id
                    WHERE c.parent_id = 0 
                        AND c.services = 2 
                        AND c.status = 'A'
                        AND c.category_id != 506
                    AND product_count > 0
                    ORDER BY product_count DESC 
                    LIMIT 16;
                
    
  1. SELECT `category` FROM `cscart_category_descriptions` WHERE `category_id` = 506
    
  1. SELECT `brand` FROM `cscart_brands` WHERE `brand_id` = 3059
    
  1. SELECT city_id, city FROM `cscart_custom_city` WHERE `city_id` = '0'
    
  1. SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
    
Спецтехника SHACMAN | купить новая или б/у в наличии | Каталог FINLEO | цены 2025.
  1. SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
    
  1. SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
    
  1. SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 554 AND c.company_id = 0
    
  1. SELECT layout_id FROM cscart_bm_locations WHERE location_id = 554
    
  1. SELECT c.*, IF (c.location_id != 554, 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 = 3 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
    
  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 (117, 118, 2215, 120) 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 'categories' 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 = 506 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (2562, 2561, 2575, 2563, 2564, 2565, 2567, 2568, 2569, 2570, 2571, 816, 2572, 2573)  AND cscart_bm_blocks_descriptions.lang_code='ru'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
    

Спецтехника SHACMAN

Показать все категории
LONKING
КАМАЗ
HOWO
ABACUS
BEIBEN
BORUS
CASE
CELIKEL
CUKUROVA
DONGFENG
DOOSAN
FAW
FOTON
HANGCHA
HELI
HENGWANG
HOWO
HYUNDAI
HZM
IVECO
JAC
JINGONG
LIUGONG
  1. SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_companies AS companies  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'ru' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 678  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 678 
    
  1. SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 678 AND object_type = 'S' 
    
  1. SELECT cscart_statuses.*, cscart_status_descriptions.* FROM cscart_statuses  LEFT JOIN cscart_status_descriptions ON cscart_status_descriptions.status_id = cscart_statuses.status_id AND cscart_status_descriptions.lang_code = 'ru' WHERE 1 = 1  AND cscart_statuses.type = 'O'  ORDER BY cscart_statuses.position asc
    
  1. SELECT status_id, status FROM cscart_statuses WHERE type = 'O'
    
  1. SELECT status_id, param, value FROM cscart_status_data WHERE status_id IN (23, 6, 2, 24, 4, 7, 3, 1, 19)
    
  1. SELECT cscart_statuses.status FROM cscart_statuses INNER JOIN cscart_status_data ON cscart_status_data.status_id = cscart_statuses.status_id WHERE type = 'O' AND (param, value) IN (('payment_received', 'Y'))
    
  1. SELECT rating FROM cscart_absolute_rating WHERE `object_id` = 678 AND `object_type` = 'company'
    
  1. SELECT MAX(rating) FROM cscart_absolute_rating WHERE `object_type` = 'company'
    
  1. SELECT updated_timestamp FROM cscart_absolute_rating WHERE `object_type` = 'company' AND `object_id` = 678
    
  1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 678 AND `object_type` = 'company'
    
Самосвал SHACMAN 6*6 X3000 SX32586V385 с односкатной ошиновкой
Самосвал SHACMAN 6*6 X3000 SX32586V385 с односкатной ошиновкой
Самосвал SHACMAN 6*6 X3000 SX32586V385 с односкатной ошиновкой
Самосвал SHACMAN 6*6 X3000 SX32586V385 с односкатной ошиновкой
Самосвал SHACMAN 6*6 X3000 SX32586V385 с односкатной ошиновкой
В наличии
Можно купить онлайн
12 000 000
ООО "А+Б ИМПОРТ"
Продавец
от 426 347 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WEICHAI WP12.430E50 Двигатель
311 Мощность двигателя, кВт
430 Мощность двигателя, л.с.
17000 Масса техники, кг
30000 Грузоподъемность, кг
6x6 Колесная формула
14.00 R20 Шины
20 Объем кузова, м3
90 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
  1. SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_companies AS companies  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'ru' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 684  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 684 
    
  1. SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 684 AND object_type = 'S' 
    
  1. SELECT rating FROM cscart_absolute_rating WHERE `object_id` = 684 AND `object_type` = 'company'
    
  1. SELECT updated_timestamp FROM cscart_absolute_rating WHERE `object_type` = 'company' AND `object_id` = 684
    
  1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 684 AND `object_type` = 'company'
    
Самосвал SHACMAN 8х4, 550л.с., П-образный кузов
В наличии
Можно купить онлайн
10 800 000
ООО "АВТОКОМПАС"
Продавец
от 383 706 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WP13.550E501 Двигатель
550 Мощность двигателя, л.с.
8x4 Колесная формула
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
  1. SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_companies AS companies  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'ru' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 574  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 574 
    
  1. SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 574 AND object_type = 'S' 
    
  1. SELECT rating FROM cscart_absolute_rating WHERE `object_id` = 574 AND `object_type` = 'company'
    
  1. SELECT updated_timestamp FROM cscart_absolute_rating WHERE `object_type` = 'company' AND `object_id` = 574
    
  1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 574 AND `object_type` = 'company'
    
Самосвал Shacman (Shaanxi) L3000, 2023
В наличии
Можно купить онлайн
7 000 000
ООО "КСК"
Продавец
от 174 948 ₽ / мес
еще 12 предложений
SHACMAN Бренд
270 Мощность двигателя, л.с.
6x4 Колесная формула
Евро-5 Экологический стандарт
Купить
Позвонить
Самосвал SHACMAN 6*4 X3000 SX32586V384 U-кузов
Самосвал SHACMAN 6*4 X3000 SX32586V384 U-кузов
Самосвал SHACMAN 6*4 X3000 SX32586V384 U-кузов
Самосвал SHACMAN 6*4 X3000 SX32586V384 U-кузов
Самосвал SHACMAN 6*4 X3000 SX32586V384 U-кузов
Самосвал SHACMAN 6*4 X3000 SX32586V384 U-кузов
В наличии
Можно купить онлайн
9 500 000
ООО "А+Б ИМПОРТ"
Продавец
от 334 371 ₽ / мес
еще 17 предложений
SHACMAN Бренд
WEICHAI WP12.430E50 Двигатель
311 Мощность двигателя, кВт
430 Мощность двигателя, л.с.
16000 Масса техники, кг
30000 Грузоподъемность, кг
6x4 Колесная формула
315/80 R22.5 Шины
25 Объем кузова, м3
90 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
Самосвал SHACMAN 6х6, 430л.с., двускатный
Самосвал SHACMAN 6х6, 430л.с., двускатный
В наличии
Можно купить онлайн
10 600 000
ООО "АВТОКОМПАС"
Продавец
от 376 823 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WEICHAI WP12.430E50 Двигатель
430 Мощность двигателя, л.с.
6x6 Колесная формула
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
Самосвал SHACMAN 8х4, 430л.с., U-образный кузов
В наличии
Можно купить онлайн
10 600 000
ООО "АВТОКОМПАС"
Продавец
от 376 600 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WEICHAI WP12.430E50 Двигатель
430 Мощность двигателя, л.с.
8x4 Колесная формула
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
Самосвал SHACMAN 6х4 X3000 SX32586W384C
Самосвал SHACMAN 6х4 X3000 SX32586W384C
Самосвал SHACMAN 6х4 X3000 SX32586W384C
Самосвал SHACMAN 6х4 X3000 SX32586W384C
Самосвал SHACMAN 6х4 X3000 SX32586W384C
Самосвал SHACMAN 6х4 X3000 SX32586W384C
В наличии
Можно купить онлайн
9 500 000
ООО "А+Б ИМПОРТ"
Продавец
от 237 443 ₽ / мес
еще 12 предложений
SHACMAN Бренд
Cummins ISM11E5440 Двигатель
324 Мощность двигателя, кВт
440 Мощность двигателя, л.с.
16000 Масса техники, кг
30000 Грузоподъемность, кг
6х4 Колесная формула
315/80 R22.5 Шины
25 Объем кузова, м3
90 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
Самосвал SHACMAN 6х4 X3000 SX32586V384
В наличии
Можно купить онлайн
9 500 000
ООО "А+Б ИМПОРТ"
Продавец
от 334 371 ₽ / мес
еще 17 предложений
SHACMAN Бренд
WEICHAI WP12.430 Е50 Двигатель
311 Мощность двигателя, кВт
430 Мощность двигателя, л.с.
16000 Масса техники, кг
30000 Грузоподъемность, кг
6x4 Колесная формула
315/80 R 22.5 Шины
25 Объем кузова, м3
90 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
Самосвал SHACMAN 8х4 X3000 SX33186V366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX33186V366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX33186V366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX33186V366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX33186V366 с ретадером
В наличии
Можно купить онлайн
10 800 000
ООО "А+Б ИМПОРТ"
Продавец
от 383 706 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WEICHAI WP12.430E50 Двигатель
311 Мощность двигателя, кВт
430 Мощность двигателя, л.с.
19500 Масса техники, кг
40000 Грузоподъемность, кг
8x4 Колесная формула
315/80 R22.5 Шины
35 Объем кузова, м3
90 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
Самосвал SHACMAN 8х4 X3000 SX331863366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX331863366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX331863366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX331863366 с ретадером
Самосвал SHACMAN 8х4 X3000 SX331863366 с ретадером
В наличии
Можно купить онлайн
11 300 000
ООО "А+Б ИМПОРТ"
Продавец
от 401 474 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WEICHAI WP12.430E50 Двигатель
400 Мощность двигателя, кВт
550 Мощность двигателя, л.с.
19500 Масса техники, кг
40000 Грузоподъемность, кг
8x4 Колесная формула
315/80 R22.5 Шины
35 Объем кузова, м3
90 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить
  1. SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_companies AS companies  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'ru' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ru' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 649  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 649 
    
  1. SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 649 AND object_type = 'S' 
    
  1. SELECT rating FROM cscart_absolute_rating WHERE `object_id` = 649 AND `object_type` = 'company'
    
  1. SELECT updated_timestamp FROM cscart_absolute_rating WHERE `object_type` = 'company' AND `object_id` = 649
    
  1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 649 AND `object_type` = 'company'
    
SHACMAN самосвал 6х4
SHACMAN самосвал 6х4
SHACMAN самосвал 6х4
SHACMAN самосвал 6х4
SHACMAN самосвал 6х4
В наличии
Можно купить онлайн
9 400 000
ООО "ФОРС ТРАК"
Продавец
от 330 657 ₽ / мес
еще 13 предложений
SHACMAN Бренд
WEICHAI WP12.430 Е50 Двигатель
430 Мощность двигателя, кВт
7100 Масса техники, кг
24200 Грузоподъемность, кг
6x4 Колесная формула
295/80R22.5 Шины
24 Объем кузова, м3
85 Максимальная скорость, км/ч
Евро-5 Экологический стандарт
Дизельный Тип двигателя
Китай Страна производитель
Купить
Позвонить

Не нашли
интересующую модель?

Заполните форму и с Вами свяжется менеджер в течение 10 мин.

Нажимая кнопку “Отправить”, Вы даете согласие на обработку персональных данных
Показать еще 2 товара
  1. REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings')