main1where1

\BEGIN{TABLE}
    \caption {main1where1}
    \BEGIN{tabular}{|l|}
    \hline
    Main query BEFORE                                                                                                                                                                                                                                                                                                                                                                                                                                                                         \\ \hline
                FROM Students AS a3, RelGroupsModules AS a4\\           LEFT OUTER JOIN RelTasksModules USING(ModuleId) \\          LEFT OUTER JOIN Tasks USING(TaskId) \\          LEFT OUTER JOIN Submissions \\              ON Submissions.PersonId = 1 \\              AND Submissions.GroupId = a4.GroupId \\             AND Submissions.TaskId = RelTasksModules.TaskId \\              AND Submissions.ModuleId = a4.ModuleId \\               AND (Submissions.Draft IS NULL OR Submissions.Draft = 0) \\         WHERE a3.PersonId = 1 AND \\                a3.GroupId = a4.GroupId  \\ \hline
    Main query after                                                                                                                                                                                                                                                                                                                                                                                                                                                                          \\ \hline
    FROM (\\            SELECT PersonID, a3.GroupID, ModuleID, ExpireTime                               \#5\\           FROM Students AS a3,\\              relgroupsmodules AS a4\\            WHERE a3.PersonId = 1\\             AND a3.GroupID = a4.GroupId\\       ) AS pg                                                                                                                                                                                                                                                                                        \\ \hline
    \END{tabular}
\END{TABLE}