Page History

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