# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-03T02:47:14+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 'Synthesis') AND volume = 2000 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
"1100214","6.434","0.001","7.4927","0.0013","24.108","0.004","96.28","0.02","90.192","0.019","98.24","0.019","1143.08","","","","193","","","","","","","","","4","P -1","-P 1","2","","(3RS,4SR,6SR,7SR)-1-Aza-9-oxa-4-phenyltricyclo(5.3.0.0^3,6^)decan-10-one","","- C14 H15 N O2 -","- C16 H19 N1.5 O2 -","- C64 H76 N6 O8 -","4","2","","Bach, Thorsten; Krüger, Christa; Harms, Klaus","The Stereoselective Synthesis of 2-Substituted 3-Azabicyclo[3.2.0]heptanes by Intramolecular [2+2]-Photocycloaddition Reactions","Synthesis","2000","2000","2","305","320","10.1055/s-2000-6261","","","","","","","4.52","","","4.52","","","","","","","","","","","has coordinates","176882","2020-10-21","18:00:00",""