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

  1. SELECT `brand_id` FROM `cscart_brands` WHERE `link` = '?brand_id=1125%2Fpage-2%2F%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=1125%2Fpage-2%2F%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 <= 1750942995)
AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1750942995)
)
), '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` != 1125 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` = 1125 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 ('11227', '11225', '11223', '11220', '11512', '11215', '11218', '11216', '11221', '11213', '11514')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  1. SELECT rating FROM cscart_manual_rating WHERE `object_id` = 522 AND `object_type` = 'company'
Мини-погрузчик LOCUST L1004 Speed +
В наличии
Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11227 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru' 

    1. SELECT name, path FROM cscart_seo_names WHERE `object_id` = 742 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'
    https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-volvo-abg7820b/" class="card__product-title">Мини-погрузчик LOCUST L1004 Speed +
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 904J-E28T Stage V Двигатель
    1.2 Мощность двигателя, кВт
    75 Мощность двигателя, л.с.
    1.2 Объем ковша, м3
    2670 Высота выгрузки, мм
    3396 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L1203 Perkins Telspeed
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11225 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l1203-perkins-telspeed/" class="card__product-title">Мини-погрузчик Locust L1203 Perkins Telspeed
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 904J-E28T Stage V Двигатель
    75 Мощность двигателя, л.с.
    4500 Масса техники, кг
    4070 Высота выгрузки, мм
    4500 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L1203 Perkins
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11223 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l1203-perkins/" class="card__product-title">Мини-погрузчик Locust L1203 Perkins
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 904J-E28T Stage V Двигатель
    75 Мощность двигателя, л.с.
    4330 Масса техники, кг
    0.66 Объем ковша, м3
    3320 Высота выгрузки, мм
    Купить
    Позвонить
    Мини-погрузчик Locust L904 Speed+
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11220 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l904-speed/" class="card__product-title">Мини-погрузчик Locust L904 Speed+
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 404J-E22T Stage V Двигатель
    60 Мощность двигателя, л.с.
    3320 Высота выгрузки, мм
    3396 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L1203
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11512 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l1203/" class="card__product-title">Мини-погрузчик Locust L1203
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Kubota V3800-DI-E2B-EU-Z4 Stage III Двигатель
    1.2 Мощность двигателя, кВт
    83 Мощность двигателя, л.с.
    1.2 Объем ковша, м3
    4330 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L1203 Telspeed
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11215 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l1203-telspeed/" class="card__product-title">Мини-погрузчик Locust L1203 Telspeed
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Kubota V3800-DI-E2B-EU-Z4 Stage III Двигатель
    83 Мощность двигателя, л.с.
    3730 x 2120 x 2180 Габариты техники д.ш.в., мм
    4070 Высота выгрузки, мм
    4500 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L904
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11218 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l904/" class="card__product-title">Мини-погрузчик Locust L904
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 404J-E22T Stage V Двигатель
    60 Мощность двигателя, л.с.
    3320 Высота выгрузки, мм
    3396 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L753 Power
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11216 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l753-power/" class="card__product-title">Мини-погрузчик Locust L753 Power
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 404J-E22T Stage V Двигатель
    60 Мощность двигателя, л.с.
    Купить
    Позвонить
    Мини-погрузчик Locust L1004
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11221 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l1004/" class="card__product-title">Мини-погрузчик Locust L1004
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Perkins 904J-E28T Stage V Двигатель
    75 Мощность двигателя, л.с.
    1.2 Объем ковша, м3
    3320 Высота выгрузки, мм
    3396 Эксплуатационная масса, кг
    Купить
    Позвонить
    Мини-погрузчик Locust L903
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11213 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l903/" class="card__product-title">Мини-погрузчик Locust L903
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    61 Мощность двигателя, л.с.
    3265 Высота выгрузки, мм
    Купить
    Позвонить
    Мини-погрузчик Locust L753 Power Speed +
    В наличии
    Можно купить онлайн
  • SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11514 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru'
    • https://dev2.mpdev.finleo.ru/spectehnika/stroitelnaya-tehnika/mini-pogruzchiki/mini-pogruzchik-locust-l753-power-speed/" class="card__product-title">Мини-погрузчик Locust L753 Power Speed +
    г Казань
    Цена по запросу
    ООО "МАДРОГ КАЗАНЬ"
    Продавец
    Предложения
    От 25 лизинговых компаний
    LOCUST Бренд
    Купить
    Позвонить

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

    Заполните форму и с Вами свяжется менеджер в течение 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')