# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-27T01:53:01+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 'Mineralogical Magazine') AND volume = 81 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
"1548859","6.6615","0.0001","6.6615","0.0001","5.8023","0.0002","90","","90","","120","","222.985","0.009","","","","","","","","","","","","5","P -3 m 1","-P 3 2""","164","","","centennialite","- Ca Cl2 Cu3 H7.58 O6.79 -","- Ca Cl2 Cu3 H6 O7 -","- Ca Cl2 Cu3 H6 O7 -","1","0.0833333","","Crichton, Wilson A.; Müller, Harald","Centennialite, CaCu3(OH)6Cl2.nH2O, n ≈ 0.7, a new kapellasite-like species, and a reassessment of calumetite","Mineralogical Magazine","2017","81","5","1105","","10.1180/minmag.2016.080.157","","","","","","","","","","","","","","","","","","","","","has coordinates","206105","2020-10-21","18:00:00",""
"9017710","9.575","","5.685","","7.279","","89.985","","100.933","","101.3","","381.211","","","","","","","","","","","","Fogo volcano, Sao Miguel Island, the Azores","21","P -1","-P 1","2","","","Fogoite-(Y)","- Ca2.01 Ce0.03 Dy0.08 Er0.05 F2.88 Fe0.07 Gd0.08 La0.01 Lu0.01 Mn0.31 Na2.83 Nb0.23 Nd0.03 O15.12 Si4 Sm0.02 Ta0.01 Ti0.76 Y1.21 Yb0.04 Zr0.11 -","- Ca2.01 Ce0.03 Dy0.08 Er0.05 F2.88 Fe0.07 Gd0.08 La0.01 Lu0.01 Mn0.31 Na2.83 Nb0.23 Nd0.03 O15.12 Si4 Sm0.02 Ta0.01 Ti0.76 Y1.21 Yb0.04 Zr0.11 -","- Ca2.01 Ce0.03 Dy0.08 Er0.05 F2.88 Fe0.07 Gd0.08 La0.01 Lu0.01 Mn0.31 Na2.83 Nb0.23 Nd0.03 O15.12 Si4 Sm0.02 Ta0.01 Ti0.76 Y1.21 Yb0.04 Zr0.11 -","1","0.5","","Camara, F.; Sokolova, E.; Abdu, Y. A.; Hawthorne, F. C.; Charrier, T.; Dorcet, V.; Carpentier, J. F.","Fogoite-(Y), Na3Ca2Y2Ti(Si2O7)2OF3, a group I TS-block mineral from the Lagoa do Fogo, the Fogo volcano, Sao Miguel Island, the Azores: Description and crystal structure","Mineralogical Magazine","2017","81","","369","381","","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:12",""
"9017711","12.526","","12.914","","11.664","","90","","90","","90","","1886.78","","","","","","","","","","","","Michalkowa pegmatite, Gory Sowie Block, Poland","8","P c a b","-P 2bc 2ac","61","","","Maneckiite","- Ca2 Fe2.52 H4 Mg1.56 Mn1.92 Na0.9 O26 P6 -","- Ca2 Fe2.52 H4 Mg1.56 Mn1.92 Na0.9 O26 P6 -","- Ca8 Fe10.08 H16 Mg6.24 Mn7.68 Na3.6 O104 P24 -","4","0.5","","Pieczka, A.; Hawthorne, F. C.; Golebiowska, B.; Wlodek, A.; Grochowina, A.","Maneckiite, ideally NaCa2Fe2+2(Fe3+Mg)Mn2(PO4)6(H2O)2, a new phosphate mineral of the wicksite supergroup from the Michalkowa pegmatite, Gory Sowie Block, southwestern Poland","Mineralogical Magazine","2017","81","","723","736","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:56",""