wow. just wow. I really laughed.
[09/08/15 01:52:48] Akasch: BAHAHAHHA
[09/08/15 01:52:49] Akasch: LASTY
[09/08/15 01:52:50] Akasch: SHANE
[09/08/15 01:52:51] Akasch:
[09/08/15 01:52:53] Akasch: OPEN THAT SPOILER
[09/08/15 01:52:56] Akasch: I DARE YOU TO READ IT
[09/08/15 01:52:58] Akasch: BAHAHAHAHAHHAHAHA
[09/08/15 01:53:02] Akasch: This is epic
[09/08/15 01:53:05] Akasch: JUST EPIC
[09/08/15 01:53:28] Akasch: My query was basically 1 statement
[09/08/15 01:53:28] Akasch: xD
[09/08/15 01:53:31] LastThief: ....
[09/08/15 01:53:31] Akasch: this **** is hella funny
[09/08/15 01:53:32] LastThief: dafuq is this
[09/08/15 01:53:33] LastThief: xD
[09/08/15 01:53:33] Akasch: bahahahaha
[09/08/15 01:53:36] Akasch: its godlike
How it works.
UPDATE IT
SET RefItemID = RR.ID
FROM _Items IT
JOIN _Refobjcom ON IT.ID64 = R.ID
JOIN _Refobjcom RR ON R.Codename128 + '_Model1' = RR.Codename128
Thats it. Count the lines.
