# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-17T19:08:08+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 'Physica C: Superconductivity and Its Applications (Amsterdam, Netherlands)') AND volume = 167 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 "1001458","5.442","0.004","5.462","0.004","36.9","0.02","90","","90","","90","","1096.8","","","","","","","","","","","","","6","F m m m","-F 2 2","69","","Lead strontium neodymium cerium copper oxide (2/2/1/1/3/10.2)","","- Ce Cu3 Nd O10.2 Pb2 Sr2 -","- Ce Cu3 Nd O10.2 Pb2 Sr2 -","- Ce4 Cu12 Nd4 O40.8 Pb8 Sr8 -","4","0.125","","Rouillon, T.; Groult, D.; Hervieu, M.; Michel, C.; Raveau, B.","Pb~2~Sr~2~LnCeCu~3~O~10+δ~, a new member of the layered cuprates family, built up from double fluorite-type layers","Physica C: Superconductivity and Its Applications (Amsterdam, Netherlands)","1990","167","1-2","107","111","10.1016/0921-4534(90)90493-X","","","","","","0.052","","","","","","","","","","","","","","","has coordinates","200133","2020-10-21","18:00:00","" "1008489","5.444","0.01","5.495","0.01","19.49","0.03","90","","90","","90","","583","","","","","","","","","","","","","5","C m m m","-C 2 2","65","","Trilead tristrontium copper(I) dicopper octaoxide chloride","","- Cl Cu3 O8 Pb3 Sr3 -","- Cl Cu3 O8 Pb3 Sr3 -","- Cl2 Cu6 O16 Pb6 Sr6 -","2","0.125","","Cava, R. J.; Bordet, P.; Capponi, J. J.; Chaillout, C.; Chenavas, J.; Fournier, T.; Hewat, E. A.; Hodeau, J. L.; Levy, J. P.; Marezio, M.; Batlogg, B.; Rupp, Jr, L. W.","Pb~3~Sr~3~Cu~3~O~8+δ~Cl: a new layered copper oxychloride","Physica C: Superconductivity and Its Applications (Amsterdam, Netherlands)","1990","167","1-2","67","74","10.1016/0921-4534(90)90487-Y","","","","","","0.055","","","","","","","","","","","","","","","has coordinates","200133","2020-10-21","18:00:00",""