# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-07T00:47:25+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 = 125 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
"1000061","5.062","0.001","8.671","0.002","4.713","0.001","90","","90.27","0.03","90","","206.9","","","","","","","","","","","","","3","P 1 21/a 1","-P 2yab","14","","Aluminium hydroxide","Bayerite","- Al H3 O3 -","- Al H3 O3 -","- Al4 H12 O12 -","4","1","","Rothbauer, R; Zigan, F; O'Daniel, H","Verfeinerung der Struktur des Bayerits, Al (O H)3","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","125","","317","331","","","","","","","0.11","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44",""
"8103388","9.22","","7.84","","8.06","","66.42","","65.28","","74.9","","481.987","","","","","","","","","","","","","5","P -1","-P 1","2","","Ag Pb Tl As2 S5","","- Ag As2 Pb S5 Tl -","- Ag As2 Pb S5 Tl -","- Ag2 As4 Pb2 S10 Tl2 -","2","1","","Nowacki, W.; Marumo, F.","The crystal structure of hatchite, Pb Tl Ag As2 S5","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1967","125","","249","265","10.1524/zkri.1967.125.125.249","","","","","","","","","","","","","","","","","","","","","has coordinates","176466","2020-10-21","18:00:00",""
"8103833","4.82","","5.76","","4.97","","90","","89.12","","90","","137.967","","","","","","","","","","","","","3","P 1 2/c 1","-P 2yc","13","","Mn W O4","","- Mn O4 W -","- Mn O4 W -","- Mn2 O8 W2 -","2","0.5","","Dachs, H.; Stoll, E.; Weitzel, H.","Kristallstruktur und magnetische Ordnung des Huebnerits, Mn W O4","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","125","","120","129","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8104219","6.73","","13.95","","10.03","","90","","111.52","","90","","876.009","","","","","","","","","","","","","4","P 1 c 1","P -2yc","7","","Ca (Al2 Si6 O16)","","- Al2 Ca O16 Si6 -","- Al2 Ca O16 Si6 -","- Al4 Ca2 O32 Si12 -","2","1","","Kerr, I.S.; Williams, D.J.","The crystal structure of yugawaralite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","125","","220","225","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8104274","3.3994","","3.3994","","11.377","","90","","90","","90","","131.472","","","","","","","","","","","","","3","B m m b","-B 2b 2","63","","Na (O H)","","- H Na O -","- Na O -","- Na4 O4 -","4","0.25","","Stehr, H.","Neubestimmung der Kristallstrukturen des dimorphen Natriumhydroxids, NaOH, bei verschiedenen Temperaturen mit Röntgenstrahl- und Neutronenbeugung","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","125","","332","359","10.1524/zkri.1967.125.16.332","","","","","","","","","","","","","","","","","","","","","has coordinates","208257","2020-10-21","18:00:00",""
"8104275","3.434","","3.428","","6.068","","90","","109.83","","90","","67.195","","","","","","","","","","","","","3","P 1 21/m 1","-P 2yb","11","","Na (O H)","","- H Na O -","- H Na O -","- H2 Na2 O2 -","2","0.5","","Stehr, H.","Neubestimmung der Kristallstrukturen des dimorphen Natriumhydroxids, Na O H, bei verschiedenen Temperaturen mit Roentgenstrahl- und Neutronenbeugung","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1967","125","","332","359","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""