Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- \BEGIN{TABLE}
- \caption {main6null}
- \BEGIN{tabular}{|l|}
- \hline
- Main query BEFORE \\ \hline
- SELECT Accepted \\FROM Approvements AS a5\\WHERE a5.SubmissionId = Submissions.SubmissionId \\AND a4.ExpireTime IS NOT NULL AND Submissions.SubmissionTime >= a4.ExpireTime \\ORDER BY ApprovementTime DESC \\LIMIT 1 \\ \hline
- Main query after \\ \hline
- SELECT Accepted \#7\\ FROM Approvements AS a5\\ WHERE a5.SubmissionId = Submissions.SubmissionId \\ AND a4.ExpireTime > '0000-00-00 00:00:00' \\AND Submissions.SubmissionTime >= pg.ExpireTime \\ ORDER BY ApprovementTime DESC \\ LIMIT 1 \\ \hline
- \END{tabular}
- \END{TABLE}
Advertisement
Add Comment
Please, Sign In to add comment