/dbme/guest:
list Tags
page [1 / 4]
all 1 2 3 4
1 - 200
mode=word lang=E
|
daily
[用例一覧] by Word.
no user[guest]
/dbme/guest
Tags :
[用例一覧] by Word.
, 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
target=
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