# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-29T15:15:37+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 'Chemica Scripta') AND volume = 19 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 "1534689","4.0149","","4.0149","","22.922","","90","","90","","90","","369.489","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Pb6.3 Mo O8 Br1.8","","- Br1.8 Mo O8 Pb6.3 -","- Br1.8 Mo0.9 O8 Pb6.3 -","- Br1.8 Mo0.9 O8 Pb6.3 -","1","0.03125","","Aurivillius, B.","On the Crystal Structure of a Number of Non-Stoichiometric Mixed Lead Oxide Halides Composed of PbO Like Blocks and Single Halogen Layers","Chemica Scripta","1982","19","","97","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1534692","4.0158","","4.0158","","22.765","","90","","90","","90","","367.123","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","((Pb O)6 (W O3) (Pb Br2)).9","","- Br1.8 O8.1 Pb6.3 W0.9 -","- Br1.8 O8 Pb6.3 W0.9 -","- Br1.8 O8 Pb6.3 W0.9 -","1","0.03125","","Aurivillius, B.","On the Crystal Structure of a Number of Non-Stoichiometric Mixed Lead Oxide Halides Composed of PbO Like Blocks and Single Halogen Layers","Chemica Scripta","1982","19","","97","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","161635","2020-10-21","18:00:00","" "1534696","3.9161","","3.9161","","22.746","","90","","90","","90","","348.829","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","((Pb O)7 (P O2.5) (Pb Cl2))0.9","","- Cl1.8 O4 P0.9 Pb7.1 -","- Cl1.8 O4 P0.9 Pb7.1 -","- Cl1.8 O4 P0.9 Pb7.1 -","1","0.03125","","Aurivillius, B.","On the crystal structure of a number of non-stoichiometric mixed lead oxide halides composed of Pb O like blocks and single halogen layers","Chemica Scripta","1982","19","","97","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","161640","2020-10-21","18:00:00",""