SELECT * FROM config_global WHERE config LIKE '%getolt:enable%';
SELECT id, title, config FROM process_type
WHERE config LIKE '%getolt:processShowTab%';
SELECT pp.permset_id, pt.title, pp.action
FROM user_permset_permission pp
JOIN user_permset_title pt ON pp.permset_id = pt.id
WHERE pp.action LIKE '%getolt%';
SELECT id, ip, vendor, billing, status, last_update FROM getolt_olt ORDER BY ip;
SELECT o.ip, COUNT(onu.id) AS onu_count
FROM getolt_olt o LEFT JOIN getolt_olt_onu onu ON o.id = onu.olt_id
GROUP BY o.id ORDER BY o.ip;