# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-07T01:27:36+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 'The Rigaku Journal') 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
"1521340","4.90363","","4.90363","","23.93459","","90","","90","","120","","498.416","","","","","","","","","","","","","4","R 3 2 :H","R 3 2""","155","","Sr (Al2 B2 O7)","","- Al2 B2 O7 Sr -","- Al2 B2 O7 Sr -","- Al6 B6 O21 Sr3 -","3","0.166667","","Kaduk, J.A.; Satek, L.C.; McKenna, S.T.","Crystal structures of metal aluminium borates","The Rigaku Journal","1999","16","","17","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1521354","10.57945","","10.57945","","5.67357","","90","","90","","90","","635.013","","","","","","","","","","","","","4","I 4/m","-I 4","87","","Cu2 (Al6 B4 O17)","","- Al6 B4 Cu2 O17 -","- Al6.004 B4 Cu1.996 O17 -","- Al12.008 B8 Cu3.992 O34 -","2","0.125","","Kaduk, J.A.; McKenna, S.T.; Satek, L.C.","Crystal structures of metal aluminium borates","The Rigaku Journal","1999","16","","17","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","141563","2020-10-21","18:00:00",""