# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-18T14:03:28+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 'Journal of the Physical Society of Japan') AND volume = 25 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 "1522635","7.335","","7.335","","7.335","","90","","90","","90","","394.639","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","(Nb0.2 Zr0.8) Zn2","","- Nb0.2 Zn2 Zr0.8 -","- Nb0.2 Zn2 Zr0.8 -","- Nb1.6 Zn16 Zr6.4 -","8","0.0416667","","Ogawa, S.","Magnetic properties of Zr1-x Tix Zn2, Zr1-x Yx Zn2, Zr1-x Nbx Tn2 and Zr1-x Hfx Zn2","Journal of the Physical Society of Japan","1968","25","","109","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00","" "1522636","7.38","","7.38","","7.38","","90","","90","","90","","401.947","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","(Hf0.3 Zr0.7) Zn2","","- Hf0.3 Zn2 Zr0.7 -","- Hf0.3 Zn2 Zr0.7 -","- Hf2.4 Zn16 Zr5.6 -","8","0.0416667","","Ogawa, S.","Magnetic properties of Zr1-x Tix Zn2, Zr1-x Yx Zn2, Zr1-x Nbx Zn2 and Zr1-x Hfx Zn2","Journal of the Physical Society of Japan","1968","25","","109","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00","" "1527896","7.406","","7.406","","7.406","","90","","90","","90","","406.21","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","(Y0.1 Zr0.9) Zn2","","- Y0.1 Zn2 Zr0.9 -","- Y0.1 Zn2 Zr0.9 -","- Y0.8 Zn16 Zr7.2 -","8","0.0416667","","Ogawa, S.","Magnetic properties of Zr1-x Tix Zn2, Zr1-x Yx Zn2 and Zr1-x Hfx Zn2","Journal of the Physical Society of Japan","1968","25","","109","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00","" "1541335","7.331","","7.331","","7.331","","90","","90","","90","","393.994","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","(Zr7 Ti3 Zn20)0.8","","- Ti2.4 Zn16 Zr5.6 -","- Ti2.4 Zn16 Zr5.6 -","- Ti2.4 Zn16 Zr5.6 -","1","0.00520833","","Ogawa, S.","Magnetic properties of Zr1-x Tix Zn2, Zr1-x Yx Zn2, Zr1-x Nbx Zn2 and Zr1-x Hfx Zn2","Journal of the Physical Society of Japan","1968","25","","109","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00",""