# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-26T23:46:10+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 'Chemica Scripta') AND volume = 22 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 "1510795","6.492","","11.645","","17.904","","90","","90","","90","","1353.53","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","Pb6 O2 (B O3)2 S O4","","- B2 O12 Pb6 S -","- B2 O12 Pb6 S -","- B8 O48 Pb24 S4 -","4","0.5","","Aurivillius, B.","The crystal structure of a basic lead borate sulfate, Pb6 O2 (B O3)2 S O4","Chemica Scripta","1983","22","","168","170","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1534700","5.623","","5.623","","23.119","","90","","90","","90","","730.98","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","(Pb O)6 Nb O2.5 Pb Br2","","- Br2 Nb O8.5 Pb7 -","- Br2 Nb O8 Pb7 -","- Br2 Nb O8 Pb7 -","1","0.03125","","Aurivillius, B.","On the Crystal Structure of Some Non-Stoichiometric Mixed Lead Oxide Halides and Their Relation to the Minerals ""Lorettoite"" and Sundiusite","Chemica Scripta","1983","22","","5","11","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1534702","3.9473","","3.9473","","23.221","","90","","90","","90","","361.811","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","(Pb O)6.5 (Cr O3).5 Pb Cl2","","- Cl2 Cr0.5 O8 Pb7.5 -","- Cl2 Cr0.5 O8 Pb7.5 -","- Cl2 Cr0.5 O8 Pb7.5 -","1","0.03125","","Aurivillius, B.","On the Crystal Structure of Some Non-Stoichiometric Mixed Lead Oxide Halides and Their Relation to the Minerals ""Lorettoite"" and Sundiusite","Chemica Scripta","1983","22","","5","11","","","","","","","","","","","","","","","","","","","","","","has coordinates","161650","2020-10-21","18:00:00","" "1534705","3.9346","","3.9346","","23.209","","90","","90","","90","","359.3","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","(Pb O)6.5 (S O3).5 Pb Cl2","","- Cl2 O8 Pb7.5 S0.5 -","- Cl2 O8 Pb7.5 S0.5 -","- Cl2 O8 Pb7.5 S0.5 -","1","0.03125","","Aurivillius, B.","On the Crystal Structure of Some Non-Stoichiometric Mixed Lead Oxide Halides and Their Relation to the Minerals ""Lorettoite"" and Sundiusite","Chemica Scripta","1983","22","","5","11","","","","","","","","","","","","","","","","","","","","","","has coordinates","161655","2020-10-21","18:00:00",""