# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-27T09:25:37+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 'Metall (Berlin)') AND volume = 26 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 "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","" "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",""