# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-01-26T02:38:50+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 'Materials Transactions, JIM') AND volume = 33 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 "1510332","8.095","","8.095","","5.794","","90","","90","","120","","328.808","","","","","","","","","","","","","2","P 3","P 3","143","","","","- Au1.01 Cd0.99 -","- Au Cd -","- Au9 Cd9 -","9","3","","Otsuka, K.; Ohba, T.; Emura, Y.","Crystal structure of gamma-martensite and the mechanism of beta2 - zeta2' transformation in a Au49.5 at.% Cd alloy","Materials Transactions, JIM","1992","33","","29","37","10.2320/matertrans1989.33.29","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541314","6.37","","6.37","","6.37","","90","","90","","90","","258.475","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Mg2 (Ge0.5 Si0.5)","","- Ge0.5 Mg2 Si0.5 -","- Ge0.5 Mg2 Si0.5 -","- Ge2 Mg8 Si2 -","4","0.0208333","","Noda, Yasutoshi; Kon, Hiroyuki; Furukawa, Yoshitaka; Otsuka, Nobuyuki; Nishida, Isao A.; Masumoto, Katashi","Preparation and thermoelectric properties of Mg~2~Si~1-x~Ge~x~ (x=0.0σim 0.4) solid solution semiconductors","Materials Transactions, JIM","1992","33","9","845","850","10.2320/matertrans1989.33.845","","","","","","","","","","","","","","","","","","","","","has coordinates","176274","2020-10-21","18:00:00",""