...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT
i.uid,
i.cpe_mac,
onu.onu_dhcp_port AS onu_port,
p.nas_id AS onu_nas,
onu.onu_mac_serial AS onu_cpe
FROM equipment_pon_onu onu
LEFT JOIN equipment_pon_ports p ON (p.id=onu.port_id)
LEFT JOIN internet_main i ON (onu.onu_dhcp_port = i.port AND p.nas_id = i.nas_id)
WHERE onu.onu_mac_serial<>i.cpe_mac |
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT id as login, uid FROM users WHERE uid NOT IN (SELECT uid FROM internet_main) AND uid NOT IN (SELECT uid FROM iptv_main); |
...