How to execute this query in mysql?

Question

MySQL

I run the command through workbench , the request takes a long time to load, then the database crashes, what's the matter

use old;

use old;
SELECT * FROM (profil r
LEFT JOIN towns t ON t.id = r.town
LEFT JOIN profil_metro rm ON rm.id_resume = r.id

LEFT JOIN photo f ON f.id_resume = r.id
# LEFT JOIN region.work w ON w.`id_resume` = r.id
LEFT JOIN baseeduc be ON be.`id_resume` = r.id

LEFT JOIN reslang rl ON rl.`id_resume` = r.id)

Answer 1

Remove brackets. Otherwise, MySQL first tries to form a temporary table, and only then displays it.