Max222

SELECT count(distinct d1.`inforreg`) as result FROM `investdata_name` as d1 inner join `investdata_name` as d2 WHERE d2.`webnr` = '11555511'  and d1.`webnr` = '11555511' and d1.`lopnr` = '11' and d1.`connectnum` = '1222' 
and d2.`connectnum` = '2255' and d2.`inforreg` = d1.`inforreg` and d1.status_inv='1' and d2.status_inv='1'