Someone

SELECT cdp_entries.switch_name,cdp_entries.device_name,cdp_entries.platform_name,INET_NTOA(cdp_entries.route) AS cdp,cdp_entries.switch_int AS switchport,INET_NTOA(cirrus.dstip) AS solarwinds FROM cdp_entries LEFT JOIN cirrus ON cdp_entries.route = cirrus.dstip WHERE cirrus.dstip IS NULL AND INET_NTOA(cdp_entries.route) LIKE '%172.16%' AND cdp_entries.platform_name NOT REGEXP 'Cisco (720[46]VXR|3845)' AND cdp_entries.platform_name NOT REGEXP '.*(Win|Phone).*';