Thank you for the advices and I have also got few answers at
http://stackoverflow.com/questions/40304011/where-in-condition-and-multiple-columns-in-subquery
RegardsAlex