# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-26T21:18:42+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 'Journal of the Less-Common Metals') AND volume = 111 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 "1509772","4.3","","4.3","","10.98","","90","","90","","90","","203.02","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","","","- Ag2 Ce Ge2 -","- Ag2 Ce Ge2 -","- Ag4 Ce2 Ge4 -","2","0.0625","","Mayer, H.M.; Gottwick, U.; Rauchschwalbe, U.; Alheim, U.; Steglich, F.","Investigation of new lanthanum-, cerium- and uranium-based ternary intermetallics","Journal of the Less-Common Metals","1985","111","","265","275","10.1016/0022-5088(85)90197-3","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1524825","10.493","","10.493","","10.327","","90","","90","","120","","984.7","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","","","- Eu1.92 Mg17 -","- Eu1.915 Mg17 -","- Eu3.83 Mg34 -","2","0.0833333","","Lueken, H.; Erassme, J.","Strontium and europium polynuclear units in intermetallic compounds with magnesium. Structural refinements and relationships","Journal of the Less-Common Metals","1985","111","","101","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1524826","10.509","","10.509","","10.301","","90","","90","","120","","985.219","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","(Eu Sr)0.966 Mg17","","- Eu0.966 Mg17 Sr0.966 -","- Eu0.966 Mg17 Sr0.966 -","- Eu1.932 Mg34 Sr1.932 -","2","0.0833333","","Lueken, H.; Erassme, J.","Ferrimagnetic ordering in ternary compounds of Eu, Sr and Mg with Th2 Ni17-type structure relationships","Journal of the Less-Common Metals","1985","111","","101","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","145676","2020-10-21","18:00:00","" "1524827","10.535","","10.535","","10.322","","90","","90","","120","","992.119","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","(Eu0.33 Sr0.67)1.892 Mg17","","- Eu0.62436 Mg17 Sr1.26764 -","- Eu0.627 Mg17 Sr1.265 -","- Eu1.254 Mg34 Sr2.53 -","2","0.0833333","","Lueken, H.; Erassme, J.","Ferrimagnetic ordering in ternary compounds of Eu, Sr and Mg with Th2 Ni17-type structure relationships","Journal of the Less-Common Metals","1985","111","","101","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","145677","2020-10-21","18:00:00","" "1537708","4.128","","4.128","","9.52","","90","","90","","90","","162.224","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","Ru2 Tb Si2","","- Ru2 Si2 Tb -","- Ru2 Si2 Tb -","- Ru4 Si4 Tb2 -","2","0.0625","","Chevalier, B.; Etourneau, J.; Hagenmuller, P.; Rossat-Mignod, J.; Quezel, S.","Magnetic order in ternary compounds R Rh2 Si2 and R Ru2 Si2","Journal of the Less-Common Metals","1985","111","","161","169","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1537710","4.049","","4.049","","10.12","","90","","90","","90","","165.911","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","","","- Nd Rh2 Si2 -","- Nd Rh2 Si2 -","- Nd2 Rh4 Si4 -","2","0.0625","","Chevalier, B.; Etourneau, J.; Hagenmuller, P.; Quezel, S.; Rossat-Mignod, J.","Magnetic order in ternary compounds R Rh2 Si2 and R Ru2 Si2","Journal of the Less-Common Metals","1985","111","","161","169","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1537712","4.169","","4.169","","9.7","","90","","90","","90","","168.591","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","","","- Nd Ru2 Si2 -","- Nd Ru2 Si2 -","- Nd2 Ru4 Si4 -","2","0.0625","","Chevalier, B.; Etourneau, J.; Rossat-Mignod, J.; Quezel, S.; Hagenmuller, P.","Magnetic order in ternary compounds R Rh2 Si2 and R Ru2 Si2","Journal of the Less-Common Metals","1985","111","","161","169","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""