# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-21T13:59:09+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 'Physical Review (1,1893-132,1963/141,1966-188,1969)') AND volume = 148 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 "1523915","3.6","","3.6","","11.5","","90","","90","","120","","129.072","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Nd Tm)","","- Nd Tm -","- Nd Tm -","- Nd2 Tm2 -","2","0.0833333","","Jayaraman, A.; Sherwood, R.C.; Corenzwit, E.; Williams, H.J.","Pressure-induced phase transformastions and magnetic ordering in some intra-rare-earth alloys and samarium","Physical Review (1,1893-132,1963/141,1966-188,1969)","1966","148","","502","508","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1523916","3.7","","3.7","","11.7","","90","","90","","120","","138.714","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Gd0.5 Nd0.5)","","- Gd0.5 Nd0.5 -","- Gd0.5 Nd0.5 -","- Gd2 Nd2 -","4","0.166667","","Jayaraman, A.; Sherwood, R.C.; Corenzwit, E.; Williams, H.J.","Pressure-induced phase transformations and magnetic ordering in some intra-rare-earth alloys and samarium","Physical Review (1,1893-132,1963/141,1966-188,1969)","1966","148","","502","508","","","","","","","","","","","","","","","","","","","","","","has coordinates","144540","2020-10-21","18:00:00","" "1523917","3.69","","3.69","","11.85","","90","","90","","120","","139.734","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(La Y)","","- La Y -","- La Y -","- La2 Y2 -","2","0.0833333","","Jayaraman, A.; Sherwood, R.C.; Williams, H.J.; Corenzwit, E.","Pressure induced phase transformations and magnetic ordering in some intra-rare earth alloys and samarium","Physical Review (1,1893-132,1963/141,1966-188,1969)","1966","148","","502","508","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""