select COUNT(id)
from house_info_config hic
where
(hic.ip_start #{ipend} AND hic.ip_end =]]> #{ipend})
OR
(hic.ip_start =]]> #{ipstart} AND hic.ip_end #{ipend})
OR
(hic.ip_start #{ipstart} AND hic.ip_end =]]> #{ipstart})