bCmPXGjJ

1CREATE TEMPORARY TABLE IF NOT EXISTS metinType0 AS (SELECT vnum, value5 FROM item_proto where type = 10);
2CREATE TEMPORARY TABLE IF NOT EXISTS metinType1 AS (SELECT vnum, value5 FROM item_proto where type = 10);
3CREATE TEMPORARY TABLE IF NOT EXISTS metinType2 AS (SELECT vnum, value5 FROM item_proto where type = 10);
4
5CREATE TEMPORARY TABLE IF NOT EXISTS metin_mapped AS (select id, vnum, socket0, socket1, socket2, 
6(select value5 from metinType0 where vnum = item.socket0) AS metin0, 
7(select value5 from metinType1 where vnum = item.socket1) AS metin1, 
8(select value5 from metinType2 where vnum = item.socket2) AS metin2 from item where vnum < 12010 and (socket0 > 2 or socket1 > 2 or socket2 > 2));
9
10
11select * from metin_mapped where (metin0 != 0 and metin0 = metin1) or (metin1 != 0 and metin1 = metin2) or (metin0 != 0 and metin0 = metin2);
12
13drop table metinType0;
14drop table metinType1;
15drop table metinType2;
16drop table metin_mapped;