---

SELECT 1 AS lvl, 'bruteforce_result' AS tbl, count(*) FROM bruteforce_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'docker_images', count(*) FROM docker_images WHERE id_scan = 175113
UNION ALL SELECT 1, 'file_system_scan_result', count(*) FROM file_system_scan_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'install_result', count(*) FROM install_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'inventory_results', count(*) FROM inventory_results WHERE id_scan = 175113
UNION ALL SELECT 1, 'nmap_script_info', count(*) FROM nmap_script_info WHERE id_scan = 175113
UNION ALL SELECT 1, 'oval_scan_result', count(*) FROM oval_scan_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'ping_result', count(*) FROM ping_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'port_scan_result', count(*) FROM port_scan_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'registry_scan_result', count(*) FROM registry_scan_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'scada_result', count(*) FROM scada_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'scan_control', count(*) FROM scan_control WHERE id_scan = 175113
UNION ALL SELECT 1, 'scanned_nic', count(*) FROM scanned_nic WHERE id_scan = 175113
UNION ALL SELECT 1, 'xccdf_scan_result', count(*) FROM xccdf_scan_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'host_discovery_result', count(*) FROM host_discovery_result WHERE id_scan = 175113
UNION ALL SELECT 1, 'yara_scan_result', count(*) FROM yara_scan_result WHERE id_scan = 175113
UNION ALL SELECT 2, 'collected_items', count(*) FROM collected_items
  WHERE id_oval_scan_result IN (SELECT id FROM oval_scan_result WHERE id_scan = 175113)
UNION ALL SELECT 2, 'oval_scan_result_cpe', count(*) FROM oval_scan_result_cpe
  WHERE id_oval_scan_result IN (SELECT id FROM oval_scan_result WHERE id_scan = 175113)
UNION ALL SELECT 2, 'nmap_script_elements', count(*) FROM nmap_script_elements
  WHERE id_nmap_script_info IN (SELECT id FROM nmap_script_info WHERE id_scan = 175113)
UNION ALL SELECT 2, 'pentest_cve_result', count(*) FROM pentest_cve_result
  WHERE id_port IN (SELECT id FROM port_scan_result WHERE id_scan = 175113)
UNION ALL SELECT 2, 'report', count(*) FROM report
  WHERE id_scan_control IN (SELECT id FROM scan_control WHERE id_scan = 175113)
UNION ALL SELECT 2, 'xccdf_scan_result_details', count(*) FROM xccdf_scan_result_details
  WHERE id_xccdf_scan_result IN (SELECT id FROM xccdf_scan_result WHERE id_scan = 175113)
ORDER BY lvl, tbl;