From 7e4b709b70003901735ac673ec8c0823e70494eb Mon Sep 17 00:00:00 2001 From: Santo Cariotti Date: Tue, 27 Sep 2022 18:38:08 +0200 Subject: Fix `ORDER BY` clause before `LIMIT` --- src/models/warning.rs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/models/warning.rs') 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) -- cgit v1.2.3-71-g8e6c