# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-01-24T12:41:06+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 'Naturwissenschaften') AND volume = 47 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 "1510446","4.61","","4.61","","2.72","","90","","90","","120","","50.061","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- Au2 Nb -","- Au2 Nb -","- Au2 Nb -","1","0.0416667","","Stolz, E.; Anantharaman, T.R.; Ata, H.O.K.; Meissner, H.G.; Poetzschke, M.; Schubert, K.; Rossteutscher, W.","Einige strukturelle Ergebnisse an metallischen Phasen VI","Naturwissenschaften","1960","47","","512","512","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1510447","3.38","","3.38","","15.18","","90","","90","","90","","173.422","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Au2 Nb3 -","- Au2 Nb3 -","- Au4 Nb6 -","2","0.0625","","Stolz, E.; Meissner, H.G.; Poetzschke, M.; Ata, H.O.K.; Schubert, K.; Rossteutscher, W.; Anantharaman, T.R.","Einige strukturelle Ergebnisse an metallischen Phasen VI","Naturwissenschaften","1960","47","","512","512","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1522850","2.968","","2.968","","4.344","","90","","90","","120","","33.14","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Ga0.25 Mn0.75)","","- Ga0.25 Mn0.75 -","- Ga0.25 Mn0.75 -","- Ga0.5 Mn1.5 -","2","0.0833333","","Schubert, K.; Anantharaman, T.R.; Rossteutscher, W.; Poetzschke, M.; Ata, H.O.K.; Meissner, H.G.; Stolz, E.","Einige strukturelle Ergebnisse an metallischen Phasen. VI","Naturwissenschaften","1960","47","","512","512","","","","","","","","","","","","","","","","","","","","","","has coordinates","143137","2020-10-21","18:00:00","" "1525230","3.701","","3.701","","3.701","","90","","90","","90","","50.694","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Fe3 Ga -","- Fe3 Ga -","- Fe3 Ga -","1","0.0208333","","Schubert, K.; Burkhardt, W.; Bhan, S.; Gohle, R.; Poetzschke, M.; Meissner, H.G.; Stolz, E.","Einige strukturelle Ergebnisse an metallischen Phasen (5)","Naturwissenschaften","1960","47","","303","303","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1525231","2.617","","2.617","","4.214","","90","","90","","120","","24.994","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Fe0.7 Ga0.3)","","- Fe0.7 Ga0.3 -","- Fe0.7 Ga0.3 -","- Fe1.4 Ga0.6 -","2","0.0833333","","Schubert, K.; Bhan, S.; Meissner, H.G.; Burkhardt, W.; Gohle, R.; Poetzschke, M.; Stolz, E.","Einige strukturelle Ergebnisse an metallischen Phasen (5)","Naturwissenschaften","1960","47","","303","303","","","","","","","","","","","","","","","","","","","","","","has coordinates","146153","2020-10-21","18:00:00","" "1527101","9.81","","5.65","","4.7","","90","","104.7","","90","","251.978","","","","","","","","","","","","","5","P 1 21/m 1","-P 2yb","11","","Pb Cu (S O4) (O H)2","","- Cu H2 O6 Pb S -","- Cu O6 Pb S -","- Cu2 O12 Pb2 S2 -","2","0.5","","Bachmann, H.G.; Zemann, J.","Die Kristallstruktur von Linarit, Pb Cu S O4 (O H)2","Naturwissenschaften","1960","47","","177","177","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1527130","5.97","","13.64","","7.98","","90","","90.43","","90","","649.799","","","","","","","","","","","","","4","P 1 21/n 1","-P 2yn","14","","Fe2 (S O4)2 (H2 O)8","","- Fe2 H16 O16 S2 -","- Fe2 O16 S2 -","- Fe4 O32 S4 -","2","0.5","","Baur, W.H.","Die Kristallstruktur von Fe S O4 (H2 O)4","Naturwissenschaften","1960","47","","467","467","","","","","","","","","","","","","","","","","","","","","","has coordinates","200438","2020-10-21","18:00:00","" "1528186","5.61","","5.67","","9.05","","90","","90","","90","","287.869","","","","","","","","","","","","","3","P 2 2 2","P 2 2","16","","Al (P S4)","","- Al P S4 -","- Al P S4 -","- Al2 P2 S8 -","2","0.5","","Weiss, A.; Schaefer, H.","Zur Kenntnis von Aluminiumthiophosphat Al P S4","Naturwissenschaften","1960","47","","495","495","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1528581","4.98","","4.98","","4.66","","90","","90","","120","","100.086","","","","","","","","","","","","","3","P -3 1 m","-P 3 2","162","","Li2 (Zr F6)","","- F6 Li2 Zr -","- F6 Li2 Zr -","- F6 Li2 Zr -","1","0.0833333","","Hoppe, R.; Daehne, W.","Zur Kristallstrukutr von Li2 Zr F6","Naturwissenschaften","1960","47","","397","397","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""