# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T08:40:36+01: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 'Liebigs Annalen/Recueil') AND volume = 1997 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
"1100439","8.967","0.002","12.842","0.001","15.1","0.003","90","","94.14","0.01","90","","1734.29","","","","","","","","","","","","","3","P 1 21 1","P 2yb","4","","","","- C40 H42 O7 -","- C40 H42 O7 -","- C80 H84 O14 -","2","1","","Reichardt, Christian; Blum, Andreas; Harms, Klaus; Schäfer, Gerhard","Pyridinium N-Phenolate Betaine Dyes and Their Application to the Characterization of the Polarity of Solvents, XXII. Syntheses and UV/Vis Spectroscopic Properties of Solvatochromic, Halochromic, and Chiro-Solvatochromic Pyridinium N-Phenolate Betaine Dyes with Four Stereogenic Centers","Liebigs Annalen/Recueil","1997","1997","4","707","720","10.1002/jlac.199719970411","","","","","","","","","","","","","","","","","","","","","has coordinates","177969","2020-10-21","18:00:00",""
"1100440","7.462","0.001","11.673","0.002","8.775","0.002","90","","105.39","0.03","90","","736.93","","","","","","","","","","","","","5","P 1 21 1","P 2yb","4","","","","- C13 H24 Cl N O3 -","- C13 H24 Cl N O3 -","- C26 H48 Cl2 N2 O6 -","2","1","","Aurich, Hans Günter; Biesemeier, Frank; Geiger, Michael; Harms, Klaus","Bicyclic and Tricyclic Compounds with β-Amino Alcohol Groups as Chiral Ligands in the Enantioselective Reaction of Diethylzinc with Aldehydes","Liebigs Annalen/Recueil","1997","1997","2","423","434","10.1002/jlac.199719970222","","","","","","","","","","","","","","","","","","","","","has coordinates","177967","2020-10-21","18:00:00",""
"1100441","15.488","0.001","15.488","0.001","11.604","0.001","90","","90","","120","","2410.62","","","","","","","","","","","","","4","P 61","P 61","169","","","","- C15.32 H28.3 N O3.33 -","- C27 H25 N O5 -","- C162 H150 N6 O30 -","6","1","","Aurich, Hans Günter; Biesemeier, Frank; Geiger, Michael; Harms, Klaus","Bicyclic and Tricyclic Compounds with β-Amino Alcohol Groups as Chiral Ligands in the Enantioselective Reaction of Diethylzinc with Aldehydes","Liebigs Annalen/Recueil","1997","1997","2","423","434","10.1002/jlac.199719970222","","","","","","","","","","","","","","","","","","","","","has coordinates","177967","2020-10-21","18:00:00",""
"1100442","5.291","0.001","13.453","0.001","16.941","0.001","90","","90","","90","","1205.86","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C12 H21 N O3 -","- C12 H21 N O3 -","- C48 H84 N4 O12 -","4","1","","Aurich, Hans Günter; Biesemeier, Frank; Geiger, Michael; Harms, Klaus","Bicyclic and Tricyclic Compounds with β-Amino Alcohol Groups as Chiral Ligands in the Enantioselective Reaction of Diethylzinc with Aldehydes","Liebigs Annalen/Recueil","1997","1997","2","423","434","10.1002/jlac.199719970222","","","","","","","","","","","","","","","","","","","","","has coordinates","177967","2020-10-21","18:00:00",""
"1100443","14.488","0.001","16.101","0.001","5.608","0.001","90","","90","","90","","1308.19","","","","","","","","","","","","","4","P 21 21 2","P 2 2ab","18","","","","- C12 H20 N2 O4 -","- C24 H40 N4 O8 -","- C96 H160 N16 O32 -","4","1","","Aurich, Hans Günter; Biesemeier, Frank; Harms, Klaus","An Intramolecular 1,3-Dipolar Cycloaddition Involving One Alkyne and Two Nitrone Groups","Liebigs Annalen/Recueil","1997","1997","3","469","471","10.1002/jlac.199719970306","","","","","","","","","","","","","","","","","","","","","has coordinates","177968","2020-10-21","18:00:00",""