Sql

SELECT * FROM table1 g WHERE g.converted_ip NOT IN (SELECT ifnull(sl.ip_address,10) FROM tabl2 sl)