Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann No edit summary |
imported>Hendrik Brummermann |
||
| Line 19: | Line 19: | ||
== Items == |
== Items == |
||
=== Item history of all items touched by suspicious |
=== Item history of all items touched by suspicious characters === |
||
<source lang="SQL"> |
<source lang="SQL"> |
||
SELECT * |
|||
| ⚫ | |||
FROM itemlog, |
|||
(SELECT DISTINCT itemid |
|||
FROM itemlog |
|||
| ⚫ | |||
) As x |
|||
WHERE x.itemid=itemlog.itemid |
WHERE x.itemid=itemlog.itemid |
||
ORDER BY itemlog.itemid, itemlog.id |
ORDER BY itemlog.itemid, itemlog.id |
||
</source> |
</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 == |
== Bots == |
||