# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T08:45:54+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 'Tetrahedron') AND volume = 54 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
"1100527","12.116","0.002","12.443","0.001","12.749","0.001","62.66","0.01","62.74","0.01","84.28","0.01","1502.73","","","","","","","","","","","","","4","P -1","-P 1","2","","","","- C16 H23 N O3 -","- C16 H23 N O3 -","- C64 H92 N4 O12 -","4","2","","Baskaran, Subramanian; Aurich, Hans Günter; Biesemeier, Frank; Harms, Klaus","Effect of the substitution pattern on the oxidation of the isoxazolidine moiety in bi- and tricyclic compounds","Tetrahedron","1998","54","40","12249","12264","10.1016/s0040-4020(98)00765-0","","","","","","","","","","","","","","","","","","","","","has coordinates","178053","2020-10-21","18:00:00",""
"1100528","33.574","0.003","5.649","0.001","17.127","0.001","90","","110.41","0.01","90","","3044.37","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","","","- C16 H23 N O4 -","- C16 H26 N O5 -","- C128 H208 N8 O40 -","8","1","","Baskaran, Subramanian; Aurich, Hans Günter; Biesemeier, Frank; Harms, Klaus","Effect of the substitution pattern on the oxidation of the isoxazolidine moiety in bi- and tricyclic compounds","Tetrahedron","1998","54","40","12249","12264","10.1016/s0040-4020(98)00765-0","","","","","","","","","","","","","","","","","","","","","has coordinates","178053","2020-10-21","18:00:00",""
"1100529","8.32","0.001","7.893","0.001","12.691","0.001","90","","91.07","0.01","90","","833.27","","","","","","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C19 H21 N O3 -","- C19 H21 N O3 -","- C38 H42 N2 O6 -","2","1","","Baskaran, Subramanian; Aurich, Hans Günter; Biesemeier, Frank; Harms, Klaus","Effect of the substitution pattern on the oxidation of the isoxazolidine moiety in bi- and tricyclic compounds","Tetrahedron","1998","54","40","12249","12264","10.1016/s0040-4020(98)00765-0","","","","","","","","","","","","","","","","","","","","","has coordinates","178053","2020-10-21","18:00:00",""
"1100530","7.984","0.001","10.045","0.001","18.978","0.002","90","","90","","90","","1522.02","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C16 H25 N O3 -","- C16 H25 N O3 -","- C64 H100 N4 O12 -","4","1","","Baskaran, Subramanian; Aurich, Hans Günter; Biesemeier, Frank; Harms, Klaus","Effect of the substitution pattern on the oxidation of the isoxazolidine moiety in bi- and tricyclic compounds","Tetrahedron","1998","54","40","12249","12264","10.1016/s0040-4020(98)00765-0","","","","","","","","","","","","","","","","","","","","","has coordinates","178053","2020-10-21","18:00:00",""
"1100535","9.772","0.001","9.876","0.001","10.106","0.001","90","","117.06","0.01","90","","868.55","","","","","","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C19 H23 N O2 -","- C19 H23 N O2 -","- C38 H46 N2 O4 -","2","1","","Bach, Thorsten; Schröder, Jürgen; Brandl, Trixie; Hecht, Jürgen; Harms, Klaus","Facial diastereoselectivity in the photocycloaddition of chiral N-acyl enamines to benzaldehyde","Tetrahedron","1998","54","18","4507","4520","10.1016/s0040-4020(98)00161-6","","","","","","","","","","","","","","","","","","","","","has coordinates","178052","2020-10-21","18:00:00",""
"1100536","6.47","0.001","13.708","0.001","17.352","0.001","90","","90","","90","","1538.96","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C18 H19 N O3 -","- C18 H19 N O3 -","- C72 H76 N4 O12 -","4","1","","Bach, Thorsten; Schröder, Jürgen; Brandl, Trixie; Hecht, Jürgen; Harms, Klaus","Facial diastereoselectivity in the photocycloaddition of chiral N-acyl enamines to benzaldehyde","Tetrahedron","1998","54","18","4507","4520","10.1016/s0040-4020(98)00161-6","","","","","","","","","","","","","","","","","","","","","has coordinates","178052","2020-10-21","18:00:00",""
"1100537","6.373","0.001","14.8","0.001","17.892","0.001","90","","90","","90","","1687.58","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C19 H21 N O3 -","- C19 H21 N O3 -","- C76 H84 N4 O12 -","4","1","","Bach, Thorsten; Schröder, Jürgen; Brandl, Trixie; Hecht, Jürgen; Harms, Klaus","Facial diastereoselectivity in the photocycloaddition of chiral N-acyl enamines to benzaldehyde","Tetrahedron","1998","54","18","4507","4520","10.1016/s0040-4020(98)00161-6","","","","","","","","","","","","","","","","","","","","","has coordinates","178052","2020-10-21","18:00:00",""
"1100633","12.061","0.001","14.753","0.001","5.643","0.001","90","","90","","90","","1004.09","","","","","","","","","","","","","4","P 21 21 2","P 2 2ab","18","","","","- C10 H17 N O2 -","- C10 H17 N O2 -","- C40 H68 N4 O8 -","4","1","","Aurich, Hans Günter; Geiger, Michael; Gentes, Christian; Harms, Klaus; Köster, Heiner","Formation of enantiopure tricyclic compounds by intramolecular 1,3-dipolar cycloaddition of nitrones","Tetrahedron","1998","54","13","3181","3196","10.1016/s0040-4020(98)00064-7","","","","","","","","","","","","","","","","","","","","","has coordinates","178051","2020-10-21","18:00:00",""
"1100634","9.75","0.002","10.525","0.002","15.035","0.003","90","","90","","90","","1542.87","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C17 H24 N2 O -","- C17 H24 N2 O -","- C68 H96 N8 O4 -","4","1","","Aurich, Hans Günter; Geiger, Michael; Gentes, Christian; Harms, Klaus; Köster, Heiner","Formation of enantiopure tricyclic compounds by intramolecular 1,3-dipolar cycloaddition of nitrones","Tetrahedron","1998","54","13","3181","3196","10.1016/s0040-4020(98)00064-7","","","","","","","","","","","","","","","","","","","","","has coordinates","178051","2020-10-21","18:00:00",""