$ranks = Model_Access::find("all", [
"select" => [
"article_id",
[DB::expr("COUNT(*)"), "views"],
],
"group_by" => [
"article_id"
],
"order_by" => [
"views" => "DESC"
]
]);
Fuel\Core\Database_Exception [ 1054 ]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.views' in 'order clause'
$ranks = Model_Access::find("all", [
"select" => [
"article_id",
[DB::expr("COUNT(*)"), "views"],
],
"group_by" => [
"article_id"
],
"order_by" => [
[DB::expr("t0_c1"), "DESC"]
]
]);
$ranks = Model_Access::find("all", [
"select" => [
"article_id",
],
"group_by" => [
"article_id"
],
"order_by" => [
[DB::expr("COUNT(*)"), "DESC"]
]
]);