# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-28T12:51:48+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 Research Bulletin') AND volume = 2 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 "1510502","3.633","","3.633","","3.633","","90","","90","","90","","47.951","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","(Au3 Cu97)0.04","","- Au0.12 Cu3.88 -","- Au0.12 Cu3.88 -","- Au0.12 Cu3.88 -","1","0.00520833","","Brockhouse, B.N.; Hallman, E.D.; Ng, S.C.","Characterization of large alloy single crystals by neutron diffraction","Materials Research Bulletin","1967","2","","69","73","10.1016/0025-5408(67)90044-X","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1534693","10.95","","10.95","","10.95","","90","","90","","90","","1312.93","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","Mn Yb2 S3.8","","- Mn S3.8 Yb2 -","- Mn S3.8 Yb2 -","- Mn8 S30.4 Yb16 -","8","0.0416667","","Longo, J.M.; Raccah, P.M.","Magnetic and structural study of the spinel Mn Yb2 S4","Materials Research Bulletin","1967","2","","541","547","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538359","5.103","","5.103","","13.755","","90","","90","","120","","310.2","","","","","","","","","","","","","3","R 3 :H","R 3","146","","Ni3 (Te O6)","","- Ni3 O6 Te -","- Ni3 O6 Te -","- Ni9 O18 Te3 -","3","0.333333","","Newnham, R.E.; Meagher, E.P.","Crystal structure of Ni3 Te O6","Materials Research Bulletin","1967","2","","549","554","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538360","3.84","","3.84","","40.75","","90","","90","","90","","600.883","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Na.5 Bi4.5 Ti4 O15","","- Bi4.5 Na0.5 O15 Ti4 -","- Bi4.5 Na0.5 O15 Ti4 -","- Bi9 Na O30 Ti8 -","2","0.0625","","Newnham, R.E.","Cation ordering in Na.5 Bi4.5 Ti4 O15","Materials Research Bulletin","1967","2","","1041","1044","","","","","","","","","","","","","","","","","","","","","","has coordinates","166866","2020-10-21","18:00:00","" "1538739","4.9194","","4.9194","","4.9194","","90","","90","","90","","119.052","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","(Pb3 Tl2)0.8","","- Pb2.4 Tl1.6 -","- Pb2.4 Tl1.6 -","- Pb2.4 Tl1.6 -","1","0.00520833","","Ng, S.C.; Brockhouse, B.N.; Hallman, E.D.","Characterization of large alloy single crystals by neutron diffraction","Materials Research Bulletin","1967","2","","69","73","","","","","","","","","","","","","","","","","","","","","","has coordinates","167420","2020-10-21","18:00:00","" "1539252","6.393","","6.393","","6.393","","90","","90","","90","","261.285","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Pb Sn Te2 -","- Pb Sn Te2 -","- Pb2 Sn2 Te4 -","2","0.0104167","","Wagner, John W.; Woolley, J.C.","Phase studies of the Pb1-x Snx Te alloys","Materials Research Bulletin","1967","2","","1055","1062","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""