# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-03T02:28:23+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 Physikalische Chemie, Abteilung B: Chemie der Elementarprozesse, Aufbau der Materie') AND volume = 40 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 "1011314","5.12952","0.00004","5.12952","0.00004","5.12952","0.00004","90","","90","","90","","135","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Lithium chloride","","- Cl Li -","- Cl Li -","- Cl4 Li4 -","4","0.0208333","","Ievin'sh, A F; Straumanis, M; Karlsons, K","Praezisionsbestimmung von Gitterkonstanten hygroskopischer Verbindungen (Li Cl, Na Br).","Zeitschrift fuer Physikalische Chemie, Abteilung B: Chemie der Elementarprozesse, Aufbau der Materie","1938","40","","146","150","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011315","5.96095","0.00005","5.96095","0.00005","5.96095","0.00005","90","","90","","90","","211.8","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Sodium bromide","","- Br Na -","- Br Na -","- Br4 Na4 -","4","0.0208333","","Ievin'sh, A F; Straumanis, M; Karlsons, K","Praezisionsbestimmung von Gitterkonstanten hygroskopischer Verbindungen (Li Cl, Na Br).","Zeitschrift fuer Physikalische Chemie, Abteilung B: Chemie der Elementarprozesse, Aufbau der Materie","1938","40","","146","150","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1522619","5.862","","5.862","","3.372","","90","","90","","120","","100.348","","","","","","","","","","","","","2","P -6 2 m","P -6 -2","189","","","","- Ni2 P -","- Ni2 P -","- Ni6 P3 -","3","0.25","","Nowotny, H.; Henglein, E.","Roentgenographische Untersuchungen im System Ni-P","Zeitschrift fuer Physikalische Chemie, Abteilung B: Chemie der Elementarprozesse, Aufbau der Materie","1938","40","","281","284","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""