diff options
| author | Santo Cariotti <santo@dcariotti.me> | 2022-09-27 16:38:08 +0000 |
|---|---|---|
| committer | Santo Cariotti <santo@dcariotti.me> | 2022-09-27 16:38:08 +0000 |
| commit | 7e4b709b70003901735ac673ec8c0823e70494eb (patch) | |
| tree | b96309af520b2300c09e2615978609452aeeca61 /src/models | |
| parent | 91ce9c49fd3d70b40ebe6f4b9ce681ea3ab02534 (diff) | |
Fix `ORDER BY` clause before `LIMIT`
Diffstat (limited to 'src/models')
| -rw-r--r-- | src/models/warning.rs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/models/warning.rs b/src/models/warning.rs index 81abf20..5f92752 100644 --- a/src/models/warning.rs +++ b/src/models/warning.rs @@ -119,7 +119,7 @@ impl Warning { .await? } None => { - sqlx::query_as(&format!(r#"{} LIMIT $1 ORDER BY id DESC OFFSET $2"#, query)) + sqlx::query_as(&format!(r#"{} ORDER BY id DESC LIMIT $1 OFFSET $2"#, query)) .bind(CONFIG.page_limit) .bind(CONFIG.page_limit * page) .fetch_all(pool) @@ -233,7 +233,7 @@ impl Warning { .await? } None => { - sqlx::query_as(&format!(r#"{} LIMIT $2 ORDER BY id DESC OFFSET $3"#, query)) + sqlx::query_as(&format!(r#"{} ORDER BY id DESC LIMIT $2 OFFSET $3"#, query)) .bind(args.model_id) .bind(CONFIG.page_limit) .bind(CONFIG.page_limit * page) |