Naudotojas:Vpovilaitis/šablonas

Forumai →

vpovilaitis

→ 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)