 <p>Without changing the table structure you could favor some ids in your ordering, e.g.</p> <pre><code>SELECT * FROM articles ORDER BY FIELD(id, 11, 51), date ASC </code></pre> <p>This would first display the articles with id 11 and 51, then the rest ordered by date.</p>