# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-15T10:31:49+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 'Schweizerische Mineralogische und Petrographische Mitteilungen') AND volume = 57 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
"1529830","15.984","","15.984","","15.984","","90","","90","","90","","4083.72","","","","","","","","","","","","Synthetic","7","P n -3 :2","-P 2ab 2bc 3","201","","Ca5.92 Ti3 Fe2.97 Mn1.7 As11.18 H4 O40.68","Cafarsite","- As11.18 Ca5.92 Fe2.97 H4 Mn1.7 O40.68 Ti3 -","- As11.18 Ca5.92 Fe2.97 Mn1.7 O40.68 Ti3 -","- As44.72 Ca23.68 Fe11.88 Mn6.8 O162.72 Ti12 -","4","0.166667","","Edenharter, A.; Nowacki, W.; Weibel, M.","Zur Struktur und Zusammensetzung von Cafarsit. Cafarsit, ein As(III) - Oxid, kein Arsenat","Schweizerische Mineralogische und Petrographische Mitteilungen","1977","57","","1","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:01",""