From 783c5526e88717f9055cc58b58a0240f242d2e5a Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Sun, 13 Oct 2024 10:16:32 +0200 Subject: [PATCH] etc/dbq/data.php --- etc/dbq/data.php | 8 -------- 1 file changed, 8 deletions(-) diff --git a/etc/dbq/data.php b/etc/dbq/data.php index fb88d572..75101c65 100644 --- a/etc/dbq/data.php +++ b/etc/dbq/data.php @@ -17,14 +17,6 @@ $DBQ['data'] = [ FROM host_info hi GROUP BY host ORDER BY host "), - '_sql' => "SELECT host" - .",max(updated) as last_updated" - .",min(updated) as first_updated" - .",(SELECT count(val) FROM host_info path WHERE path.host=hi.host AND path.key LIKE '%.path') as repos" - .",max((SELECT DISTINCT val FROM host_info ex WHERE ex.host=hi.host AND ex.key LIKE '%.exit_code' LIMIT 1)) as exit" - ." FROM host_info hi" - ." GROUP BY host ORDER BY host" - , 'row_parse_pre' => function(&$row) { foreach ($row as $k=>$v) { if (strpos($k,'updated') !== false) { -- 2.47.3