Support:Queries: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann No edit summary |
imported>Hendrik Brummermann |
||
Line 19:
== Items ==
=== Item history of all items touched by suspicious
<source lang="SQL">
SELECT *
SELECT * FROM itemlog, (SELECT DISTINCT itemid FROM itemlog WHERE source IN ('[charname1]', '[charname2]')) As x▼
FROM itemlog,
(SELECT DISTINCT itemid
FROM itemlog
▲
) As x
WHERE x.itemid=itemlog.itemid
ORDER BY itemlog.itemid, itemlog.id
</source>
=== Item history of all items touched by suspicious characters and someone else ===
<source lang="SQL">
SELECT *
FROM itemlog,
(SELECT DISTINCT i1.itemid
FROM itemlog i1, itemlog i2
WHERE i1.source IN ('[charname1]', '[charname2]')
AND i1.itemid=i2.itemid
AND i2.itemid NOT IN ('null', '[charname2]', '[charname2]')
) As x
WHERE x.itemid=itemlog.itemid
ORDER BY itemlog.itemid, itemlog.id
</source>
The string 'null' is required in the NOT IN clause because of register events
== Bots ==
| |||