# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-05-08T01:34:46+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 'Chinese Physics') AND volume = 10 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 "1526293","3.86248","","3.86248","","19.9242","","90","","90","","90","","297.244","","","","","","","","","","","","","5","I 4/m m m","-I 4 2","139","","(La1.4 Sr Ca0.6) Mn2 O7","","- Ca0.6 La1.4 Mn2 O7 Sr -","- Ca0.601 La1.4 Mn2 O7 Sr0.999 -","- Ca1.202 La2.8 Mn4 O14 Sr1.998 -","2","0.0625","","He, L.-H.; Zhang, P.-L.; Yan, Q.-W.","The structure and magnetic properties of La2-2x Sr Ca2x Mn2 O7 (x =0.25-1.00)","Chinese Physics","2001","10","","857","861","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1526295","3.8629","","3.8629","","19.6789","","90","","90","","90","","293.648","","","","","","","","","","","","","5","I 4/m m m","-I 4 2","139","","(La1.2 Sr Ca0.8) Mn2 O7","","- Ca0.8 La1.2 Mn2 O7 Sr -","- Ca0.8 La1.2 Mn2 O7 Sr -","- Ca1.6 La2.4 Mn4 O14 Sr2 -","2","0.0625","","He, L.-H.; Zhang, P.-L.; Yan, Q.-W.","The structure and magnetic properties of La2-2x Sr Ca2x Mn2 O7 (x =0.25-1.00)","Chinese Physics","2001","10","","857","861","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1526297","3.84333","","3.84333","","19.6083","","90","","90","","90","","289.638","","","","","","","","","","","","","5","I 4/m m m","-I 4 2","139","","(La0.8 Sr Ca1.2) Mn2 O7","","- Ca1.2 La0.8 Mn2 O7 Sr -","- Ca1.201 La0.8 Mn2 O7 Sr0.999 -","- Ca2.402 La1.6 Mn4 O14 Sr1.998 -","2","0.0625","","He, L.-H.; Zhang, P.-L.; Yan, Q.-W.","The structure and magnetic properties of La2-2x Sr Ca2x Mn2 O7 (x =0.25-1.00)","Chinese Physics","2001","10","","857","861","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1527038","3.07","","3.07","","3.523","","90","","90","","120","","28.755","","","","","","","","","","","","","3","P 6/m m m","-P 6 2","191","","Mg (B0.9 C0.1)2","","- C0.2 B1.8 Mg -","- C0.2 B1.8 Mg -","- C0.2 B1.8 Mg -","1","0.0416667","","Zhang, S.-Y.; Zhang, J.; Shen, B.-G.; Rong, C.-B.; Zhao, T.-Y.; Cheng, Z.-H.","Structure and superconductivity of Mg (B1-x Cx)2 compounds","Chinese Physics","2001","10","","335","337","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""