...
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT onu.port_id, onu.onu_mac_serial, onu.onu_dhcp_port, p.nas_id, INET_NTOA(n.ip) asAS ip FROM equipment_pon_onu onu LEFT JOIN equipment_pon_ports p ON (p.id=onu.port_id) LEFT JOIN nas n ON (p.nas_id=n.id) WHERE onu.onu_mac_serial IN (selectSELECT onu_mac_serial fromFROM equipment_pon_onu groupGROUP byBY onu_mac_serial havingHAVING countCOUNT(*)> 1) ORDER BY onu.onu_mac_serial |
...