mysql torrent1> SELECT id, unread FROM messages WHERE receiver=60505 ORDER BY id DESC LIMIT 0,10;
+---------+--------+
| id | unread |
+---------+--------+
| 3144053 | no |
| 3143147 | no | - 3143803 missing
| 3142989 | no | - 3142237 missing - 3142171 missing..etc
| 3141997 | no |
| 3141945 | no |
| 3141795 | no |
| 3141053 | no |
| 3141035 | no |
| 3140863 | no |
| 3140629 | no |
+---------+--------+
10 rows in set (0.00 sec)
mysql torrent1> SELECT id, unread FROM messages WHERE receiver=60505 AND unread='yes' ORDER BY id DESC LIMIT 0,10;
+---------+--------+
| id | unread |
+---------+--------+
| 3141863 | yes | - why it doesn't appear at first q. answers ?
| 3142237 | yes | - why it doesn't appear at first q. answers ?
| 3143803 | yes | - why it doesn't appear at first q. answers ?
| 3142171 | yes | - why it doesn't appear at first q. answers ?
| 3142167 | yes | - why it doesn't appear at first q. answers ?..
| 3141889 | yes |
| 3140939 | yes |
| 3141925 | yes |
+---------+--------+
8 rows in set (0.01 sec)
Second bug, look at sorting of second q. results..