# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T14:54: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 'European Journal of Organic Chemistry') AND volume = 2002 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
"1000508","13.7805","0.0012","29.081","0.005","8.4303","0.0012","90","","90","","90","","3378.45","","","","293","","","","","","","","","3","P c c n","-P 2ab 2ac","56","","Methyl (4S*,4aS*,8aS*)-4-t-butoxy-8a-methoxy-4a,5,6,7,8,8a-hexahydro-4H-chromene-2-carboxylate","","- C16 H26 O5 -","- C16 H26 O5 -","- C128 H208 O40 -","8","1","","Martel, A.; Leconte, S.; Dujardin, G.; Brown, E.; Maisonneuve, V.; Retoux, R.","Lewis Acid Catalysed [4+2] Heterocycloadditions between Ketone Enol Ethers and β-Ethylenic α-Oxo Esters","European Journal of Organic Chemistry","2002","2002","3","514","525","10.1002/1099-0690(20022)2002:3<514::AID-EJOC514>3.0.CO;2-Z","","","","","","","0.0535","","","0.0535","","","","","","","","","","","has coordinates","175065","2020-10-21","18:00:00",""
"1000509","28.084","0.003","8.3502","0.0007","20.303","0.003","90","","98.37","0.02","90","","4710.48","","","","293","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","Methyl (4R*,4aS*,8aR*)-8a-t-butyldimethylsiloxy-4-phenyl-4a,5,6,7,8,8a-hexahydro-4H-chromene-2-carboxylate","","- C23 H34 O4 Si -","- C23 H34 O4 Si -","- C184 H272 O32 Si8 -","8","1","","Martel, A.; Leconte, S.; Dujardin, G.; Brown, E.; Maisonneuve, V.; Retoux, R.","Lewis Acid Catalysed [4+2] Heterocycloadditions between Ketone Enol Ethers and β-Ethylenic α-Oxo Esters","European Journal of Organic Chemistry","2002","2002","3","514","525","10.1002/1099-0690(20022)2002:3<514::AID-EJOC514>3.0.CO;2-Z","","","","","","","0.0536","","","0.0536","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1000510","9.4586","0.0017","11.1593","0.0016","12.4892","0.0015","89.406","0.01","72.021","0.013","70.117","0.011","1172.52","","","","293","","","","","","","","","4","P -1","-P 1","2","","Methyl (4R*,4aS*,8aS*)-8a-t-butyldimethylsiloxy-4-phenyl-4a,5,6,7,8,8a-hexahydro-4H-chromene-2-carboxylate","","- C23 H34 O4 Si -","- C23 H34 O4 Si -","- C46 H68 O8 Si2 -","2","1","","Martel, A.; Leconte, S.; Dujardin, G.; Brown, E.; Maisonneuve, V.; Retoux, R.","Lewis Acid Catalysed [4+2] Heterocycloadditions between Ketone Enol Ethers and β-Ethylenic α-Oxo Esters","European Journal of Organic Chemistry","2002","2002","3","514","525","10.1002/1099-0690(20022)2002:3<514::AID-EJOC514>3.0.CO;2-Z","","","","","","","0.0822","","","0.0822","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1100264","5.753","0.001","8.297","0.001","25.098","0.002","90","","90","","90","","1197.99","","","","213","","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","(-)-(S)-4-Aminophenyl-4-methylphenylsulfoxide","","- C13 H13 N O S -","- C13 H13 N O S -","- C52 H52 N4 O4 S4 -","4","1","","Reichardt, Christian; Erfurt, Hans-Peter; Harms, Klaus; Schäfer, Gerhard","Syntheses, Absolute Configurations, and UV/Vis Spectroscopic Properties of New Chiral Tri- and Pentamethinium Streptocyanine Dyes with 4-Aminophenyl 4-Methylphenyl Sulfoxide Endgroups","European Journal of Organic Chemistry","2002","2002","3","439","452","10.1002/1099-0690(20022)2002:3<439::AID-EJOC439>3.0.CO;2-B","","","","","","","4.79","","","4.79","","","","","","","","","","","has coordinates","176878","2020-10-21","18:00:00",""
"1100265","5.4024","0.0004","16.4819","0.0013","33.13","0.018","90","","91.4","0.02","90","","2949.07","","","","193","","","","","","","","","6","P 1 21 1","P 2yb","4","","(-)-(S,S)-1,3-bis(4-(4-Methylphenylsulfinyl)phenylamino)trimethinium bromide trihydrate","","- C29 H33 Br N2 O5 S2 -","- C29 H31 Br N2 O5 S2 -","- C116 H124 Br4 N8 O20 S8 -","4","2","","Reichardt, Christian; Erfurt, Hans-Peter; Harms, Klaus; Schäfer, Gerhard","Syntheses, Absolute Configurations, and UV/Vis Spectroscopic Properties of New Chiral Tri- and Pentamethinium Streptocyanine Dyes with 4-Aminophenyl 4-Methylphenyl Sulfoxide Endgroups","European Journal of Organic Chemistry","2002","2002","3","439","452","10.1002/1099-0690(20022)2002:3<439::AID-EJOC439>3.0.CO;2-B","","","","","","","4.78","","","4.78","","","","","","","","","","","has coordinates","176878","2020-10-21","18:00:00",""
"1100266","7.9433","0.0016","7.26","0.001","21.921","0.005","90","","92.11","0.03","90","","1263.29","","","","193","","","","","","","","","5","P 1 21 1","P 2yb","4","","(-)-(S,S)-3-(4-(4-Methylphenylsulfinyl)phenylamino)propenal (4-(4-methylphenyl sulfinyl)phenylimine)","","- C29 H26 N2 O2 S2 -","- C29 H32 N2 O2 S2 -","- C58 H64 N4 O4 S4 -","2","1","","Reichardt, Christian; Erfurt, Hans-Peter; Harms, Klaus; Schäfer, Gerhard","Syntheses, Absolute Configurations, and UV/Vis Spectroscopic Properties of New Chiral Tri- and Pentamethinium Streptocyanine Dyes with 4-Aminophenyl 4-Methylphenyl Sulfoxide Endgroups","European Journal of Organic Chemistry","2002","2002","3","439","452","10.1002/1099-0690(20022)2002:3<439::AID-EJOC439>3.0.CO;2-B","","","","","","","5.67","","","5.67","","","","","","","","","","","has coordinates","176878","2020-10-21","18:00:00",""