Naudotojas:Vpovilaitis/šablonas
Forumai → |
|
→ Vpovilaitis/šablonas |
Vpovilaitis/šablonas
`a`;`b`;`c`;`d`;`e`;`f`;`g`;`h`;`i`;`j`;`k`;`l`;`m`;`n`;`o`;`p`;`q`;`r`;`s`;`t`;`u`;`v`;`w`;`x`
{{Auto taxobox |la=`b` |lt= |alias=`e` |type=`m` |autoriai=`f` |metai=`g` |karalystė=Animalia |parent=`d` |gbifid=`c` |colid=`h` |eolid={{subst:#invoke:JSON/EOL |getid|la=`e`|subst=subst:}} |itisid={{subst:#invoke:JSON/ITIS |getid|la=`e`|subst=subst:}} |vaizdas= |antraštė= |sinonimai2= }} {{TOCright |clear=none }} {{GrefTit|`b`}}, [[Vabalai|vabalų]] (''[[`d`]]'') `l` `m`. {{Kalbos|`b`}} == Išvaizda == {{Gmaxilgis|`b`}} == Biologija == == Mityba == == Paplitimas == {{Gpaplitimas|`b`}} {{subst:#ifeq:`r`|0|| == `s` == {{{subst:!}} `w` {{subst:!}}- {{subst:!}} {{header | title = {{Gref|`b`}} | author = {{{contributor|}}} | override_author = {{{override_author|}}} | translator = | section = '''`t`''' | previous = `u` | next = `v` | year = | wikipedia = | notes = }} {{gref/col2013|`b`|`l`|`p`|nuo=0|kiek=`r`}} {{subst:!}}} }} == Literatūra == {{refCOL2013|la=`b`}} == Nuorodos == {{Grefs|`b`}} == Šaltiniai == {{Reflist}}
insert into base.x_GBIFtax (c_name,c_taxon_id) SELECT distinct concat(t.alias," (",t.parent,")"), t.id FROM test.`gbifcol_ndistinct` t where t.id is not null and t.parent is not null and not exists (select 1 from base.x_GBIFtax u where u.c_name=concat(t.alias," (",t.parent,")")) and not exists (select 1 from base.x_GBIFtax u where u.c_taxon_id=t.id)
insert into base.x_col2013taxon (c_name,c_taxon_id) SELECT distinct concat(t.alias," (",t.col_parent,")"), t.col_id FROM test.`gbifcol_ndistinct` t where t.col_id is not null and t.col_parent is not null and not exists (select 1 from base.x_col2013taxon u where u.c_name=concat(t.alias," (",t.col_parent,")")) and not exists (select 1 from base.x_col2013taxon u where u.c_taxon_id=t.col_id)
Šiuo metu šiame puslapyje nėra žinučių.