Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann |
imported>Hendrik Brummermann |
||
| Line 41: | Line 41: | ||
WHERE i1.source IN ('[charname1]', '[charname2]') |
WHERE i1.source IN ('[charname1]', '[charname2]') |
||
AND i1.itemid=i2.itemid |
AND i1.itemid=i2.itemid |
||
AND i2. |
AND i2.source NOT IN ('null', '[charname1]', '[charname2]') |
||
) As x |
) As x |
||
WHERE x.itemid=itemlog.itemid |
WHERE x.itemid=itemlog.itemid |
||