# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-07T10:22:19+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 'Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)') AND volume = 124 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 "8103828","12.129","","10.858","","10.255","","90","","121.1","","90","","1156.43","","","","","","","","","","","","","5","C 1 c 1","C -2yc","9","","(N2 H5) (Ni (N H2 (N H) (C O O))3) (H2 O)","","- C3 H16 N8 Ni O7 -","- C3 N8 Ni O7 -","- C12 N32 Ni4 O28 -","4","1","","Braibanti, A.; Manotti Lanfredi, A.M.; Tiripicchio, A.","The crystal and molecular structure of hydrazinium tris(hydrazincarboxylato-N,O)niccolate(II) monohydrate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","335","351","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "8104221","8.66","","8.66","","4.81","","90","","90","","90","","360.729","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Nd Mn12","","- Mn12 Nd -","- Mn12 Nd -","- Mn24 Nd2 -","2","0.0625","","Kirchmayr, H.R.","Strukturen Seltener Erdmetall-Mangan-Verbindungen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","152","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "8104222","8.624","","8.624","","4.782","","90","","90","","90","","355.653","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Gd Mn12 -","- Gd Mn12 -","- Gd2 Mn24 -","2","0.0625","","Kirchmayr, H.R.","Strukturen Seltener Erdmetall-Mangan-Verbindungen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","152","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "8104223","8.579","","8.579","","4.763","","90","","90","","90","","350.553","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Dy Mn12 -","- Dy Mn12 -","- Dy2 Mn24 -","2","0.0625","","Kirchmayr, H.R.","Strukturen Seltener Erdmetall-Mangan'verbindungen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","152","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "8104224","8.57","","8.57","","4.747","","90","","90","","90","","348.643","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Ho Mn12 -","- Ho Mn12 -","- Ho2 Mn24 -","2","0.0625","","Kirchmayr, H.R.","Strukturen Seltener Erdmetall-Mangan-Verbindungen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","152","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "8104225","8.54","","8.54","","4.74","","90","","90","","90","","345.696","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Er Mn12 -","- Er Mn12 -","- Er2 Mn24 -","2","0.0625","","Kirchmayr, H.R.","Strukturen Seltener Erdmetall-Mangan-Verbindungen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","152","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "8104263","7.592","","7.592","","7.592","","90","","90","","90","","437.591","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","","","- Ho Mn2 -","- Ho Mn2 -","- Ho8 Mn16 -","8","0.0416667","","Kirchmayr, H.R.","Strukturen Seltener Erdmetall-Mangan-Verbindungen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1967","124","","152","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "8104272","10.244","","12.148","","4.34","","90","","90","","90","","540.087","","","","","","","","","","","","","2","P 21 21 21","P 2ac 2ab","19","","","","- As Br3 -","- As Br3 -","- As4 Br12 -","4","1","","Singh, A.K.; Swaminathan, S.","Refinement of the crystal structure of arsenic tribromide","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","124","","375","377","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""