# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-21T12:56: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 'Metall (Berlin)') 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 "1510236","8.04","","8.04","","8.46","","90","","90","","120","","473.602","","","","","","","","","","","","","2","P -3 c 1","-P 3 2""c","165","","","","- Au Mg3 -","- Au Mg3 -","- Au6 Mg18 -","6","0.5","","van Look, N.; Schubert, K.","Kristallstrukturuntersuchungen im System Au-Mg und einigen verwandten Legierungen","Metall (Berlin)","1969","23","","4","6","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1510632","4.863","","4.863","","3.043","","90","","90","","120","","62.322","","","","","","","","","","","","","3","P 6/m m m","-P 6 2","191","","Co3 Zr B2","","- B2 Co3 Zr -","- B2 Co3 Zr -","- B2 Co3 Zr -","1","0.0416667","","Schoebel, J.D.; Stadelmaier, H.H.","Kobaltreiche ternaere Phasen in den Dreistoffsystemen Kobalt-Hafnium-Bor und Kobalt-Zirkon-Bor","Metall (Berlin)","1969","23","","25","27","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1522786","4.754","","4.754","","4.754","","90","","90","","90","","107.443","","","","","","","","","","","","","3","P m -3 n","-P 4n 2 3","223","","(Ga0.2 Si0.8) V3","","- Ga0.2 Si0.8 V3 -","- Ga0.2 Si0.8 V3 -","- Ga0.4 Si1.6 V6 -","2","0.0416667","","Roeschel, E.; Raub, C.J.","Supraleitung ternaerer A15-Phasen des Vanadiums","Metall (Berlin)","1972","26","","29","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","143067","2020-10-21","18:00:00","" "1523391","16.44","","3.922","","5.488","","90","","90","","90","","353.854","","","","","","","","","","","","","2","P m m a","-P 2a 2a","51","","","","- Ga Pt2 -","- Ga Pt2 -","- Ga8 Pt16 -","8","1","","Chattopadhyay, T.K.; Khalaff, K.; Schubert, K.","Zur Konstitution der Mischungen Platin-Gallium und Platin-Gallium-Germanium","Metall (Berlin)","1974","28","","1160","1168","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1523392","5.484","","10.86","","3.95","","90","","90","","90","","235.247","","","","","","","","","","","","","2","P b a m","-P 2 2ab","55","","","","- Ga2.7 Pt5.3 -","- Ga2.7 Pt5.3 -","- Ga5.4 Pt10.6 -","2","0.25","","Chattopadhyay, T.K.; Khalaff, K.; Schubert, K.","Zur Konstitution der Mischungen Platin-Gallium und Platin-Gallium-Germanium","Metall (Berlin)","1974","28","","1160","1168","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1524713","3.0261","","3.0261","","3.0261","","90","","90","","90","","27.711","","","","","","","","","","","","","2","I m -3 m","-I 4 2 3","229","","(Cu0.85 Sn0.15)","","- Cu0.85 Sn0.15 -","- Cu0.85 Sn0.15 -","- Cu1.7 Sn0.3 -","2","0.0208333","","Knoedler, H.","Ueber Kristallstruktur und strukturellen Zusammenhang der Phasen gamma und epsilon im System Cu-Sn","Metall (Berlin)","1966","20","","823","829","","","","","","","","","","","","","","","","","","","","","","has coordinates","145537","2020-10-21","18:00:00","" "1538666","4.551","","4.551","","4.551","","90","","90","","90","","94.258","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Hf Zr N2","","- Hf N2 Zr -","- Hf N2 Zr -","- Hf2 N4 Zr2 -","2","0.0104167","","Kieffer, R.; Nowotny, H.; Ettmayer, P.; Dufek, G.","Neue Untersuchungen ueber die Mischbarkeit von Uebergangsmetallnitriden und -karbiden","Metall (Berlin)","1972","26","","701","708","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538667","4.389","","4.389","","4.389","","90","","90","","90","","84.547","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Nb N","","- N Nb -","- N Nb -","- N4 Nb4 -","4","0.0208333","","Kieffer, R.; Nowotny, H.; Ettmayer, P.; Dufek, G.","Neue Untersuchungen ueber die Mischbarkeit von Uebergangsmetallnitriden und -karbiden","Metall (Berlin)","1972","26","","701","708","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538668","4.328","","4.328","","4.328","","90","","90","","90","","81.07","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Nb Ti N2","","- N2 Nb Ti -","- N2 Nb Ti -","- N4 Nb2 Ti2 -","2","0.0104167","","Kieffer, R.; Nowotny, H.; Ettmayer, P.; Dufek, G.","Neue Untersuchungen ueber die Mischbarkeit von Uebergangsmetallnitriden und -karbiden","Metall (Berlin)","1972","26","","701","708","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538669","4.287","","4.287","","4.287","","90","","90","","90","","78.788","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Nb V N2","","- N2 Nb V -","- N2 Nb V -","- N4 Nb2 V2 -","2","0.0104167","","Kieffer, R.; Nowotny, H.; Ettmayer, P.; Dufek, G.","Neue Untersuchungen ueber die Mischbarkeit von Uebergangsmetallnitriden und -karbiden","Metall (Berlin)","1972","26","","701","708","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538670","4.192","","4.192","","4.192","","90","","90","","90","","73.665","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Ti V N2","","- N2 Ti V -","- N2 Ti V -","- N4 Ti2 V2 -","2","0.0104167","","Kieffer, R.; Dufek, G.; Nowotny, H.; Ettmayer, P.","Neue Untersuchungen ueber die Mischbarkeit von Uebergangsmetallnitriden und -karbiden","Metall (Berlin)","1972","26","","701","708","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538671","4.434","","4.434","","4.434","","90","","90","","90","","87.174","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Ti Zr N2","","- N2 Ti Zr -","- N2 Ti Zr -","- N4 Ti2 Zr2 -","2","0.0104167","","Kieffer, R.; Dufek, G.; Nowotny, H.; Ettmayer, P.","Neue Untersuchungen ueber die Mischbarkeit von Uebergangsmetallnitriden und -karbiden","Metall (Berlin)","1972","26","","701","708","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1539046","4.839","","4.839","","4.839","","90","","90","","90","","113.31","","","","","","","","","","","","","3","P m -3 n","-P 4n 2 3","223","","(Ge3 Sn2 V15)0.4","","- Ge1.2 Sn0.8 V6 -","- Ge1.2 Sn0.8 V6 -","- Ge1.2 Sn0.8 V6 -","1","0.0208333","","Roeschel, E.; Raub, C.J.","Supraleitung ternaerer A15-Phasen des Vanadiums","Metall (Berlin)","1972","26","","29","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","167777","2020-10-21","18:00:00","" "1539048","4.768","","4.768","","4.768","","90","","90","","90","","108.395","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Ge V3 -","- Ge V3 -","- Ge2 V6 -","2","0.0416667","","Roeschel, E.; Raub, C.J.","Supraleitung ternaerer A15-Phasen des Vanadiums","Metall (Berlin)","1972","26","","29","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541176","4.706","","4.706","","4.706","","90","","90","","90","","104.221","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","V3 Si","","- Si V3 -","- Si V3 -","- Si2 V6 -","2","0.0416667","","Roeschel, E.; Raub, C.J.","Supraleitung ternaerer A15-Phasen des Vanadiums","Metall (Berlin)","1972","26","","29","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1541177","4.958","","4.958","","4.958","","90","","90","","90","","121.876","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Sn V3 -","- Sn V3 -","- Sn2 V6 -","2","0.0416667","","Roeschel, E.; Raub, C.J.","Supraleitung ternaerer A15-Phasen des Vanadiums","Metall (Berlin)","1972","26","","29","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""