# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-27T01:09:30+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 'Atti della Accademia delle Scienze di Torino, Classe di Scienze Fisiche, Matematiche e Naturali') 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
"1541679","15.565","","15.565","","11.816","","90","","90","","90","","2862.65","","","","","","","","","","","","","9","P 4/n n c :2","-P 4a 2bc","126","","Ca19 (Mg1.7 Fe2.5 Al1.2 Ti.4 Mn.2) Al8 (Si O4)10 (Si2 O7)4 O10 H6.2","","- Al9.2 Ca19 Fe2.5 H6.2 Mg1.7 Mn0.2 O78 Si18 Ti0.4 -","- Al9.2 Ca19 Fe2.5 Mg1.7 Mn0.2 O78 Si18 Ti0.4 -","- Al18.4 Ca38 Fe5 Mg3.4 Mn0.4 O156 Si36 Ti0.8 -","2","0.125","","Coda, A.; della Giusta, A.; Isetti, G.; Mazzi, F.","On the crystal structure of vesuvianite","Atti della Accademia delle Scienze di Torino, Classe di Scienze Fisiche, Matematiche e Naturali","1971","105","","63","84","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9014504","8.558","","7.697","","5.721","","92.583","","109.867","","109.983","","327.494","","","","","","","","","","","","Synthetic","4","P -1","-P 1","2","","","Svenekite","- As2 Ca H4 O8 -","- As2 Ca H4 O8 -","- As4 Ca2 H8 O16 -","2","1","","Chiari, G.; Ferraris, G.","The crystal structure of calcium dihydrogen arsenate, Ca(H2AsO4)2","Atti della Accademia delle Scienze di Torino, Classe di Scienze Fisiche, Matematiche e Naturali","1971","105","","725","743","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:51",""