FINLEO
финкабинет
Оформление / выдача фин. услуг
FINLEO
Товарный кабинет
Покупка / продажа товаров
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 140 AND c.company_id = 0
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 140
SELECT c.*, IF (c.location_id != 140, 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
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, 559, 120) ORDER BY g.order, g.parent_id, g.grid_id ASC
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 'pages' 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 = 48 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (710, 2695, 2696, 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
SELECT `t`.`tag` FROM `cscart_tag_links` AS `tl` LEFT JOIN `cscart_tags` AS `t` ON `tl`.`tag_id` = `t`.`tag_id` WHERE `tl`.`object_type` = 'A' GROUP BY `t`.`tag_id`
SELECT object_id, thread_id, type, object_type FROM cscart_discussion WHERE 1 AND object_id = 48 AND object_type = 'A'
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 8445
SELECT AVG (dr.rating_value) FROM cscart_discussion_rating AS dr LEFT JOIN cscart_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN cscart_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 48 AND d.object_type = 'A' AND type IN ( 'B', 'R' ) AND dp.status = 'A' AND dr.rating_value > 0
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')
0