Support:Queries: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann characters and accounts |
imported>Hendrik Brummermann No edit summary |
||
Line 15:
FROM account, characters
WHERE characters.player_id=account.id AND username='[account]'
</source>
== Items ==
=== Item history of all items touched by suspicious character ===
<source lang="SQL">
SELECT * FROM itemlog, (SELECT DISTINCT itemid FROM itemlog WHERE source IN ('[charname1]', '[charname2]')) As x
WHERE x.itemid=itemlog.itemid
ORDER BY itemlog.itemid, itemlog.id
</source>
| |||