# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-29T03:43:02+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 (-144,1977)') AND volume = 119 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 "8103715","7.6816","","11.818","","6.7073","","92.355","","93.948","","105.665","","583.759","","","","","","","","","","","","","5","P -1","-P 1","2","","Mn0.806 Ca0.162 Mg0.032 (Si O3)","","- Ca0.162 Mg0.032 Mn0.806 O3 Si -","- Ca0.162 Mg0.032 Mn0.806 O3 Si -","- Ca1.62 Mg0.32 Mn8.06 O30 Si10 -","10","5","","Peacor, D.R.; Niizeki, N.","The redetermination and refinement of the crystal structure of rhodonite, (Mn, Ca) Si O3","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1963","119","","98","116","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "8104211","9.08","","8.01","","4.29","","90","","105.5","","90","","300.667","","","","","","","","","","","","","4","C 1 2/m 1","-C 2y","12","","(Mn (N2 H4)2) Cl2","","- Cl2 H8 Mn N4 -","- Cl2 H8 Mn N4 -","- Cl4 H16 Mn2 N8 -","2","0.25","","Ferrari, A.; Braibanti, A.; Bigliardi, G.; Dallavalle, F.","Crystal structure of bis-(hydrazine)manganese(II) chloride","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1963","119","","284","296","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "8104226","4.785","","4.821","","6.581","","90","","90","","90","","151.814","","","","","","","","","","","","","3","P n 21 m","P -2 -2bc","31","","Hg (S O4)","","- Hg O4 S -","- Hg O4 S -","- Hg2 O8 S2 -","2","0.5","","Kokkoros, P.A.; Rentzeperis, P.J.","The crystal structure of the anhydrous cadmium and mercuric sulfates","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1963","119","","234","244","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "8104273","7.48","","7.48","","7.48","","90","","90","","90","","418.509","","","","","","","","","","","","","3","I -4 3 m","I -4 2 3","217","","Zn4 O (B O2)6","","- B6 O13 Zn4 -","- B6 O13 Zn4 -","- B12 O26 Zn8 -","2","0.0416667","","Smith, P.; Rivoir, L.; Garcia-Blanco, S.","The crystal structure of anhydrous zinc metaborate Zn4 O (B O2)6","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1964","119","","375","383","","","","","","","","","","","","","","","","","","","","","","has coordinates","167874","2020-10-21","18:00:00","" "8104303","10.3908","","10.3908","","10.3908","","90","","90","","90","","1121.88","","","","","","","","","","","","","3","I -4 3 m","I -4 2 3","217","","Cu12 Sb4 S13","","- Cu12 S13 Sb4 -","- Cu12 S13 Sb4 -","- Cu24 S26 Sb8 -","2","0.0416667","","Wuensch, B.J.","The crystal structure of tetrahedrite, Cu12 Sb4 S13","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1964","119","","437","453","","","","","","","","","","","","","","","","","","","","","","has coordinates","169075","2020-10-21","18:00:00","" "8104358","18.73","","10.3","","7.54","","90","","90","","107.9","","1384.2","","","","","","","","","","","","","7","B 1 1 2/m","-B 2","12","","(Na1.1 K0.7 Ca1.7) (Al5.2 Si18.8 O48) (H2 O)12.7","","- Al5.2 Ca1.7 H25.4 K0.7 Na1.1 O60.7 Si18.8 -","- Al5.28 Ca1.68 K0.72 Na1.12 O60.72 Si18.72 -","- Al5.28 Ca1.68 K0.72 Na1.12 O60.72 Si18.72 -","1","0.125","","Gottardi, G.; Meier, W.M.","The crystal structure of dachiardite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1963","119","","53","64","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""