takes forever

SELECT
*,
ockovani_all.misto_nazev,
ockovani_all.vekova_skupina,

(ockovani_lastweek.total + ockovani_all.total * 0.2 ) * 0.001 as ockovani_total,
(ockovani_lastweek.total / ockovani_all.total) * 10 as ockovani_pomer,

ockovani_lastweek.total as w_total,

(registrace_all.rezervace / registrace_all.total) * 10 as registrace_rezervace_pomer,

registrace_lastweek.average_wait_time * -0.5 as waitTime,
registrace_all.average_wait_time * -0.25 as w_waitTime



FROM ockovani_all, ockovani_lastweek, registrace_all, registrace_lastweek

WHERE ockovani_all.misto_id = ockovani_lastweek.misto_id = registrace_lastweek.misto_id = registrace_all.misto_id AND

ockovani_all.vekova_skupina = ockovani_lastweek.vekova_skupina = registrace_all.vekova_skupina = registrace_lastweek.vekova_skupina


ORDER BY registrace_all.misto_nazev