-- initial page SELECT * FROM your_table WHERE status = 'active' ORDER BY dba_date DESC, id DESC LIMIT 50;
: Quickly see if any new tables or users were added today. new dba date desc
When a production server throws an error at 3:00 PM, looking at logs from 3:00 AM is rarely helpful. Yet, many default application views and legacy scripts output data in ascending order (oldest to newest). -- initial page SELECT * FROM your_table WHERE
This artificial creation date (first seen by your monitoring) is often more practical than relying on unreliable system tables. id DESC LIMIT 50