# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-27T04:49:47+02: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') 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
"1200014","4.812","0.001","4.812","0.001","16.02","0.003","90","","90","","120","","321.3","","","","","","","","","","","","from Oberdorf, Styria, Austria","4","R -3 :H","-R 3","148","","Calcium magnesium carbonate","Dolomite","- C2 Ca Mg O6 -","- C2 Ca Mg O6 -","- C6 Ca3 Mg3 O18 -","3","0.166667","","Beran, A.; Zemann, J.","Refinement and comparison of the crystal structures of a dolomite and of an Fe-rich ankerite","TMPM, Tschermaks Mineralogische und Petrographische Mitteilungen","1977","24","4","279","286","10.1007/BF01081130","","","","","","0.029","","","","","","","","","","","","","","","has coordinates","208883","2020-10-21","18:00:00",""
"9009591","4.83","","4.83","","16.167","","90","","90","","120","","326.629","","","","","","","","","","","","Erzberg, Etage Dreikonig, Styria, Austria","6","R -3 :H","-R 3","148","","","Ankerite","- C2 Ca1.05 Fe0.63 Mg0.27 Mn0.05 O6 -","- C2 Ca1.05 Fe0.63 Mg0.27 Mn0.05 O6 -","- C6 Ca3.15 Fe1.89 Mg0.81 Mn0.15 O18 -","3","0.166667","","Beran, A.; Zemann, J.","Refinement and comparison of the crystal structures of a dolomite and of an Fe-rich ankerite","TMPM, Tschermaks Mineralogische und Petrographische Mitteilungen","1977","24","4","279","286","10.1007/BF01081130","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""