SELECT TOP 10 *
FROM mail
WHERE (userid = 1) AND (username = 'mady') AND (mailorigin = 'send') AND
(mailid NOT IN
(SELECT TOP 10 mailid
FROM mail
WHERE (userid = 1) AND (username = 'mady') AND mailorigin = 'send'
ORDER BY mailid))
ORDER BY mailid
FROM mail
WHERE (userid = 1) AND (username = 'mady') AND (mailorigin = 'send') AND
(mailid NOT IN
(SELECT TOP 10 mailid
FROM mail
WHERE (userid = 1) AND (username = 'mady') AND mailorigin = 'send'
ORDER BY mailid))
ORDER BY mailid