# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T19:21:43+01:00
# Query:
# SELECT data.*
# FROM
#  data JOIN jaltnames
#  ON altname = journal
# WHERE
#  (status is null or status != 'retracted') and
#  (journal_id IN (SELECT DISTINCT(journal_id) FROM jaltnames WHERE altname LIKE 'TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)') AND volume = 27 AND duplicateof IS NULL AND (status is NULL OR status != 'errors') AND (method is NULL OR method != 'theoretical'))
# ORDER BY file asc
file,a,siga,b,sigb,c,sigc,alpha,sigalpha,beta,sigbeta,gamma,siggamma,vol,sigvol,celltemp,sigcelltemp,diffrtemp,sigdiffrtemp,cellpressure,sigcellpressure,diffrpressure,sigdiffrpressure,thermalhist,pressurehist,compoundsource,nel,sg,sgHall,sgNumber,commonname,chemname,mineral,formula,calcformula,cellformula,Z,Zprime,acce_code,authors,title,journal,year,volume,issue,firstpage,lastpage,doi,method,radiation,wavelength,radType,radSymbol,Rall,Robs,Rref,wRall,wRobs,wRref,RFsqd,RI,gofall,gofobs,gofgt,gofref,duplicateof,optimal,status,flags,svnrevision,date,time,onhold
"1524297","11.754","","5.1395","","7.6296","","90","","113.04","","90","","424.136","","","","","","","","","","","","","4","P 1 2/a 1","-P 2ya","13","","Li (Al Si4 O10)","","- Al Li O10 Si4 -","- Al Li O10 Si4 -","- Al2 Li2 O20 Si8 -","2","0.5","","Effenberger, H.","Petalit, Li Al Si4 O10: Verfeinerung der Kristallstruktur, Diskussion der Raumgruppe und Infrarot-Messung","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1980","27","","129","142","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9009603","6.71","","8.989","","14.533","","105.59","","93.44","","108.68","","789.532","","","","","","","","","","","","Tsumeb mine, Namibia","4","P -1","-P 1","2","","","Warikahnite","- As2 H4 O10 Zn3 -","- As2 H4 O10 Zn3 -","- As8 H16 O40 Zn12 -","4","2","","Riffel, H.; Keller, P.; Hess, H.","Die kristallstruktur von warikahnit, Zn3[(H2O)2|(AsO4)2]","Tschermaks Mineralogische und Petrographische Mitteilungen","1980","27","","187","199","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9011955","7.65","","7.55","","6.548","","90","","90","","90","","378.196","","","","","","","","","","","","","4","P b c n","-P 2n 2ab","60","","","Brenkite","- C Ca2 F2 O3 -","- C Ca2 F2 O3 -","- C4 Ca8 F8 O12 -","4","0.5","","Leufer, U.; Tillmanns, E.","Die kristallstruktur von brenkit, Ca2F2CO3","Tschermaks Mineralogische und Petrographische Mitteilungen","1980","27","","261","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""