# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-10-18T10:42:22+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 'Organic chemistry frontiers : an international journal of organic chemistry') AND volume = 3 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
"4036721","9.0188","0.0008","21.1444","0.0019","10.7833","0.0009","90","","111.097","0.002","90","","1918.5","0.3","110","2","110","2","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C42 H50 N4 O6 -","- C42 H50 N4 O6 -","- C84 H100 N8 O12 -","2","1","","Fang, Lixia; Lv, Caixia; Wang, Guo; Feng, Lei; Stavropoulos, Pericles; Gao, Guangpeng; Ai, Lin; Zhang, Jiaxin","Discrimination of Enantiomers of Dipeptide Derivatives with Two Chiral Centers by Tetraaza Macrocyclic Chiral Solvating Agents Using <sup>1</sup>H NMR Spectroscopy.","Organic chemistry frontiers : an international journal of organic chemistry","2016","3","12","1716","1724","10.1039/C6QO00521G","","","0.71073","MoKα","","0.0419","0.0357","","","0.0756","0.0789","","","","","","1.025","","","","has coordinates","235132","2020-10-21","18:00:00",""
"4036722","37.839","0.004","25.19","0.002","13.63","0.0014","90","","101.307","0.002","90","","12739","2","110","2","110","2","","","","","","","","5","C 1 2 1","C 2y","5","","","","- C36 H36 Cl2 N4 O4 -","- C36 H36 Cl2 N4 O4 -","- C432 H432 Cl24 N48 O48 -","12","3","","Fang, Lixia; Lv, Caixia; Wang, Guo; Feng, Lei; Stavropoulos, Pericles; Gao, Guangpeng; Ai, Lin; Zhang, Jiaxin","Discrimination of Enantiomers of Dipeptide Derivatives with Two Chiral Centers by Tetraaza Macrocyclic Chiral Solvating Agents Using <sup>1</sup>H NMR Spectroscopy.","Organic chemistry frontiers : an international journal of organic chemistry","2016","3","12","1716","1724","10.1039/C6QO00521G","","","0.71073","MoKα","","0.0858","0.0668","","","0.1739","0.1865","","","","","","1.011","","","","has coordinates,has disorder","235132","2020-10-21","18:00:00",""
"4036723","13.811","0.003","13.811","0.003","20.076","0.004","90","","90","","90","","3829.4","1.4","100","2","100","2","","","","","","","","7","P 43","P 4cw","78","","","","- C37 H36 Br2 Cl3 D N4 O4 -","- C37 H36 Br2 Cl3 D N4 O4 -","- C148 H144 Br8 Cl12 D4 N16 O16 -","4","1","","Fang, Lixia; Lv, Caixia; Wang, Guo; Feng, Lei; Stavropoulos, Pericles; Gao, Guangpeng; Ai, Lin; Zhang, Jiaxin","Discrimination of Enantiomers of Dipeptide Derivatives with Two Chiral Centers by Tetraaza Macrocyclic Chiral Solvating Agents Using <sup>1</sup>H NMR Spectroscopy.","Organic chemistry frontiers : an international journal of organic chemistry","2016","3","12","1716","1724","10.1039/C6QO00521G","","","0.71073","MoKα","","0.0397","0.0317","","","0.0679","0.0706","","","","","","1.027","","","","has coordinates","235132","2020-10-21","18:00:00",""