# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-30T19:06:21+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 Journal (Japan)') AND volume = 2 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
"1511155","9.37","","12.357","","3.055","","90","","90","","90","","353.723","","","","","","","","","","","","","4","P b a m","-P 2 2ab","55","","(Fe0.625 Mg0.375)2 Fe (B O3) O2","","- B Fe2.25 Mg0.75 O5 -","- B Fe2.25 Mg0.75 O5 -","- B4 Fe9 Mg3 O20 -","4","0.5","","Takeuchi, Y.","The crystal structure of vonsenite","Mineralogical Journal (Japan)","1956","2","","19","26","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1535330","5.293","","5.293","","7.79","","90","","90","","120","","189.004","","","","","","","","","","","","","4","P 6/m m m","-P 6 2","191","","Ba (Al Si O4)2","","- Al2 Ba O8 Si2 -","- Al2 Ba O8 Si2 -","- Al2 Ba O8 Si2 -","1","0.0416667","","Takeuchi, Y.","A detailed investigation of the structure of hexagonal Ba Al2 Si2 O8 with reference to its alpha-beta inversion","Mineralogical Journal (Japan)","1958","2","","311","332","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1537503","4.15","","4.15","","39.18999","","90","","90","","120","","584.524","","","","","","","","","","","","","3","R -3 m :H","-R 3 2""","166","","","","- Bi4 S2.76 Se0.24 -","- Bi4 S2.76 Se0.24 -","- Bi12 S8.28 Se0.72 -","3","0.0833333","","Kato, A.","Ikunolite, a new Bismuth Mineral from the Ikuno Mine, Japan","Mineralogical Journal (Japan)","1959","2","","397","407","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""