t1:

t1id  |  text
-------------
 1    | t1-1
 2    | t2-1

t2:

t2id  |  text
-------------
 1    | t2-1
 2    | t2-2
 3    | t4-3
 4    | t2-4

t3:

t3id  |  t1id  |  t2id  |  t4id
-------------------------------
 1    |  1     |  1     |  0
 2    |  1     |  1     |  1
 3    |  2     |  1     |  1
 4    |  2     |  2     |  1
 5    |  2     |  3     |  1
 6    |  2     |  4     |  1
 7    |  2     |  1     |  0
 8    |  2     |  2     |  0
 9    |  2     |  3     |  0
 10   |  2     |  4     |  0