# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-06T00:27:41+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 'Green chemistry : an international journal and green chemistry resource : GC') AND volume = 25 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 "7247295","5.8474","0.0004","9.4994","0.0005","11.3086","0.0006","107.71","0.004","98.149","0.004","105.204","0.004","560.43","0.06","150","2","150","2","","","","","","","","4","P -1","-P 1","2","","","","- C11 H13 Br O3 -","- C11 H13 Br O3 -","- C22 H26 Br2 O6 -","2","1","","Cioc, Răzvan C; Harsevoort, Eva; Lutz, Martin; Bruijnincx, Pieter C. A.","Efficient synthesis of fully renewable, furfural-derived building blocks via formal Diels-Alder cycloaddition of atypical addends.","Green chemistry : an international journal and green chemistry resource : GC","2023","25","23","9689","9694","10.1039/d3gc02357e","","","0.71073","MoKα","","0.0276","0.024","","","0.061","0.0622","","","","","","1.064","","","","has coordinates","288824","2024-01-06","08:25:16","" "7247296","10.0582","0.0005","10.1124","0.0006","7.03","0.0003","90","","90.351","0.003","90","","715.03","0.06","150","2","150","2","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","","","- C8 H10 O3 -","- C8 H10 O3 -","- C32 H40 O12 -","4","1","","Cioc, Răzvan C; Harsevoort, Eva; Lutz, Martin; Bruijnincx, Pieter C. A.","Efficient synthesis of fully renewable, furfural-derived building blocks via formal Diels-Alder cycloaddition of atypical addends.","Green chemistry : an international journal and green chemistry resource : GC","2023","25","23","9689","9694","10.1039/d3gc02357e","","","0.71073","MoKα","","0.0427","0.0351","","","0.0933","0.0981","","","","","","1.064","","","","has coordinates","288824","2024-01-06","08:25:18",""