# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T13:32:48+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 'Mineralogy and Petrology') AND volume = 96 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
"9013461","9.97","","9.97","","14.13","","90","","90","","120","","1216.36","","","","","","","","","","","","Bellerberg volcano, Eifel area, Germany","7","P 6/m c c","-P 6 2c","192","","","Friedrichbeckeite","- Be1.821 K0.926 Mg2.793 Mn0.386 Na0.772 O30 Si12 -","- Be1.821 K0.926 Mg2.793 Mn0.386 Na0.772 O30 Si12 -","- Be3.642 K1.852 Mg5.586 Mn0.772 Na1.544 O60 Si24 -","2","0.0833333","","Lengauer, C. L.; Hrauda, N.; Kolitsch, U.; Krickl, R.; Tillmanns, E.","Friedrichbeckeite, K(_0.5Na0.5)2(Mg0.8Mn0.1Fe0.1)2(Be0.6Mg0.4)3[Si12O30], a new milarite-type mineral from the Bellerberg volcano, Eifel area, Germany","Mineralogy and Petrology","2009","96","","221","232","10.1007/s00710-009-0050-9","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:09",""
"9014760","8.8989","","7.9717","","12.5624","","90","","90.022","","90","","891.169","","","","","","","","","","","","rim of La Fossa Crater, Vulcano, Aeolian Archipelago, Italy","5","P 1 21/c 1","-P 2ybc","14","","","Challacolloite","- Br0.13 Cl4.87 K0.94 Pb2 Tl0.06 -","- Br0.13 Cl4.87 K0.94 Pb2 Tl0.06 -","- Br0.52 Cl19.48 K3.76 Pb8 Tl0.24 -","4","1","","Mitolo, D.; Pinto, D.; Garavelli, A.; Bindi, L.; Vurro, F.","The role of the minor substitutions in the crystal structure of natural challacolloite, KPb2Cl5, and hephaistosite, TiPb2Cl5, from Vulcano (Aeolian Archipelago, Italy)","Mineralogy and Petrology","2009","96","","121","128","10.1007/s00710-008-0041-2","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18",""
"9015574","9.0026","","7.9723","","12.5693","","90","","90.046","","90","","902.116","","","","","","","","","","","","rim of La Fossa Crater, Vulcano, Aeolian Archipelago, Italy","5","P 1 21/c 1","-P 2ybc","14","","","Hephaistosite","- Br0.18 Cl4.82 K0.04 Pb2 Tl0.96 -","- Br0.18 Cl4.82 K0.04 Pb2 Tl0.96 -","- Br0.72 Cl19.28 K0.16 Pb8 Tl3.84 -","4","1","","Mitolo, D.; Pinto, D.; Garavelli, A.; Bindi, L.; Vurro, F.","The role of the minor substitutions in the crystal structure of natural challacolloite, KPb2Cl5, and hephaistosite, TiPb2Cl5, from Vulcano (Aeolian Archipelago, Italy)","Mineralogy and Petrology","2009","96","","121","128","10.1007/s00710-008-0041-2","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""