# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-02T23:24:56+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 'Advances in X-Ray Analysis') AND volume = 40 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 "1521502","5.4056","","5.4156","","37.079","","90","","90","","90","","1085.47","","","","","","","","","","","","","7","A m a a","-A 2a 2","66","","(Bi1.64 Pb0.4) Sr1.47 (Ca1.83 Hg0.01) Cu2.72 O8.58","","- Bi1.64 Ca1.83 Cu2.72 Hg0.01 O8.58 Pb0.4 Sr1.47 -","- Bi1.64 Ca1.83 Cu2.72 Hg0.01 O8.58 Pb0.4 Sr1.47 -","- Bi6.56 Ca7.32 Cu10.88 Hg0.04 O34.32 Pb1.6 Sr5.88 -","4","0.25","","Li, D.Y.; O'Connor, B.H.; Hunter, B.A.; McKinnon, C.W.; Cookson, D.J.; Garrett, R.F.; van Riessen, A.","Characterisation of mercury-substituted (Bi, Pb)2 Sr2 Ca2 Cu3 Ox (2223) high-Tc phase using synchrotron radiation and neutron diffraction data","Advances in X-Ray Analysis","1998","40","","413","421","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00",""