# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-26T15:38:09+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 'Zeitschrift fuer Anorganische und Allgemeine Chemie') AND volume = 521 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 "1511196","7.971","","6.432","","6.457","","90","","90","","90","","331.047","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","K Li2 (B O3)","","- B K Li2 O3 -","- B K Li2 O3 -","- B4 K4 Li8 O12 -","4","0.5","","Miessen, M.; Hoppe, R.","Neue Borate der Alkalimetalle K Li2 (B O3)","Zeitschrift fuer Anorganische und Allgemeine Chemie","1985","521","","7","14","10.1002/zaac.19855210202","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "2002342","9.9705","0.0003","9.9705","0.0003","9.9705","0.0003","90","","90","","90","","991.2","","","","","","","","","","","","","4","I 21 3","I 2b 2c 3","199","","Tribarium diiron(III) pentaoxide dichloride","","- Ba3 Cl2 Fe2 O5 -","- Ba3 Cl2 Fe2 O5 -","- Ba12 Cl8 Fe8 O20 -","4","0.166667","","Leib, W; Mueller-Buschbaum, Hk","Ein neuer Bautyp der Oxohalogenferrate: Ba3 Fe2 O5 Cl2 und Ba3 Fe2 O5 Br2","Zeitschrift fuer Anorganische und Allgemeine Chemie","1985","521","","51","56","10.1002/zaac.19855210207","","","","","","0.058","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "2002343","10.0039","0.0008","10.0039","0.0008","10.0039","0.0008","90","","90","","90","","1001.2","","","","","","","","","","","","","4","I 21 3","I 2b 2c 3","199","","Tribarium diiron(III) pentaoxide bromide","","- Ba3 Br2 Fe2 O5 -","- Ba3 Br2 Fe2 O5 -","- Ba12 Br8 Fe8 O20 -","4","0.166667","","Leib, W; Mueller-Buschbaum, Hk","Ein neuer Bautyp der Oxohalogenferrate: Ba3 Fe2 O5 Cl2 und Ba3 Fe2 O5 Br2","Zeitschrift fuer Anorganische und Allgemeine Chemie","1985","521","","51","56","10.1002/zaac.19855210207","","","","","","0.068","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""