select * from t1, t4
left join t2 on t2.id = t1.t2_id
left join t3 on t3.id = t1.t3_id
where t1.name = 12 and t2.parent = 3  and t4.id = 100

SELECT *
FROM
  ( SELECT *
   FROM t1,
        t4
   WHERE t4.id = 100
     AND t1.id = t4.id ) t1
LEFT JOIN
  (SELECT *
   FROM t2
   WHERE t2.parent = 3) t2 ON t2.id = t1.t2_id
LEFT JOIN
  (SELECT *
   FROM t3
   WHERE t3.parent = 3) t3 ON t3.id = t1.t3_id

select *
  from t1
 CROSS join t4
  left join t2 on t2.id = t1.t2_id
  left join t3 on t3.id = t1.t3_id
 where t1.name = 12 and t2.parent = 3  and t4.id = 100