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%2F%2F%2Fpage-2%2F%2F%2Fpage-2%2F'

  1. SELECT `brand_id` FROM `cscart_brands` WHERE `link` = '?brand_id=3059%2F%2F%2Fpage-2%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%2F%2F%2Fpage-2%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 `P`.`product_id`,`PFD`.`internal_name` AS `name`,`PFVD`.`variant`,`PFVD`.`variant_id`,`PFD`.`feature_id` FROM `cscart_product_features_values` AS `PFV` JOIN `cscart_product_features` AS `PF` ON `PFV`.`feature_id` = `PF`.`feature_id` JOIN `cscart_products` AS `P` ON `P`.`product_id` = `PFV`.`product_id` JOIN `cscart_product_features_descriptions` AS `PFD` ON `PFV`.`feature_id` = `PFD`.`feature_id` JOIN `cscart_product_feature_variants` AS `PFVS` ON `PFVS`.`variant_id` = `PFV`.`variant_id` JOIN `cscart_product_feature_variant_descriptions` AS `PFVD` ON `PFVS`.`variant_id` = `PFVD`.`variant_id` WHERE 1 AND `PF`.`status` = 'A' AND `PFV`.`product_id` IN('28547', '30781', '14667', '28535', '30783', '30779', '28541', '28533', '28543', '28545', '30785') 

  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'
FINLEO
Финкабинет
Агенту Клиенту
Оформляйте финпродукты для клиентов. Выбирайте финансовые продукты - банковские гарантии, кредиты, страхование, лизинг, факторинг и др. Получайте предложения от 100+ проверенных партнёров в 70 направлениях, оформляйте заявки и получайте вознаграждение Оформляйте финпродукты для себя. Выбирайте финансовые продукты - банковские гарантии, кредиты, страхование, лизинг, факторинг и др. Получайте предложения от 100+ проверенных партнёров в 70 направлениях и оформляйте заявки по лучшим условиям от наших партнеров
79%
Процент одобрения всех заявок
79%
Процент одобрения всех заявок
FINLEO
Товарный кабинет
Продавцу Покупателю
Продавайте товары бизнесу. Бесплатно размещайте каталог своих товаров — от офисной мебели до сложного оборудования — и получайте дополнительные продажи без затрат на маркетинг (мы сами продвигаем Ваши товары) Покупайте товары для бизнеса. Приобретайте спецтехнику, оборудование, инструменты, мебель и другие товары для бизнеса напрямую от поставщиков без наценок или скрытых комиссий
100%
Бесплатное размещение
10954+
Товаров уже на маркетплейсе
  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 с односкатной ошиновкой
В наличии
Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28547 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru' 

    1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 575 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'
    https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-66-x3000-sx32586v385-s-odnoskatnoy-oshinovkoy/" class="card__product-title">Самосвал 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л.с., П-образный кузов
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30781 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-8h4-550l.s.-p-obraznyy-kuzov/" class="card__product-title">Самосвал 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
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 14667 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-shaanxi-l3000-2023/" class="card__product-title">Самосвал 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-кузов
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28535 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-64-x3000-sx32586v384-u-kuzov/" class="card__product-title">Самосвал 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л.с., двускатный
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30783 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-6h6-430l.s.-dvuskatnyy/" class="card__product-title">Самосвал SHACMAN 6х6, 430л.с., двускатный
    г Челябинск
    10 600 000
    ООО "АВТОКОМПАС"
    Продавец
    от 376 823 ₽ / мес
    еще 13 предложений
    SHACMAN Бренд
    WEICHAI WP12.430E50 Двигатель
    430 Мощность двигателя, л.с.
    6x6 Колесная формула
    Дизельный Тип двигателя
    Китай Страна производитель
    Купить
    Позвонить
    Самосвал SHACMAN 8х4, 430л.с., U-образный кузов
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30779 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-8h4-430l.s.-u-obraznyy-kuzov/" class="card__product-title">Самосвал 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
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28541 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-6h4-x3000-sx32586w384c/" class="card__product-title">Самосвал 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
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28533 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-6h4-x3000-sx32586v384/" class="card__product-title">Самосвал 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 с ретадером
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28543 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-8h4-x3000-sx33186v366-s-retaderom/" class="card__product-title">Самосвал 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 с ретадером
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28545 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/samosval-shacman-8h4-x3000-sx331863366-s-retaderom/" class="card__product-title">Самосвал 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
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30785 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/samosvaly/shacman-samosval-6h4-ru/" class="card__product-title">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 товара
    Спецтехника по брендам
    JAC
    NOBLELIFT
    SHACMAN / SHAANXI
    LONKING
    LIUGONG
    РЕСУРСАГРОСТРОЙ (РАС)
    XCMG
    КАМАЗ
    ГАЗ
    DONGFENG
    SANY
    LOVOL
    МАЗ
    FAW
    SITRAK
    БЕЛАРУС
    Спецтехника в регионах
    в Москве
    в Санкт-Петербурге
    в Волгограде
    в Благовещенске
    в Краснодаре
    в Челябинске
    в Казани
    в Курске
    в Красноярске
    в Хабаровске
    в Миассе
    в Забайкальске
    в Балашихе
    в Набережных Челнах
    в Чебоксарах
    в Битцах
    Спецтехника по характеристикам
    Штабелеры Грузоподъемность 1200 кг
    Вилочные погрузчики Грузоподъемность 1500 кг
    Вилочные погрузчики Грузоподъемность 2000 кг
    Экскаваторы-погрузчики Грузоподъемность 2500 кг
    Вилочные погрузчики Грузоподъемность 3000 кг
    Вилочные погрузчики Грузоподъемность 5000 кг
    Седельные тягачи Колесная формула 4x2
    Седельные тягачи Колесная формула 6x4
    Автокраны Колесная формула 6x6
    Самосвалы Колесная формула 8x4
    Тракторы колёсные Мощность двигателя 220 л.с.
    Гусеничные бульдозеры Мощность двигателя 430 л.с.
    Седельные тягачи Мощность двигателя 480 л.с.
    Экскаваторы-погрузчики Объем ковша 1 м³
    Экскаваторы-погрузчики Объем ковша 1.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'), ('product_features', 'query'), ('product_features_values', 'query'), ('product_feature_variants', 'query'), ('product_feature_variant_descriptions', 'query')