# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T10:47:17+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 'The Rigaku Journal') AND volume = 16 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",""