Difference between revisions of "Sandbox/Publication pages"

AntWiki: The Ants --- Online
Jump to navigation Jump to search
Line 199: Line 199:
 
|format = list
 
|format = list
 
}}.
 
}}.
 +
 +
{{#cargo_query:
 +
tables=WorkerMorphology, Karyotype
 +
|join on=WorkerMorphology._pageName=Karyotype._pageName
 +
|fields= Karyotype.Diploid = Diploid, WorkerMorphology.AntennalSegmentCount = AntennalCount, WorkerMorphology._pageName = Taxon
 +
|where= Karyotype.Diploid HOLDS NOT ""
 +
|group by = WorkerMorphology._pageName
 +
|order by = Karyotype.Diploid
 +
}}

Revision as of 21:15, 13 January 2020

Potential formatting idea for the header of a publication source page. This is sourced from wikisource: [1]

original has this format:

header

| title      = 
| author     = 
| translator = 
| section    = 
| previous   = 
| next       = 
| year       = 
| notes      = 


can potentially make a new set: header

| title      = 
| author     = 
| year       = 
| pages      = 
| journal    = 
| book       = 
| report     = 
| ?          =

Current Taxobox

Temnothorax affinis
Scientific classification
Kingdom: Animalia
Phylum: Arthropoda
Class: Insecta
Order: Hymenoptera
Family: Formicidae
Subfamily: Myrmicinae
Tribe: Crematogastrini
Genus: Temnothorax
Species: T. affinis
Binomial name
Temnothorax affinis
(Mayr, 1855)

Temnothorax affinis casent0173201 profile 1.jpg

Temnothorax affinis casent0173201 dorsal 1.jpg

Specimen labels

Synonyms
Leptothorax tirolensis
Scientific classification (junior synonym of Temnothorax affinis)
Kingdom: Animalia
Phylum: Arthropoda
Class: Insecta
Order: Hymenoptera
Family: Formicidae
Subfamily: Myrmicinae
Tribe: Crematogastrini
Genus: Temnothorax
Species: Leptothorax tirolensis
Gredler, 1858

New Taxobox

Sandbox/Publication pages
Temnothorax affinis casent0173201 head 1.jpg
Temnothorax affinis casent0173201 profile 1.jpg
Temnothorax affinis casent0173201 dorsal 1.jpg
Specimen labels
Classification
Subfamily: Myrmicinae
Tribe: Crematogastrini
Genus: Temnothorax
Species
Temnothorax affinis
(Mayr, 1855)
Synonyms
Additional Details
Name Gender:
DOI:
Page:
Figures:
Type Material:
ZooBank ID:
Changed Comb.: yes
Original Genus: Leptothorax
Original Spelling: affinis
Sandbox/Publication pages
Scientific Classification
Junior synonym, see Temnothorax affinis
Classification
Genus: Temnothorax
Species
Leptothorax tirolensis
Gredler, 1858
Additional Details
Name Gender:
DOI:
Page:
Figures:
Type Material:
ZooBank ID:
Changed Comb.:
Original Genus: Leptothorax
Original Spelling: tirolensis

This taxon is not in use as it is currently considered to be a junior synonym of Temnothorax affinis.

Karyotype Data

Known Haploid Counts:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `wiki_cargo__Karyotype__Haploid`.`_value` AS `Haploid` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) LEFT OUTER JOIN `wiki_cargo__Karyotype__Haploid` ON ((`wiki_cargo__Karyotype`.`_ID`=`wiki_cargo__Karyotype__Haploid`.`_rowID`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Haploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" GROUP BY `wiki_cargo__Karyotype__Haploid`.`_value` ORDER BY `wiki_cargo__Karyotype__Haploid`.`_value` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

Haploid Count Details:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Haploid__full` AS `Haploid`,CONCAT ("", `wiki_cargo__Karyotype`.`_pageName`, "") AS `Taxon` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Haploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" ORDER BY `wiki_cargo__Karyotype`.`Haploid__full` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

Known Diploid Counts:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `wiki_cargo__Karyotype__Diploid`.`_value` AS `Diploid` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) LEFT OUTER JOIN `wiki_cargo__Karyotype__Diploid` ON ((`wiki_cargo__Karyotype`.`_ID`=`wiki_cargo__Karyotype__Diploid`.`_rowID`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Diploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" GROUP BY `wiki_cargo__Karyotype__Diploid`.`_value` ORDER BY `wiki_cargo__Karyotype__Diploid`.`_value` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

Diploid Count Details:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Diploid__full` AS `Diploid`,CONCAT ("", `wiki_cargo__Karyotype`.`_pageName`, "") AS `Taxon` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Diploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" ORDER BY `wiki_cargo__Karyotype`.`Diploid__full` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Diploid__full` AS `Diploid`,`AntennalSegmentCount__full` AS `AntennalCount`,`wiki_cargo__WorkerMorphology`.`_pageName` AS `Taxon` FROM `wiki_cargo__WorkerMorphology` LEFT OUTER JOIN `wiki_cargo__Karyotype` ON ((`wiki_cargo__WorkerMorphology`.`_pageName`=`wiki_cargo__Karyotype`.`_pageName`)) WHERE `wiki_cargo__Karyotype`.`_ID` IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Diploid` WHERE _value = NOT ) "" GROUP BY `wiki_cargo__WorkerMorphology`.`_pageName` ORDER BY `wiki_cargo__Karyotype`.`Diploid__full` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT ) "" GROUP BY `wiki_cargo__WorkerMorphology`.`_pageName` ORDER BY `wiki_car' at line 1 (localhost)