list Tags Ver.1.50

No	Tags	No	Tags
4	about abrupt absurd accept 0	8	accord account across action 0
12	active add admit adverse 0	16	advise affair afford afraid 0
20	after again against agree 0	24	ahead alarm all all_that 0
28	allow almost along alter 0	32	alternate always amaze amid 0
36	amiss and angle any 0	40	apace appeal appear apply 0
44	argue arm around arrange 0	48	as_well aside ask associate 0
52	assure attack attend avenge 0	56	avoid away back bait 0
60	bang bare bear become 0	64	been behalf behind belong 0
68	bet better beyond bill 0	72	bind bit black blame 0
76	blink blow bolt bond 0	80	bore born bother bottom 0
84	bound bounty break breed 0	88	bright brind bring burnt 0
92	burst business bust bygone 0	96	cake call calm carry 0
100	cast catch certain channel 0	104	charge check chump circumstance 0
108	claim clear climb close 0	112	cloud clue come comfort 0
116	command commit common compel 0	120	complexion conclude concur conduct 0
124	confer conscienc_ consent consider 0	128	consist contain content continue 0
132	convenient convince cool copy 0	136	corner cost count countenance 0
140	course cover crack craft 0	144	crawl crowbar crumb crunch 0
148	crush cry cut damn 0	152	dare dead deal dear 0
156	decent decide deep deflect 0	160	defy deliver deluge depart 0
164	depend desert deserve desire 0	168	determin develop differ difficult 0
172	dig diligent dish dispose 0	176	distinct distress do_as doubt 0
180	down drag draw dream 0	184	drive drop dub due 0
188	dull early easy either 0	192	element eliminate end endure 0
196	enough entail escort establish 0	200	even ever examine except 0

CODE	LANG	POSI			WORD	2	3	4	TYPE	2	3	4	FL	CO	DATE	Flag
	SQLSTATE: 00000

, where tag.LANG='E' and tag.word is not null, count=1
select distinct tag.word word from (select t.CODE, t.LANG, t.POSI, t.FLAG, case p.seq when 1 then t.word when 2 then t.wo2 when 3 then t.wo3 when 4 then t.wo4 end as word from T_TAGS as t cross join T_PIVOT as p) tag where tag.LANG='E' and tag.word is not null

select distinct tag.word word from (select t.CODE, t.LANG, t.POSI, t.FLAG, case p.seq when 1 then t.word when 2 then t.wo2 when 3 then t.wo3 when 4 then t.wo4 end as word from T_TAGS as t cross join T_PIVOT as p) tag where tag.LANG='E' and tag.word is not nullecho variablesecho global variables

list Tags

list VIEW