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

  1. SELECT `brand_id` FROM `cscart_brands` WHERE `link` = '?brand_id=3147%2Fpage-2%2F%2F%2F%2F%2F%2Fpage-2%2F%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=3147%2Fpage-2%2F%2F%2F%2F%2F%2Fpage-2%2F%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 <= 1750945904)
AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1750945904)
)
), '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` != 3147 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` = 3147 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 ('28836', '28843', '28850', '32915', '28629', '28608', '28610', '28612', '30259', '30253', '30257')

  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` = 3147

  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)
Спецтехника DAYUN | купить новая или б/у в наличии | Каталог 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
Главная
Продажа спецтехники
...

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

Строительная техника

Складская техника

Грузовой транспорт

Сельскохозяйственная техника

Дорожная техника

Коммунальная техника

Прицепы и полуприцепы

Вездеходная техника

Техника для лесного хозяйства

Коммерческий транспорт

Подъемная техника

Шахтная техника

Показать все категории
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 = 592  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 592 

  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 = 592 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` = 592 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` = 592

  1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 592 AND `object_type` = 'company'
Изотермический фургон DAYUN Х120
Изотермический фургон DAYUN Х120
Изотермический фургон DAYUN Х120
Изотермический фургон DAYUN Х120
Изотермический фургон DAYUN Х120
В наличии
Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28836 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru' 

    1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 733 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'
    https://dev2.mpdev.finleo.ru/spectehnika/kommercheskiy-transport/furgony/izotermicheskiy-furgon-dayun-h120/" class="card__product-title">Изотермический фургон DAYUN Х120
    г Челябинск
    3 642 400
    ООО "САТ"
    Продавец
    от 174 948 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    WEICHAI, WP4.1NQ190E5 Двигатель
    190 Мощность двигателя, л.с.
    5800 Грузоподъемность, кг
    4х2 Колесная формула
    Дизельный Тип двигателя
    Китай/Россия Страна производитель
    4088см3 Объем двигателя
    Задний Привод
    Купить
    Позвонить
    Рефрижератор DAYUN Х60
    Рефрижератор DAYUN Х60
    Рефрижератор DAYUN Х60
    Рефрижератор DAYUN Х60
    Рефрижератор DAYUN Х60
    Рефрижератор DAYUN Х60
    Рефрижератор DAYUN Х60
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28843 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/kommercheskiy-transport/furgony/refrizherator-dayun-h60/" class="card__product-title">Рефрижератор DAYUN Х60
    г Челябинск и еще в 1
    5 000 000
    ООО "САТ"
    Продавец
    от 124 953 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    Weichai WP3NQ150E50 Двигатель
    150 Мощность двигателя, л.с.
    2000 Грузоподъемность, кг
    4x2 Колесная формула
    Дизельный Тип двигателя
    Китай Страна производитель
    2970см2 Объем двигателя
    Задний Привод
    Купить
    Позвонить
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    Рефрижератор DAYUN Х120
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28850 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/kommercheskiy-transport/furgony/refrizherator-dayun-h120/" class="card__product-title">Рефрижератор DAYUN Х120
    г Челябинск и еще в 2
    6 900 000
    ООО "САТ"
    Продавец
    от 172 448 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    WEICHAI, WP4.1NQ190E5 Двигатель
    190 Мощность двигателя, л.с.
    5800 Грузоподъемность, кг
    4x2 Колесная формула
    Дизельный Тип двигателя
    Китай Страна производитель
    4088см3 Объем двигателя
    Задний Привод
    Купить
    Позвонить
    Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 32915 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru' 

    1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 659 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'
    https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili-s-kmu/bortovoy-gruzovoy-avtomobil-kmu-dayun-x120-s-kmu/" class="card__product-title">Бортовой грузовой автомобиль КМУ DAYUN X120 с КМУ
    г Челябинск и еще в 2
    8 250 000
    ООО "САТ"
    Продавец
    от 206 196 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    WEICHAI, WP4.1NQ190E5 Двигатель
    190 Мощность двигателя, л.с.
    4200 Грузоподъемность, кг
    11000 Вылет стрелы, мм
    4x2 Колесная формула
    8.25R20*7 Шины
    Евро-5 Экологический стандарт
    Китай Страна производитель
    11 Максимальная высота подъема,м
    Купить
    Позвонить 
    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 = 687  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 687 

    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 = 687 AND object_type = 'S' 

    1. SELECT rating FROM cscart_absolute_rating WHERE `object_id` = 687 AND `object_type` = 'company'

    1. SELECT updated_timestamp FROM cscart_absolute_rating WHERE `object_type` = 'company' AND `object_id` = 687

    1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 687 AND `object_type` = 'company'
    DAYUN CGC1120D 4X2 рефрижератор
    DAYUN CGC1120D 4X2 рефрижератор
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28629 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/kommercheskiy-transport/furgony/dayun-cgc1120d-4x2-refrizherator-vnutr.-razmery-nadstroyki-6500h2450h2100-mm-hou-terrafrigo-18s-20s-gidrobort-1-5-tn/" class="card__product-title">DAYUN CGC1120D 4X2 рефрижератор
    Респ Татарстан, г Набережные Челны
    7 800 000
    ФИЛИАЛ ООО "АГРОПРОМСЕРВИС"
    Продавец
    от 292 135 ₽ / мес
    еще 16 предложений
    DAYUN Бренд
    Weichai Двигатель
    185 Мощность двигателя, л.с.
    3800 Грузоподъемность, кг
    4x2 Колесная формула
    Дизельный Тип двигателя
    Китай Страна производитель
    4000 Объем двигателя
    Задний Привод
    Купить
    Позвонить
    DAYUN CGC1120D 4X2 с НКТС 5014
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28608 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili-s-kmu/dayun-cgc1120d-4x2-s-nkts-5014/" class="card__product-title">DAYUN CGC1120D 4X2 с НКТС 5014
    Респ Татарстан, г Набережные Челны
    8 850 000
    ФИЛИАЛ ООО "АГРОПРОМСЕРВИС"
    Продавец
    от 221 194 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    Weichai Двигатель
    185 Мощность двигателя, л.с.
    99500 x 2550 x 3500 Габариты техники д.ш.в., мм
    10700 Вылет стрелы, мм
    4x2 Колесная формула
    Евро-5 Экологический стандарт
    Китай Страна производитель
    Купить
    Позвонить
    DAYUN CGC1120D 4X2 с FASSI 115 (гидравлика)
    DAYUN CGC1120D 4X2 с FASSI 115 (гидравлика)
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28610 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili-s-kmu/dayun-cgc1120d-4x2-s-fassi-115-gidravlika/" class="card__product-title">DAYUN CGC1120D 4X2 с FASSI 115 (гидравлика)
    Респ Татарстан, г Набережные Челны
    8 800 000
    ФИЛИАЛ ООО "АГРОПРОМСЕРВИС"
    Продавец
    от 219 944 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    Weichai WP4 Двигатель
    185 Мощность двигателя, л.с.
    9900 x 2550 x 3300 Габариты техники д.ш.в., мм
    7900 Вылет стрелы, мм
    4x2 Колесная формула
    Евро-5 Экологический стандарт
    Китай Страна производитель
    Купить
    Позвонить
    DAYUN CGC1120D 4X2 с XCMG 125-4
    DAYUN CGC1120D 4X2 с XCMG 125-4
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 28612 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili-s-kmu/dayun-cgc1120d-4x2-s-xcmg-125-4/" class="card__product-title">DAYUN CGC1120D 4X2 с XCMG 125-4
    Респ Татарстан, г Набережные Челны
    8 150 000
    ФИЛИАЛ ООО "АГРОПРОМСЕРВИС"
    Продавец
    от 203 696 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    Weichai Двигатель
    185 Мощность двигателя, л.с.
    9900 x 2550 x 3400 Габариты техники д.ш.в., мм
    11000 Вылет стрелы, мм
    4x2 Колесная формула
    Евро-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 = 610  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ru'  WHERE companies.company_id = 610 

    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 = 610 AND object_type = 'S' 

    1. SELECT rating FROM cscart_absolute_rating WHERE `object_id` = 610 AND `object_type` = 'company'

    1. SELECT updated_timestamp FROM cscart_absolute_rating WHERE `object_type` = 'company' AND `object_id` = 610

    1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 610 AND `object_type` = 'company'
    Грузовик бортовой
    Грузовик бортовой
    Грузовик бортовой
    Грузовик бортовой
    Грузовик бортовой
    Грузовик бортовой
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30259 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru' 

    1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 658 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'
    https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili/gruzovik-bortovoy/" class="card__product-title">Грузовик бортовой
    г Томск
    6 860 000
    ООО "ТК "ТОМАВТО"
    Продавец
    от 241 309 ₽ / мес
    еще 13 предложений
    DAYUN Бренд
    Купить
    Позвонить
    Рефрижератор
    Рефрижератор
    Рефрижератор
    Рефрижератор
    Рефрижератор
    Рефрижератор
    Рефрижератор
    Рефрижератор
    Рефрижератор
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30253 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili/refrizherator/" class="card__product-title">Рефрижератор
    г Томск
    7 200 000
    ООО "ТК "ТОМАВТО"
    Продавец
    от 179 948 ₽ / мес
    еще 12 предложений
    DAYUN Бренд
    Купить
    Позвонить
    Рефрижератор DAYUN Autoplead-X CGC1120d
    Рефрижератор DAYUN Autoplead-X CGC1120d
    Рефрижератор DAYUN Autoplead-X CGC1120d
    Рефрижератор DAYUN Autoplead-X CGC1120d
    Рефрижератор DAYUN Autoplead-X CGC1120d
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30257 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/gruzovoy-transport/bortovye-avtomobili/refrizherator-ru-3/" class="card__product-title">Рефрижератор DAYUN Autoplead-X CGC1120d
    г Томск
    7 800 000
    ООО "ТК "ТОМАВТО"
    Продавец
    от 274 375 ₽ / мес
    еще 13 предложений
    DAYUN Бренд
    Купить
    Позвонить

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

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

    Согласен на обработку персональных данных

    Нажимая кнопку “Отправить”, Вы даете согласие на обработку персональных данных
    Показать еще 3 товара
    Спецтехника по брендам
    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')