# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-07-01T01:43:18+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 = 122 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
"8103628","12.75","","12.75","","5.14","","90","","90","","120","","723.626","","","","","","","","","","","","","7","P 63","P 6c","173","","Na6 (Al6 Si6 O24) (Ca C O3) (H2 O)2","","- C H4 Al6 Ca Na6 O29 Si6 -","- C Al6 Ca Na6 O28.998 Si6 -","- C Al6 Ca Na6 O28.998 Si6 -","1","0.166667","","Jarchow, O.","Atomanordnung und Strukturverfeinerung von Cancrinit","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","407","422","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8104213","18.31","","8.927","","5.226","","90","","90","","90","","854.207","","","","","","","","","","","","","4","P b c a","-P 2ac 2ab","61","","Mg.93 Fe1.07 (Si2 O6)","","- Fe1.07 Mg0.93 O6 Si2 -","- Fe1.05 Mg0.95 O6 Si2 -","- Fe8.4 Mg7.6 O48 Si16 -","8","1","","Ghose, S.","Mg2+ - Fe2+ order in an orthopyroxene, Mg.93 Fe1.07 Si2 O6","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","81","99","","","","","","","","","","","","","","","","","","","","","","has coordinates","165421","2020-10-21","18:00:00",""
"8104217","12.72","","7.74","","7.49","","90","","92.83","","90","","736.512","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","(N H4)2 N H (S O3)2","","- H9 N3 O6 S2 -","- H9 N3 O6 S2 -","- H36 N12 O24 S8 -","4","0.5","","Jones, D.W.","A crystallographic study of ammonium and rubidium imidodisulphates","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","131","143","","","","","","","","","","","","","","","","","","","","","","has coordinates","189061","2020-10-21","18:00:00",""
"8104218","12.8","","7.68","","7.45","","90","","91.9","","90","","731.962","","","","","","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","Rb2 N H (S O3)2","","- H N O6 Rb2 S2 -","- H N O6 Rb2 S2 -","- H4 N4 O24 Rb8 S8 -","4","0.5","","Jones, D.W.","A crystallographic study of ammonium and rubidium imidodisulphates","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","131","143","","","","","","","","","","","","","","","","","","","","","","has coordinates","189061","2020-10-21","18:00:00",""
"8104253","6.992","","6.992","","7.17","","90","","90","","120","","303.566","","","","","","","","","","","","","2","P -3 c 1","-P 3 2""c","165","","","","- Cu3 P -","- Cu3 P -","- Cu18 P6 -","6","0.5","","Mansmann, M.","Ueber Verbindungen vom Anti-La F3-Strukturtyp","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","399","406","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"8104254","7.143","","7.143","","7.324","","90","","90","","120","","323.624","","","","","","","","","","","","","2","P -3 c 1","-P 3 2""c","165","","Cu3 As","","- As Cu3 -","- As Cu3 -","- As6 Cu18 -","6","0.5","","Mansmann, M.","Ueber Verbindungen vom Anti-LaF3-Strukturtyp","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","399","406","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8104285","4.33","","10.24","","12.2","","90","","90","","90","","540.938","","","","","","","","","","","","","2","P 21 21 21","P 2ac 2ab","19","","","","- As Br3 -","- As Br3 -","- As4 Br12 -","4","1","","Trotter, J.","The crystal structure of arsenic tribromide","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1965","122","","230","236","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"8104336","25.06","","7.94","","25.16","","90","","160.6","","90","","1662.88","","","","","","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","Pb6 As10.42 S20","","- As10.42 Pb6 S20 -","- As10.42 Pb6 S20 -","- As20.84 Pb12 S40 -","2","0.5","","Marumo, F.; Nowacki, W.","The crystal structure of rathite-I","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1965","122","","433","456","","","","","","","","","","","","","","","","","","","","","","has coordinates","172481","2020-10-21","18:00:00",""