# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T18:03:13+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 'Tschermaks Mineralogische und Petrographische Mitteilungen') AND volume = 32 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
"1540340","54.76","","4.03","","22.75","","90","","90","","90","","5020.53","","","","","","","","","","","","","6","P n m a","-P 2ac 2n","62","","Bi23 Cu Fe Pb18 Sb S56","","- Bi23 Cu Fe Pb18 S56 Sb -","- Bi23.0016 Cu Fe Pb18 S56 Sb -","- Bi23.0016 Cu Fe Pb18 S56 Sb -","1","0.125","","Kupcik, V.","Die Kristallstruktur des Minerals Eclarit, (Cu, Fe) Pb9 Bi12 S28","Tschermaks Mineralogische und Petrographische Mitteilungen (-1978)","1984","32","","259","269","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9009617","10.203","","10.678","","10.015","","90","","90","","90","","1091.11","","","","","","","","","","","","Synthetic","4","P b c a","-P 2ac 2ab","61","","","Newberyite","- H7 Mg O7 P -","- H7 Mg O7 P -","- H56 Mg8 O56 P8 -","8","1","","Bartl, H.; Catti, M.; Joswig, W.; Ferraris, G.","Investigation of the crystal structure of newberyite, MgHPO4*3H2O, by single crystal neutron diffraction","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","32","","187","194","10.1007/BF01081109","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48",""
"9011960","54.76","","4.03","","22.75","","90","","90","","90","","5020.53","","","","","","","","","","","","","6","P n m a","-P 2ac 2n","62","","","Eclarite","- Bi11.4 Cu0.6 Fe0.4 Pb9 S28 Sb0.6 -","- Bi11.4 Cu0.6 Fe0.4 Pb9 S28 Sb0.6 -","- Bi45.6 Cu2.4 Fe1.6 Pb36 S112 Sb2.4 -","4","0.5","","Kupcik, V.","Die kristallstruktur des minerals eclarit, (Cu,Fe)Pb9Bi12S28","Tschermaks Mineralogische und Petrographische Mitteilungen","1984","32","","259","269","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""