# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-29T12:00:30+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') AND volume = 2 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
"7203907","6.9104","0.0002","15.8694","0.0005","13.2342","0.0004","90","","103.602","0.002","90","","1410.61","0.07","123","2","123","2","","","","","","","","3","P 1 21/n 1","-P 2yn","14","","","","- C18 H16 O3 -","- C18 H16 O3 -","- C72 H64 O12 -","4","1","","Raston, Colin L.; Scott, Janet L.","Chemoselective, solvent-free aldol condensation reaction","Green Chemistry","2000","2","2","49","","10.1039/a907688c","","","0.71073","MoKα","","0.0844","0.0492","","","0.1063","0.1163","","","","","","1.061","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7203908","7.272","0.0003","7.5704","0.0002","12.3802","0.0004","77.14","0.002","89.263","0.002","69.134","0.002","619.23","0.04","123","2","123","2","","","","","","","","3","P -1","-P 1","2","","","","- C18 H14 O -","- C18 H14 O -","- C36 H28 O2 -","2","1","","Raston, Colin L.; Scott, Janet L.","Chemoselective, solvent-free aldol condensation reaction","Green Chemistry","2000","2","2","49","","10.1039/a907688c","","","0.71073","MoKα","","0.0707","0.0466","","","0.1176","0.1345","","","","","","1.078","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7203909","12.2718","0.0002","7.8706","0.0001","16.1076","0.0003","90","","102.299","0.001","90","","1520.07","0.04","123","2","123","2","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","","","- C21 H20 O -","- C21 H20 O -","- C84 H80 O4 -","4","1","","Raston, Colin L.; Scott, Janet L.","Chemoselective, solvent-free aldol condensation reaction","Green Chemistry","2000","2","2","49","","10.1039/a907688c","","","0.71073","MoKα","","0.0641","0.0448","","","0.1089","0.116","","","","","","1.053","","","","has coordinates","180370","2020-10-21","18:00:00",""
"7203969","14.4429","0.0005","8.0609","0.0003","24.3908","0.0007","90","","99.51","0.002","90","","2800.62","0.16","123","2","123","2","","","","","","","","3","P 1 21/n 1","-P 2yn","14","tris-(O-allyl)CTV","2,7,12,-trimethoxy-3,8,13-tri(prop-1-enoxy)-10,15-dihydro-5H-tribenzo [a,d,g]cyclononene","","- C33 H36 O6 -","- C33 H36 O6 -","- C132 H144 O24 -","4","1","","Scott, Janet L.; MacFarlane, Douglas R.; Raston, Colin L.; Teoh, Ching Mei","Clean, efficient syntheses of cyclotriveratrylene (CTV) and tris-(O-allyl)CTV in an ionic liquid","Green Chemistry","2000","2","4","123","","10.1039/b000825g","","","0.71073","MoKα","","0.136","0.0689","","","0.1581","0.1946","","","","","","1.031","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7204028","5.9637","0.0002","9.123","0.0006","12.0646","0.0007","99.666","0.003","96.329","0.003","95.837","0.003","638.28","0.06","123","2","123","2","","","","","","","","3","P -1","-P 1","2","","","","- C14 H14 O6 -","- C14 H14 O6 -","- C28 H28 O12 -","2","1","","Scott, Janet L.; Raston, Colin L.","Solvent-free synthesis of 3-carboxycoumarins","Green Chemistry","2000","2","5","245","","10.1039/b006704k","","","0.71073","MoKα","","0.0673","0.0437","","","0.0947","0.1038","","","","","","1.037","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7204029","5.11","0.0002","19.5292","0.0004","9.4299","0.0003","90","","99.909","0.002","90","","927.01","0.05","123","2","123","2","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","8-methoxy,3-carboxy-coumarin","","- C11 H8 O5 -","- C11 H7 O5 -","- C44 H28 O20 -","4","1","","Scott, Janet L.; Raston, Colin L.","Solvent-free synthesis of 3-carboxycoumarins","Green Chemistry","2000","2","5","245","","10.1039/b006704k","","","0.71073","MoKα","","0.069","0.0437","","","0.104","0.1157","","","","","","1.037","","","","has coordinates","180371","2020-10-21","18:00:00",""