# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-09-29T01:19:32+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 'Naturwissenschaften') AND volume = 43 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 "1510117","6.11","","6.11","","6.11","","90","","90","","90","","228.099","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Au Cu Zn2 -","- Au Cu Zn2 -","- Au4 Cu4 Zn8 -","4","0.0208333","","Wilkens, M.; Schutt, W.; Schubert, K.; Esslinger, P.; Meissner, H.G.; Wegst, J.; Burkhardt, W.; Gunzel, E.","Einige strukturelle Ergebnisse an metallischen Phasen","Naturwissenschaften","1956","43","","248","249","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1510385","4.648","","8.998","","2.892","","90","","90","","90","","120.951","","","","","","","","","","","","","3","P b a m","-P 2 2ab","55","","","","- Au2 Cu Zn -","- Au2 Cu Zn -","- Au4 Cu2 Zn2 -","2","0.25","","Wilkens, M.; Wegst, J.; Gunzel, E.; Burkhardt, W.; Meissner, H.G.; Schutt, W.; Schubert, K.; Esslinger, P.","Einige strukturelle Ergebnisse an metallischen Phasen","Naturwissenschaften","1956","43","","248","249","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1510536","9.007","","2.915","","4.547","","90","","90","","90","","119.383","","","","","","","","","","","","","3","P c m a","-P 2ac 2ac","55","","Au4 Cu2.40 Zn1.60","","- Au4 Cu2.4 Zn1.6 -","- Au4 Cu2.4 Zn1.6 -","- Au4 Cu2.4 Zn1.6 -","1","0.125","","Schubert, K.; Esslinger, P.; Burkhardt, W.; Schutt, W.; Wegst, J.; Meissner, H.G.; Wilkens, M.; Gunzel, E.","Einige strukturelle Ergebnisse an metallischen Phasen","Naturwissenschaften","1956","43","","248","249","","","","","","","","","","","","","","","","","","","","","","has coordinates","176432","2020-10-21","18:00:00","" "1522847","2.765","","8.296","","3.938","","90","","90","","90","","90.332","","","","","","","","","","","","","2","I m m m","-I 2 2","71","","","","- Mo Pt2 -","- Mo Pt2 -","- Mo2 Pt4 -","2","0.125","","Schubert, K.; Burkhardt, W.; Schuett, W.; Esslinger, P.; Wegst, J.; Guenzel, E.; Meissner, H.G.; Wilkens, M.","Einige strukturelle Ergebnisse an metallischen Phasen","Naturwissenschaften","1956","43","","248","249","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1522848","5.98","","5.98","","5.98","","90","","90","","90","","213.847","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- Ni3 Sn -","- Ni3 Sn -","- Ni12 Sn4 -","4","0.0208333","","Schubert, K.; Burkhardt, W.; Guenzel, E.; Esslinger, P.; Meissner, H.G.; Schuett, W.; Wegst, J.; Wilkens, M.","Einige strukturelle Ergebnisse an metallischen Phasen","Naturwissenschaften","1956","43","","248","249","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""