test1where tex

\BEGIN{TABLE}
    \caption {test1where}
    \BEGIN{tabular}{|l|}
    \hline
    Test query BEFORE                                                                                                                                                                                                                                                                                                                                      \\ \hline
    SELECT SQL\_NO\_CACHE p.personID,  m.moduleID, s.taskID\\    FROM submissions s\\    JOIN persons p ON s.PersonID = p.PersonID\\    JOIN modules m ON s.ModuleID = m.ModuleID\\    WHERE p.PersonID BETWEEN 92 AND 109\\        AND m.ModuleName LIKE '\%Программирование\%';                                                                          \\ \hline
    Client side timing: 0.0471\\Server side timing: 0.0463                                                                                                                                                                                                                                                                                                 \\ \hline
    Test query after                                                                                                                                                                                                                                                                                                                                       \\ \hline
    SELECT SQL\_NO\_CACHE p.personID, m.moduleID, s.taskID\\    FROM submissions s\\    JOIN (SELECT personID FROM persons\\            WHERE PersonID BETWEEN 92 AND 109) p\\        ON p.PersonID = s.PersonID\\    JOIN (SELECT moduleID FROM modules\\            WHERE ModuleName LIKE '\%Программирование\%') m\\        ON m.ModuleID = s.ModuleID; \\ \hline
    Client side timing: 0.0313\\Server side timing: 0.0317                                                                                                                                                                                                                                                                                                 \\ \hline
    \END{tabular}
\END{TABLE}