[DiscordArchive] someone able to tell me what i'm doing wrong?
[DiscordArchive] someone able to tell me what i'm doing wrong?
Original source
someone able to tell me what i'm doing wrong?
rektbyfaith
10-27-2020, 09:28 AM #1Archived author: Chaz • Posted: 2020-10-27T09:28:20.520000+00:00
Original source
someone able to tell me what i'm doing wrong?
Original source
```SELECT `guid`,`name` FROM `characters` JOIN `item_instance` ON `characters.guid` = `item_instance.owner_guid` WHERE `item_instance.itemEntry` = 87888;```
rektbyfaith
10-27-2020, 09:28 AM #2Archived author: Chaz • Posted: 2020-10-27T09:28:22.739000+00:00
Original source
```SELECT `guid`,`name` FROM `characters` JOIN `item_instance` ON `characters.guid` = `item_instance.owner_guid` WHERE `item_instance.itemEntry` = 87888;```
Original source
I want to see who has all the entries of item 87888
rektbyfaith
10-27-2020, 09:28 AM #3Archived author: Chaz • Posted: 2020-10-27T09:28:41.359000+00:00
Original source
I want to see who has all the entries of item 87888
Original source
`SELECT
c.guid,
name,
ii.itemEntry
FROM characters as c
JOIN item_instance AS ii ON c.guid = ii.owner_guid
WHERE
ii.itemEntry = 34655`
rektbyfaith
10-27-2020, 09:42 AM #4Archived author: Invarti • Posted: 2020-10-27T09:42:25.277000+00:00
Original source
`SELECT
c.guid,
name,
ii.itemEntry
FROM characters as c
JOIN item_instance AS ii ON c.guid = ii.owner_guid
WHERE
ii.itemEntry = 34655`
Original source
<@!207901137267851264> that is how I would write it
rektbyfaith
10-27-2020, 09:42 AM #5Archived author: Invarti • Posted: 2020-10-27T09:42:40.902000+00:00
Original source
<@!207901137267851264> that is how I would write it
1 Guest(s)
1 Guest(s)