# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-17T09:24:19+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 'Science in China') 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 "1522143","5.146","","5.205","","5.313","","90","","99.1","","90","","140.517","","","","","","","","","","","","","2","P 1 21/c 1","-P 2ybc","14","","Zr O2","","- O2 Zr -","- O2 Zr -","- O8 Zr4 -","4","1","","Wang, D.-N.; Guo, Y.-Q.; Liang, K.-M.; Tao, K.","Crystal structure of zirconia by Rietveld refinement","Science in China","1999","42","","80","86","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "9017817","13.839","","13.839","","4.496","","90","","90","","120","","745.704","","","","","","","","","","","","Luobusha ophiolite, Tibet","4","P 63 m c","P 6c -2c","186","","","Yarlongite","- C13.117 Cr11.515 Fe12.355 Ni2.867 -","- C22.2336 Cr23.0292 Fe24.7092 Ni5.7336 -","- C22.2336 Cr23.0292 Fe24.7092 Ni5.7336 -","","","","Shi, N.; Ma, Z.; Xiong, M.; Dai, M.; Bai, W.; Fang, Q.; Yan, B.; Yang, J.","The crystal structure of (Fe4Cr4Ni)9C4","Science in China","2005","48","","338","345","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:24",""