# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-01T00:42:58+01: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 'Zeitschrift fuer Metallkunde') AND volume = 34 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 "1522615","3.908","","3.908","","3.908","","90","","90","","90","","59.685","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Mg Sr -","- Mg Sr -","- Mg Sr -","1","0.0208333","","Nowotny, H.","Die Kristallstrukturen von Ni5 Ce, Ni5 Ca, Cu5 La, Cu5 Ca, Zn5 La, Zn5 Ca, Ni2 Ce, Mg Ce, Mg La und Mg Sr","Zeitschrift fuer Metallkunde","1942","34","","247","253","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1522616","5.416","","5.416","","4.217","","90","","90","","120","","107.125","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- La Zn5 -","- La Zn5 -","- La Zn5 -","1","0.0416667","","Nowotny, H.","Die Kristallstrukturen von Ni5 Ce, Ni5 La, Ni5 Ca, Cu5 La, Cu5 Ca, Zn5 La, Zn5 Ca, Ni2 Ce, Mg Ce, Mg La und Mg Sr","Zeitschrift fuer Metallkunde","1942","34","","247","253","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1523053","3.931","","3.931","","8.109","","90","","90","","90","","125.306","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Ga3 Ti -","- Ga3 Ti -","- Ga6 Ti2 -","2","0.0625","","Wallbaum, H.J.","Ueber die Isomorphie zwischen Al3 Ti, Ga3 Ti und Ga3 Zr","Zeitschrift fuer Metallkunde","1942","34","","118","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1523054","3.971","","3.971","","8.729","","90","","90","","90","","137.646","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Ga3 Zr -","- Ga3 Zr -","- Ga6 Zr2 -","2","0.0625","","Wallbaum, H.J.","Ueber die Isomorphie zwischen Al3 Ti, Ga3 Ti und Ga3 Zr","Zeitschrift fuer Metallkunde","1942","34","","118","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1538788","4.962","","4.962","","4.008","","90","","90","","120","","85.462","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- La Ni5 -","- La Ni5 -","- La Ni5 -","1","0.0416667","","Nowotny, H.","Die Kristalstrukturen von Ni5 Ce, Ni5 La, Ni5 Ca, Cu5 La, Cu5 Ca, Zn5 La, Zn5 Ca, Ni5 Ce, Mg Ce, Mg La und Mg Sr trigonal prisms","Zeitschrift fuer Metallkunde","1942","34","","247","253","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""