From f0d8bb4d0400a99e0ff06357b39d4f9fd2783c78 Mon Sep 17 00:00:00 2001
From: Azcobu <81782124+Azcobu@users.noreply.github.com>
Date: Tue, 14 Sep 2021 00:00:58 +0930
Subject: fix: RLT query (#628)

---
 docs/useful-sql.md | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/docs/useful-sql.md b/docs/useful-sql.md
index cfcc2ca..6efeedd 100644
--- a/docs/useful-sql.md
+++ b/docs/useful-sql.md
@@ -21,10 +21,10 @@ WHERE it.entry = XXXXX;
 
 ### Find which RLTs an item is in
 ```sql
-SELECT rlt.entry, it.entry, it.name
+SELECT rlt.entry, it.name
 FROM `reference_loot_template` rlt
 JOIN `item_template` it ON rlt.Item = it.entry
-WHERE it.entry = XXXXX;
+WHERE rlt.item = XXXXX;
 ```
 
 ### Find which creatures share a RLT
-- 
cgit