# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-03T02:53:09+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 = 136 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
"1008046","5.92","0.02","10.334","0.03","4.75","0.02","90","","90","","91.07","","290.5","","","","","","","","","","","","","3","P 1 1 21/b","-P 2bc","14","","Cobalt phosphate","","- Co3 O8 P2 -","- Co3 O8 P2 -","- Co6 O16 P4 -","2","0.5","","Berthet, G; Joubert, J C; Bertaut, E F","Vacancies ordering in new metastable orthophosphates (Co~3~ ) P~2~ O~8~ and (Mg~3~ ) P~2~ O~8~ with olivin-related structure","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1972","136","","98","105","","","","","","","0.1","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1008830","5.911","0.02","10.214","0.03","4.734","0.02","90","","90","","90.99","","285.8","","","","","","","","","","","","","3","P 1 1 21/b","-P 2bc","14","","Magnesium phosphate","","- Mg3 O8 P2 -","- Mg3 O8 P2 -","- Mg6 O16 P4 -","2","0.5","","Berthet, G; Joubert, J C; Bertaut, E F","Vacancies ordering in new metastable orthophosphates (Co3 ) P2 O8 and (Mg3 ) P2 O8 with olivin-related structure","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1972","136","","98","105","","","","","","","0.12","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"5000223","3.7892","0.0004","3.7892","0.0004","9.537","0.001","90","","90","","90","","136.9","","","","573.15","","","","","","","","Lengenbach quarry, Binnatal, Switzerland","2","I 41/a m d :1","I 4bw 2bw -1bw","141","","Titanium oxide","Anatase","- O2 Ti -","- O2 Ti -","- O8 Ti4 -","4","0.125","","Horn, M; Schwerdtfeger, C F; Meagher, E P","Refinement of the structure of anatase at several temperatures Sample: T = 300 C","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1972","136","","273","281","","","","","","","0.023","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"8103660","15.08","","14.45","","11","","90","","109.4","","90","","2260.87","","","","","","","","","","","","","4","P 1 21/n 1","-P 2yn","14","","(N H4)10 H2 (W12 O42) (H2 O)4","","- H50 N10 O46 W12 -","- N10 O46 W12 -","- N20 O92 W24 -","2","0.5","","d'Amour, H.; Allmann, R.","Die Kristallstruktur des Ammoniumparawolframat-tetrahydrats (N H4)10 H2 W12 O42 (H2 O)4","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1972","136","","23","47","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00",""
"8103664","12.253","","7.014","","7.014","","90","","90","","90","","602.801","","","","","","","","","","","","","4","C m m a","-C 2a 2","67","","Ge (O H) (P O4)","","- Ge H O5 P -","- Ge O5 P -","- Ge8 O40 P8 -","8","0.5","","Mayer, H.; Voellenkle, H.","Die Kristallstruktur und Fehlordnung von Ge (O H) P O4","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1972","136","","387","401","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8104396","44.02","","16.1","","7.44","","90","","91.5","","90","","5271.08","","","","","","","","","","","","","4","P -1","-P 1","2","","K4 (Ni2 (C N)6)","","- C6 K4 N6 Ni2 -","- C6 K4 N6 Ni2 -","- C12 K8 N12 Ni4 -","2","1","","Jarchow, O.","Die Kristallstruktur von K4 (Ni2 (C N)6)","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1972","136","","122","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","173385","2020-10-21","18:00:00",""