# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T18:43:13+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 'Beitraege zur Mineralogie und Petrographie (-11,1965)') 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
"1528836","7.878","","9.415","","4.731","","90","","90","","90","","350.905","","","","","","","","","","","","","2","P n a m","-P 2c 2n","62","","","","- Ba Cl2 -","- Ba Cl2 -","- Ba4 Cl8 -","4","0.5","","Sahl, K.","Die Verfeinerung der Kristallstrukturen von Pb Cl2 (Cotunnit), Ba Cl2, Pb S O4 (Anglesit) und Ba S O4 (Baryt)","Beitraege zur Mineralogie und Petrographie (-11,1965)","1963","9","","111","132","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1528837","8.516","","5.399","","6.989","","90","","90","","90","","321.339","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Pb (S O4)","","- O4 Pb S -","- O4 Pb S -","- O16 Pb4 S4 -","4","0.5","","Sahl, K.","Die Verfeinerung der Kristallstrukutren von Pb Cl2 (Cotunnit), Ba Cl2, Pb S O4 (Anglesit) und Ba S O4 (Baryt)","Beitraege zur Mineralogie und Petrographie (-11,1965)","1963","9","","111","132","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1528897","12.03","","10.09","","6.26","","90","","107.5","","90","","724.687","","","","","","","","","","","","","5","P 1 21/a 1","-P 2yab","14","","K (Zn Cl3) (H2 O)2","","- Cl3 H4 K O2 Zn -","- Cl3 H4 K O2 Zn -","- Cl12 H16 K4 O8 Zn4 -","4","1","","Suesse, P.; Brehler, B.","Die Kristallstruktur des K Zn Cl3 (H2 O)2","Beitraege zur Mineralogie und Petrographie (-11,1965)","1964","10","","132","140","","","","","","","","","","","","","","","","","","","","","","has coordinates","186638","2020-10-21","18:00:00",""
"1535414","7.273","","7.273","","7.273","","90","","90","","90","","384.716","","","","","","","","","","","","","4","F -4 3 m","F -4 2 3","216","","Na6 Al4 Si4 O17","","- Al4 Na6 O17 Si4 -","- Al4 Na6.0032 O17.0048 Si4 -","- Al4 Na6.0032 O17.0048 Si4 -","1","0.0104167","","Borchert, W.; Keidel, J.","Beitraege zur Reaktionsfaehigkeit der Silikate bei niedrigen Temperaturen. II. Mitteilung. Die Strukturen Na2 O-reicher Carnegieite","Beitraege zur Mineralogie und Petrographie (-11,1965)","1947","1","","17","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","162787","2020-10-21","18:00:00",""
"1535417","7.273","","7.273","","7.273","","90","","90","","90","","384.716","","","","","","","","","","","","","4","F -4 3 m","F -4 2 3","216","","Na8 Al4 Si4 O18","","- Al4 Na8 O18 Si4 -","- Al4 Na7.9968 O18.0032 Si4 -","- Al4 Na7.9968 O18.0032 Si4 -","1","0.0104167","","Borchert, W.; Keidel, J.","Beitraege zur Reaktionsfaehigkeit der Silikate bei niedrigen Temperaturen. II. Mitteilung. Die Strukturen Na2 O-reicher Carnegieite","Beitraege zur Mineralogie und Petrographie (-11,1965)","1947","1","","17","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","162791","2020-10-21","18:00:00",""
"1537010","5.5","","16.24","","5.49","","90","","90","","90","","490.367","","","","","","","","","","","","","3","C m c a","-C 2ac 2","64","","","","- Bi2 Mo O6 -","- Bi2 Mo O6 -","- Bi8 Mo4 O24 -","4","","","Zemann, J.","Die Kristallstruktur von Koechlinit, Bi2 Mo O6","Beitraege zur Mineralogie und Petrographie (-11,1965)","1956","5","","139","145","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""