[A.....c]

CREATE TABLE allegro AS
SELECT c.name, c.guid, SUBSTRINGINDEX(SUBSTRINGINDEX(i.data, ' ', 4), ' ', -1) AS entry FROM characters c JOIN iteminstance i ON i.owner_guid = c.guid
WHERE SUBSTRINGINDEX(SUBSTRINGINDEX(i.data, ' ', 4), ' ', -1) IN (28830, 34472, 34183, 30889, 28528, 34473)
AND c.race=10 AND c.class = 2 AND c.gender = 1 ;#and c.logout_time > UNIXTIMESTAMP() - 160704000

ALTER IGNORE TABLE allegro
ADD UNIQUE INDEX (name, guid, entry);

A to jeden ze sposobów do znajdywania handlarzy na hg był. o( ❛ᴗ❛ )o
#hellground (っ˘ω˘ς )

[koostosh]

@Acrivec: (╯︵╰,)