# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-26T22:13:13+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 'Journal of Chemical Education') AND volume = 92 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
"1520292","5.615","0.016","10.35","0.03","11.29","0.03","90","","102.9","0.03","90","","640","3","296","2","296","2","","","","","","","","6","P 1 21 1","P 2yb","4","","","","- C11 H14 Cl N O S -","- C11 H14 Cl N O S -","- C22 H28 Cl2 N2 O2 S2 -","2","1","","Chen, Xiao-Yang; Sun, Li-Sen; Gao, Xiang; Sun, Xing-Wen","Diastereoselective Allylation ofN-tert-Butanesulfinyl Imines: An Asymmetric Synthesis Experiment for the Undergraduate Organic Laboratory","Journal of Chemical Education","2015","92","4","714","","10.1021/ed500292q","","","0.71073","MoKα","","0.0508","0.0352","","","0.08","0.0995","","","","","","1.153","","","","has coordinates","176428","2020-10-21","18:00:00",""
"1553244","11.6881","0.0013","17.6933","0.0019","12.7663","0.0014","90","","97.516","0.001","90","","2617.4","0.5","173","2","173","2","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","12156a","","","- C37 H28 O -","- C37 H28 O -","- C148 H112 O4 -","4","1","","Hoang, Giang T.; Kubo, Tomohiro; Young, Victor G.; Kautzky, Jacob A.; Wissinger, Jane E.","Illustrating the Utility of X-ray Crystallography for Structure Elucidation through a Tandem Aldol Condensation/Diels‒Alder Reaction Sequence","Journal of Chemical Education","2015","92","8","1381","","10.1021/acs.jchemed.5b00027","","","0.71073","MoKα","","0.0584","0.0414","","","0.0951","0.1055","","","","","","1.038","","","","has coordinates","234002","2020-10-21","18:00:00",""
"1553245","10.6896","0.0009","11.5817","0.001","12.2608","0.0015","118.181","0.001","94.775","0.002","99.292","0.002","1298.1","0.2","173","2","173","2","","","","","","","","3","P -1","-P 1","2","","","","- C37 H28 O -","- C37 H28 O -","- C74 H56 O2 -","2","1","","Hoang, Giang T.; Kubo, Tomohiro; Young, Victor G.; Kautzky, Jacob A.; Wissinger, Jane E.","Illustrating the Utility of X-ray Crystallography for Structure Elucidation through a Tandem Aldol Condensation/Diels‒Alder Reaction Sequence","Journal of Chemical Education","2015","92","8","1381","","10.1021/acs.jchemed.5b00027","","","0.71073","MoKα","","0.0768","0.0465","","","0.1037","0.1154","","","","","","1.014","","","","has coordinates","234003","2020-10-21","18:00:00",""