# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-26T02:01:03+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 'Chemical Communications (Cambridge, United Kingdom)') AND volume = 53 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 "7119524","26.2806","0.0015","10.5229","0.0005","28.8376","0.0016","90","","104.925","0.005","90","","7705.9","0.7","170","","170","","","","","","","","","6","P 1 21/c 1","-P 2ybc","14","","","","- C148 H166 F24 N14 O33 P4 -","- C148 H166 F24 N14 O33 P4 -","- C296 H332 F48 N28 O66 P8 -","2","0.5","","Wei, Peifa; Wang, Haoze; Jie, Kecheng; Huang, Feihe","Taco complex-templated highly regio- and stereo-selective photodimerization of a coumarin-containing crown ether","Chemical Communications (Cambridge, United Kingdom)","2017","53","10","1688","1691","10.1039/c6cc10089a","","","0.71073","MoKα","","0.1202","0.0799","","","0.2039","0.2361","","","","","","1.033","","","","has coordinates","211011","2020-10-21","18:00:00","" "7119525","12.9533","0.0007","13.437","0.0006","26.4914","0.0013","82.573","0.004","79.383","0.005","65.221","0.005","4107.7","0.4","170","","170","","","","","","","","","6","P -1","-P 1","2","","","","- C74 H87 F18 N3 O18 P3 -","- C74 H87 F18 N3 O18 P3 -","- C148 H174 F36 N6 O36 P6 -","2","1","","Wei, Peifa; Wang, Haoze; Jie, Kecheng; Huang, Feihe","Taco complex-templated highly regio- and stereo-selective photodimerization of a coumarin-containing crown ether","Chemical Communications (Cambridge, United Kingdom)","2017","53","10","1688","1691","10.1039/c6cc10089a","","","0.71073","MoKα","","0.2134","0.0994","","","0.2748","0.3594","","","","","","1.025","","","","has coordinates","211011","2020-10-21","18:00:00",""