# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T10:45:08+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 'Clays and Clay Minerals (29,1981-)') AND volume = 34 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
"1538776","5.2044","","9.018","","20.073","","90","","95.82","","90","","937.236","","","","","","","","","","","","","9","C 1 2/c 1","-C 2yc","15","","(K0.94 Na0.06) (Mg0.08 Al1.75 Fe0.15 Mn0.02) ((Al0.92 Si3.08) O10) (O H)2","","- Al2.67 Fe0.15 H2 K0.94 Mg0.08 Mn0.02 Na0.06 O12 Si3.08 -","- Al2.67 Fe0.15 H2 K0.94 Mg0.08 Mn0.02 Na0.06 O12 Si3.08 -","- Al10.68 Fe0.6 H8 K3.76 Mg0.32 Mn0.08 Na0.24 O48 Si12.32 -","4","0.5","","Knurr, R.A.; Bailey, S.W.","Refinement of Mn-substituted muscovite and phlogopite","Clays and Clay Minerals (29,1981-)","1986","34","","7","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1538779","5.316","","9.221","","10.282","","90","","99.9","","90","","496.507","","","","","","","","","","","","","10","C 1 2/m 1","-C 2y","12","","(K.86 Na.1) (Mg2.52 Mn.13 Al.13 Fe.17) (Al1.2 Si2.8) O10 F.1 (O H)1.9","","- Al1.33 F0.1 Fe0.17 H1.9 K0.86 Mg2.52 Mn0.13 Na0.1 O11.9 Si2.8 -","- Al1.329 F0.1 Fe0.171 H1.9 K0.84 Mg2.52 Mn0.129 Na0.1 O11.9 Si2.8 -","- Al2.658 F0.2 Fe0.342 H3.8 K1.68 Mg5.04 Mn0.258 Na0.2 O23.8 Si5.6 -","2","0.25","","Knurr, R.A.; Bailey, S.W.","Refinement of Mn-substituted muscovite and phlogopite","Clays and Clay Minerals (29,1981-)","1986","34","","7","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""