diff options
| author | Azcobu <81782124+Azcobu@users.noreply.github.com> | 2021-09-14 00:00:58 +0930 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-09-13 16:30:58 +0200 |
| commit | f0d8bb4d0400a99e0ff06357b39d4f9fd2783c78 (patch) | |
| tree | 7e2013be6056ac53dfa17c4ac82defdfd2b8a6f9 | |
| parent | 2fbaadf56031c6ca3c454e0e1fb19c52f622e7b2 (diff) | |
| download | wiki-f0d8bb4d0400a99e0ff06357b39d4f9fd2783c78.tar.gz wiki-f0d8bb4d0400a99e0ff06357b39d4f9fd2783c78.tar.bz2 wiki-f0d8bb4d0400a99e0ff06357b39d4f9fd2783c78.zip | |
fix: RLT query (#628)
| -rw-r--r-- | docs/useful-sql.md | 4 |
1 files 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 |