# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-11T02:58:23+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 'Materials Science and Engineering') 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 "1508984","6.3623","","6.3623","","6.3623","","90","","90","","90","","257.539","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","Silver aluminum lithium (0.1/0.9/1)","","- Ag0.1 Al0.9 Li -","- Ag0.1 Al0.9 Li -","- Ag0.8 Al7.2 Li8 -","8","0.0416667","","Kishio, K.; Brittain, J.O.","Phase stability of doped beta-Li Al","Materials Science and Engineering","1981","49","","P1","P6","10.1016/0025-5416(81)90144-0","","","","","","","","","","","","","","","","","","","","","has coordinates","176432","2020-10-21","18:00:00","" "1522686","4.195","","4.195","","4.038","","90","","90","","120","","61.54","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- Ga2 Ho -","- Ga2 Ho -","- Ga2 Ho -","1","0.0416667","","Pelleg, J.; Kimmel, G.","The Ho-Ga system in the 66.7-100 at.% Ga range","Materials Science and Engineering","1982","52","","1","7","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1523686","4.412","","4.412","","3.642","","90","","90","","120","","61.396","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- Ga2 Np -","- Ga2 Np -","- Ga2 Np -","1","0.0416667","","Giessen, B.C.; Elliott, R.O.","Two new Np-Ga phases: alpha-Np Ga2 and metastable M-Np Ga2","Materials Science and Engineering","1976","23","","113","118","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1524408","4.77","","4.77","","4.77","","90","","90","","90","","108.531","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","(Ce Pu)","","- Ce Pu -","- Ce Pu -","- Ce2 Pu2 -","2","0.0104167","","Giessen, B.C.; Struebing, V.O.; Elliott, R.O.","Metastable f.c.c. Pu-Ce solid solutions","Materials Science and Engineering","1975","18","","239","243","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1539068","2.904","","2.904","","2.904","","90","","90","","90","","24.49","","","","","","","","","","","","","2","I m -3 m","-I 4 2 3","229","","","","- Ni V -","- Ni0.94 V1.06 -","- Ni0.94 V1.06 -","1","0.0104167","","Ruhl, R.C.; Giessen, B.C.; Cohen, M.; Grant, N.J.","Metastable b.c.c. phases in the V - Ni and Ni - In systems","Materials Science and Engineering","1967","2","","314","319","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""