Default sorting is ascending, you need to add the keyword DESC to both your orders:
ORDER BY article_rating DESC, article_time DESC
More Related Contents:
- MySQL order by before group by
- Why does MYSQL higher LIMIT offset slow the query down?
- MySQL ‘Order By’ – sorting alphanumeric correctly
- MySQL Orderby a number, Nulls last
- How does MySQL process ORDER BY and LIMIT in a query?
- Ordering by the order of values in a SQL IN() clause
- Ordering by specific field value first
- MySQL “Group By” and “Order By”
- Using union and order by clause in mysql
- SQL order string as number
- GROUP_CONCAT ORDER BY
- What is MySQL row order for “SELECT * FROM table_name;”?
- Slow query when using ORDER BY
- Select the 3 most recent records where the values of one column are distinct
- MySQL – Control which row is returned by a group by
- MySQL: Sort GROUP_CONCAT values
- MySQL order by “best match”
- Order by COUNT per value
- MySQL/MariaDB – order by inside subquery
- MySQL Order before Group by
- SQL Order By Count
- ORDER BY date and time BEFORE GROUP BY name in mysql
- Returning query results in predefined order
- Mysql delete statement with limit
- MySQL – ORDER BY values within IN()
- Mysql: Order by like?
- Sort the rows according to the order specified in WHERE IN clause
- ORDER BY alphabet first then follow by number
- MYSQL Select One Random record from each Category
- mysql order by, null first, and DESC after