t4LZTrnd

1-- drop TEMPORARY TABLE IF EXISTS tmp;
2
3CREATE TEMPORARY TABLE
4IF NOT EXISTS tmp AS (
5	SELECT
6		t.entry,
7		t.`name`,
8		t.castBarCaption,
9		l.name_loc8,
10		l.castbarcaption_loc8
11	FROM
12		gameobject_template AS t
13	LEFT JOIN locales_gameobject AS l ON l.entry = t.entry
14);
15
16CREATE TEMPORARY TABLE
17IF NOT EXISTS tmp2 AS (
18	SELECT
19		t.entry,
20		t.`name`,
21		t.castBarCaption,
22		l.name_loc8,
23		l.castbarcaption_loc8
24	FROM
25		gameobject_template AS t
26	LEFT JOIN locales_gameobject AS l ON l.entry = t.entry
27);
28
29drop TEMPORARY TABLE IF EXISTS result;
30CREATE TEMPORARY TABLE
31IF NOT EXISTS result AS (
32SELECT tm.*
33	 ,(SELECT	t2.name_loc8
34	 FROM tmp2 AS t2
35	  WHERE	t2.`name` = tm.`name` and ifnull(t2.name_loc8,'')<>''
36		ORDER BY t2.name_loc8
37	 LIMIT 1) as new_loc
38FROM tmp as tm
39where name_loc8 is null
40);
41
42select * from result where new_loc is not null
43order by new_loc, entry