{"title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438 \u0441 \u0446\u0435\u043d\u0430\u043c\u0438(\u0434\u043b\u044f \u0433\u0443\u0433\u043b \u0434\u043e\u043a\u0441- \u043f\u0443\u0431\u043b\u0438\u0447\u043d\u044b\u0439 \u043f\u0440\u0430\u0439\u0441)","query_pattern":"SELECT DISTINCT\n{FIELDS}\n\nFROM\n good AS {TABLE(Z29vZHM=::0KLQvtCy0LDRgNGLINC4INGD0YHQu9GD0LPQuA==.Z29vZA==)}\nLEFT JOIN `good_sale_param` AS {TABLE(Z29vZHM=::0J\/QsNGA0LDQvNC10YLRgNGLINC\/0YDQvtC00LDQttC4.Z29vZF9zYWxlX3BhcmFt)} ON {TABLE(Z29vZHM=::0KLQvtCy0LDRgNGLINC4INGD0YHQu9GD0LPQuA==.Z29vZA==)}.`id` = {TABLE(Z29vZHM=::0J\/QsNGA0LDQvNC10YLRgNGLINC\/0YDQvtC00LDQttC4.Z29vZF9zYWxlX3BhcmFt)}.`good_id`\nLEFT JOIN (\n\n\t\t\tSELECT DISTINCT\n\t\t\t\tt.*,\n\t\t\t\tgt.`good_id`, gt.`quantity`,\n\t\t\t\tgt.`sale_param_id`\n\t\t\tFROM good_tag t\n\t\t\tJOIN good2tag gt ON gt.`tag_id` = t.`id`\n) AS {TABLE(Z29vZHM=::0JrQvtC80LHQuNC90LDRhtC40Lg=.Z29vZF90YWc=)} ON {TABLE(Z29vZHM=::0KLQvtCy0LDRgNGLINC4INGD0YHQu9GD0LPQuA==.Z29vZA==)}.`id` = {TABLE(Z29vZHM=::0JrQvtC80LHQuNC90LDRhtC40Lg=.Z29vZF90YWc=)}.`good_id` AND {TABLE(Z29vZHM=::0JrQvtC80LHQuNC90LDRhtC40Lg=.Z29vZF90YWc=)}.`sale_param_id` = {TABLE(Z29vZHM=::0J\/QsNGA0LDQvNC10YLRgNGLINC\/0YDQvtC00LDQttC4.Z29vZF9zYWxlX3BhcmFt)}.`id`\n{JOINS}\nJOIN good2tag AS t_98 ON {TABLE(Z29vZHM=::0J\/QsNGA0LDQvNC10YLRgNGLINC\/0YDQvtC00LDQttC4.Z29vZF9zYWxlX3BhcmFt)}.id = t_98.sale_param_id AND {TABLE(Z29vZHM=::0JrQvtC80LHQuNC90LDRhtC40Lg=.Z29vZF90YWc=)}.id = t_98.tag_id\nWHERE\n{WHERE}\nand `j_641`.`title` <> ' '\n\n{GROUP}\n{ORDER}","fields":[{"field_title":"ID","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":1,"visible":0,"title":"ID","formula":"","old_field_id":638},{"field_title":"\u0428\u0430\u0431\u043b\u043e\u043d","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":1,"title":"\u0428\u0430\u0431\u043b\u043e\u043d","formula":"if(f_642 = '\u0414\u0430','-\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f (\u0448\u0430\u0431\u043b\u043e\u043d\u043d\u0430\u044f)-','-\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f (\u043d\u0435\u0448\u0430\u0431\u043b\u043e\u043d\u043d\u0430\u044f)-')","old_field_id":642},{"field_title":"\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","grouping_fn_title":null,"is_grouping":1,"grouping_fn_id":0,"sort_order":0,"visible":1,"title":"\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","formula":"","old_field_id":639},{"field_title":"\u0422\u0438\u043f \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u0422\u0438\u043f \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","formula":"","old_field_id":641},{"field_title":"\u0422\u043e\u0432\u0430\u0440","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u0422\u043e\u0432\u0430\u0440","formula":"","old_field_id":643},{"field_title":"\u0415\u0434. \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f","table_title":"\u0422\u043e\u0432\u0430\u0440\u044b \u0438 \u0443\u0441\u043b\u0443\u0433\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u0415\u0434. \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f","formula":"","old_field_id":157},{"field_title":"\u041a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u041a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e","formula":"","old_field_id":644},{"field_title":"\u0420\u0430\u0441\u0447\u0435\u0442\u043d\u0430\u044f \u0446\u0435\u043d\u0430","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u0426\u0435\u043d\u0430 \u0440\u0430\u0441\u0447\u0435\u0442\u043d\u0430\u044f","formula":"","old_field_id":668},{"field_title":"\u0420\u0430\u0441\u0447\u0435\u0442\u043d\u0430\u044f \u0446\u0435\u043d\u0430","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u0446\u0435\u043d\u0430 \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","formula":"t_98.price","old_field_id":668},{"field_title":"\u0415\u0434. \u043f\u0440\u043e\u0434\u0430\u0436\u0438","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":1,"title":"\u0415\u0434. \u043f\u0440\u043e\u0434\u0430\u0436\u0438","formula":"' '","old_field_id":291},{"field_title":"\u0420\u0430\u0441\u0447\u0435\u0442\u043d\u0430\u044f \u0446\u0435\u043d\u0430","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","grouping_fn_title":"\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435","is_grouping":0,"grouping_fn_id":6,"sort_order":0,"visible":0,"title":"\u0426\u0435\u043d\u0430","formula":"ifnull(t_98.price, f_668)","old_field_id":668},{"field_title":"\u0426\u0435\u043d\u0430 \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","grouping_fn_title":"\u0421\u0443\u043c\u043c\u0430","is_grouping":0,"grouping_fn_id":1,"sort_order":0,"visible":1,"title":"\u0421\u0442\u043e\u0438\u043c\u043e\u0441\u0442\u044c","formula":"ifnull(t_98.price, f_668)*f_644","old_field_id":289},{"field_title":"\u041a\u043b\u0438\u043d\u0438\u043a\u0430","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","grouping_fn_title":null,"is_grouping":1,"grouping_fn_id":0,"sort_order":0,"visible":1,"title":"\u041a\u043b\u0438\u043d\u0438\u043a\u0430","formula":"","old_field_id":296}],"nesting":[],"filter":[{"pattern":"((1 and 2) and 3)","number":1,"field_title":"\u0410\u043a\u0442\u0438\u0432\u0435\u043d","table_title":"\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438","module_name":"goods","operator_name":"equal","condition":"","value":"1","is_dynamic":0},{"pattern":"((1 and 2) and 3)","number":2,"field_title":"\u041a\u043b\u0438\u043d\u0438\u043a\u0430","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","operator_name":"enters_in","condition":"and","value":"1,2","is_dynamic":1},{"pattern":"((1 and 2) and 3)","number":3,"field_title":"\u0421\u0442\u0430\u0442\u0443\u0441","table_title":"\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u043e\u0434\u0430\u0436\u0438","module_name":"goods","operator_name":"equal","condition":"and","value":"active","is_dynamic":0}],"program_version":"0.521.2"}