# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T11:47:10+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 'American Mineralogist') AND volume = 106 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
"9017871","6.697","","9.2986","","6.6501","","83.458","","76.226","","69.581","","376.722","","","","","","","","","","","","In a diamond from the Juina area, Mato Grosso State, Brazil","3","P -1","-P 1","2","","","Breyite","- Ca O3 Si -","- Ca6 O18 Si6 -","- Ca6 O18 Si6 -","","","","Brenker, F. E.; Nestola, F.; Brenker, L.; Peruzzo, L.; Harris, J. W.","Origin, properties, and structure of breyite: The second most abundant mineral inclusion in super-deep diamonds","American Mineralogist","2021","106","","38","43","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:27",""
"9017872","12.8926","","12.4658","","10.9178","","90","","97.92","","90","","1737.93","","","","","","","","","","","","the Santa Ana mine, San Luis province, Argentina","8","P 1 21/n 1","-P 2yn","14","","","Zhanghuifenite","- Al1.62 Ca0.22 Fe2.72 Mg3.36 Mn6.3 Na5.6 O48 P12 -","- Al3.24 Ca0.44 Fe5.44 Mg6.72 Mn12.6 Na11.2 O96 P24 -","- Al3.24 Ca0.44 Fe5.44 Mg6.72 Mn12.6 Na11.2 O96 P24 -","","","","Yang, H.; Kobsch, A.; Gu, X.; Downs, R. T.; Xie, X.","Zhanghuifenite, Na3Mn2+4Mg2Al(PO4)6, a new mineral isostructural with bobfergusonite, from the Santa Ana mine, San Luis province, Argentina","American Mineralogist","2021","106","","1009","1015","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:27",""