Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXPLAIN (ANALYZE)
- SELECT
- *
- FROM
- (
- SELECT
- t1.*
- FROM
- task31 t1
- LEFT JOIN task35 t5 ON t5.link5 = t1.link1
- LEFT JOIN task36 t6 ON t6.link6 = t1.link1
- LEFT JOIN task310 t10 ON t10.link10 = t1.link1
- ) AS t1
- LEFT JOIN (
- SELECT
- t2.*
- FROM
- task32 t2
- LEFT JOIN task33 t3 ON t3.link3 = t2.link2
- LEFT JOIN task34 t4 ON t4.link4 = t2.link2
- LEFT JOIN task37 t7 ON t7.link7 = t2.link2
- LEFT JOIN task38 t8 ON t8.link8 = t2.link2
- LEFT JOIN task39 t9 ON t9.link9 = t2.link2
- ) AS t2 ON t2.link2 = t1.link1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement