LEFT JOIN agent_api_keys aak ON a.id = aak.agent_id::uuid LEFT JOIN companies c ON a.company_id = c.id::uuid LEFT JOIN agent_api_keys aak ON a.id = aak.agent_id::uuid ...
Abstract: With the continuous development of unmanned aerial vehicle (UAV) technology, its applications in various fields are becoming increasingly widespread. Intelligent task scheduling and resource ...
COUNT(CASE WHEN aak.id IS NOT NULL THEN 1 END) as agents_with_keys, COUNT(CASE WHEN aak.id IS NULL THEN 1 END) as agents_without_keys, LEFT JOIN agent_api_keys aak ON a.id = aak.agent_id::uuid LEFT ...