Subquery issue with null records in left table

join shbcf.ru