[ID in (A B C)] => [D = rows from TABLE_D where KEY=ID]