From cec8c5738686bd16d17ae37455b85069e6babe29 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 27 二月 2023 15:33:06 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 795803a..0dbe4b0 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -328,6 +328,27 @@
select * from lf.sys_meta order by id desc;
select * from lf.sys_meta where metaid>0 or ismeta>0;
+-- 鎸夌収澶х被缁熻
+select name,
+ (select count(b.id) from lf.sys_meta b where dircode similar to '(' || (select string_agg(code, '|') from lf.sys_dir c where c.name = a.name) || ')%') "count",
+ (select coalesce(sum(b.sizes), 0) from lf.sys_meta b where dircode similar to '(' || (select string_agg(code, '|') from lf.sys_dir c where c.name = a.name) || ')%') "sizes"
+from lf.sys_dir a
+where code like '01%' and name in ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
+group by name
+order by name;
+
+select name, code
+from lf.sys_dir a
+where pid = 0 order by code;
+
+select * from lf.sys_download where guid='a0eab5c60810301c6bc86a295be1435a'
+select * from lf.sys_download order by id desc
+
+
+
+
+
+
--
Gitblit v1.9.3