Alıntı
select * from iplist as ip inner join bloklar as blok on ip.blok_id = blok.id where ip.blok_id = '86.152.50.42'
http://sqlfiddle.com/#!2/0afa6b/5