# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-26T18:06:11+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 = 11 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
"7200176","9.896","0.002","10.256","0.002","11.128","0.002","89.64","0.03","73.71","0.03","82.42","0.03","1074","0.4","293","2","293","2","","","","","","","","7","P -1","-P 1","2","","","","- C22 H13 Cl2 F N2 O S2 -","- C22 H13 Cl2 F N2 O S2 -","- C44 H26 Cl4 F2 N4 O2 S4 -","2","1","","Jian, Fangfang; Zheng, Jian; Li, Yufeng; Wang, Jing","Novel ((3Z,5Z)-3,5-bis(phenylimino)-1,2-dithiolan-4-yl) and 3H-[1,2]dithiolo[3,4-b]quinolin-4(9H)-one heterocycles: an effective and facile green route","Green Chemistry","2009","11","2","215","","10.1039/b808949c","","","0.71073","MoKα","","0.0736","0.0482","","","0.1297","0.1461","","","","","","1.034","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7200177","6.3729","0.0013","12.941","0.003","13.413","0.003","108.64","0.03","96.27","0.03","96.96","0.03","1027.5","0.5","293","2","293","2","","","","","","","","6","P -1","-P 1","2","","","","- C23 H17 Br N2 O S2 -","- C23 H17 Br N2 O S2 -","- C46 H34 Br2 N4 O2 S4 -","2","1","","Jian, Fangfang; Zheng, Jian; Li, Yufeng; Wang, Jing","Novel ((3Z,5Z)-3,5-bis(phenylimino)-1,2-dithiolan-4-yl) and 3H-[1,2]dithiolo[3,4-b]quinolin-4(9H)-one heterocycles: an effective and facile green route","Green Chemistry","2009","11","2","215","","10.1039/b808949c","","","0.71073","MoKα","","0.1315","0.0945","","","0.2769","0.3118","","","","","","1.042","","","","has coordinates,has disorder","180332","2020-10-21","18:00:00",""
"7200178","11.497","0.002","7.537","0.0015","22.384","0.005","90","","103.64","0.03","90","","1884.9","0.7","293","2","293","2","","","","","","","","6","P 1 21/c 1","-P 2ybc","14","","","","- C22 H13 Cl N2 O S2 -","- C22 H13 Cl N2 O S2 -","- C88 H52 Cl4 N8 O4 S8 -","4","1","","Jian, Fangfang; Zheng, Jian; Li, Yufeng; Wang, Jing","Novel ((3Z,5Z)-3,5-bis(phenylimino)-1,2-dithiolan-4-yl) and 3H-[1,2]dithiolo[3,4-b]quinolin-4(9H)-one heterocycles: an effective and facile green route","Green Chemistry","2009","11","2","215","","10.1039/b808949c","","","0.71073","MoKα","","0.1159","0.0536","","","0.1404","0.17","","","","","","1.013","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7200179","10.084","0.002","10.331","0.002","10.414","0.002","87.6","0.03","85.58","0.03","78.1","0.03","1058.1","0.4","293","2","293","2","","","","","","","","6","P -1","-P 1","2","","","","- C22 H14 Cl2 N2 O S2 -","- C22 H14 Cl2 N2 O S2 -","- C44 H28 Cl4 N4 O2 S4 -","2","1","","Jian, Fangfang; Zheng, Jian; Li, Yufeng; Wang, Jing","Novel ((3Z,5Z)-3,5-bis(phenylimino)-1,2-dithiolan-4-yl) and 3H-[1,2]dithiolo[3,4-b]quinolin-4(9H)-one heterocycles: an effective and facile green route","Green Chemistry","2009","11","2","215","","10.1039/b808949c","","","0.71073","MoKα","","0.1616","0.0668","","","0.1577","0.2053","","","","","","0.965","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7200280","17.1392","0.0005","6.0512","0.0002","10.9857","0.0004","90","","93.007","0.002","90","","1137.79","0.07","296","2","296","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C11 H13 N O3 S -","- C11 H13 N O3 S -","- C44 H52 N4 O12 S4 -","4","1","","Hota, Sandip K.; Chatterjee, Amrita; Bhattacharya, Pranab K.; Chattopadhyay, Partha","A green chemical approach for the N-alkylation of aldoximes to form nitrones in organized aqueous media and their in situ cycloaddition with olefins","Green Chemistry","2009","11","2","169","","10.1039/b812290c","","","0.71073","MoKα","","0.0681","0.0456","","","0.15","0.1748","","","","","","1.241","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7200610","8.77","0.008","9.766","0.009","14.282","0.012","90","","95.363","0.012","90","","1217.9","1.9","293","2","293","2","","","","","","","","6","P 1 21/n 1","-P 2yn","14","","","","- C8 H12 F4 N2 O3 S -","- C8 H12 F4 N2 O3 S -","- C32 H48 F16 N8 O12 S4 -","4","1","","Harmer, Mark A.; Junk, Christopher P.; Rostovtsev, Vsevolod V.; Marshall, William J.; Grieco, Liane M.; Vickery, Jemma; Miller, Robert; Work, Stella","Catalytic reactions using superacids in new types of ionic liquids","Green Chemistry","2009","11","4","517","","10.1039/b818788f","","","0.71073","MoKα","","0.0489","0.0417","","","0.1166","0.1231","","","","","","1.078","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7200611","9.178","0.004","34.444","0.013","10.022","0.004","90","","91.711","0.007","90","","3167","2","293","2","293","2","","","","","","","","6","P 1 21/c 1","-P 2ybc","14","","","","- C10 H11 F9 N2 O3 S -","- C10 H11 F9 N2 O3 S -","- C80 H88 F72 N16 O24 S8 -","8","2","","Harmer, Mark A.; Junk, Christopher P.; Rostovtsev, Vsevolod V.; Marshall, William J.; Grieco, Liane M.; Vickery, Jemma; Miller, Robert; Work, Stella","Catalytic reactions using superacids in new types of ionic liquids","Green Chemistry","2009","11","4","517","","10.1039/b818788f","","","0.71073","MoKα","","0.1705","0.0916","","","0.2183","0.258","","","","","","1.07","","","","has coordinates","180337","2020-10-21","18:00:00",""
"7201002","8.655","0.002","9.619","0.003","10.727","0.003","83.143","0.005","72.938","0.004","64.907","0.004","773.2","0.4","296","2","296","2","","","","","","","","5","P -1","-P 1","2","oxazinoquinoline","","","- C19 H13 N O2 S2 -","- C19 H13 N O2 S2 -","- C38 H26 N2 O4 S4 -","2","1","","Saha, Pritam; Naskar, Subhendu; Paira, Priyankar; Hazra, Abhijit; Sahu, Krishnendu B.; Paira, Rupankar; Banerjee, Sukdeb; Mondal, Nirup B.","Basic alumina-supported highly effective Suzuki‒Miyaura cross-coupling reaction under microwave irradiation: application to fused tricyclic oxa-aza-quinolones","Green Chemistry","2009","11","7","931","","10.1039/b902916h","","","0.71073","MoKα","","0.0676","0.0481","","","0.1288","0.1416","","","","","","1.085","","","","has coordinates,has disorder","180341","2020-10-21","18:00:00",""
"7201048","11.3034","0.0011","13.2485","0.0013","8.9142","0.0009","90","","97.277","0.002","90","","1324.2","0.2","293","2","293","2","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","N-Benzyl-1H-indole-1-carboxamide","N-Benzyl-1H-indole-1-carboxamide","","- C16 H14 N2 O -","- C16 H14 N2 O -","- C64 H56 N8 O4 -","4","1","","Ye, Deju; Wang, Jinfang; Zhang, Xu; Zhou, Yu; Ding, Xiao; Feng, Enguang; Sun, Haifeng; Liu, Guannan; Jiang, Hualiang; Liu, Hong","Gold-catalyzed intramolecular hydroamination of terminal alkynes in aqueous media: efficient and regioselective synthesis of indole-1-carboxamides","Green Chemistry","2009","11","8","1201","","10.1039/b904044g","","","0.71073","MoKα","","0.1036","0.0538","","","0.1006","0.1181","","","","","","0.878","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7201240","7.3084","0.0015","10.576","0.002","8.5363","0.0017","90","","102.7","0.03","90","","643.7","0.2","150","0.2","150","0.2","","","","","","","","5","P 1 21/m 1","-P 2yb","11","N/A","","","- C11 H17 Cl2 N Ti -","- C11 H18 Cl2 N Ti -","- C22 H36 Cl4 N2 Ti2 -","2","0.5","","Fletcher, Andrew E.D.; Hyatt, Jonathan D.; Ok, Kang Min; O'Hare, Dermot","Catalytic dechlorination of polychlorinated biphenyls (PCBs) using amine functionalised titanocenes","Green Chemistry","2009","11","9","1343","","10.1039/b906311k","","","0.71073","MoKα","","0.0477","0.0393","","","0.0975","0.1042","","","","","","1.074","","","","has coordinates,has disorder","180343","2020-10-21","18:00:00",""
"7201469","6.985","0.0006","7.315","0.0006","16.94","0.0016","80.825","0.004","81.027","0.004","63.636","0.005","762.05","0.12","150","2","150","2","","","","","","","synthesis","6","P -1","-P 1","2","","","","- C11 H19 Cl2 O5 P Ru -","- C11 H19 Cl2 O5 P Ru -","- C22 H38 Cl4 O10 P2 Ru2 -","2","1","","Lastra-Barreira, Beatriz; Díez, Josefina; Crochet, Pascale","Highly water-soluble arene-ruthenium(ii) complexes: application to catalytic isomerization of allylic alcohols in aqueous medium","Green Chemistry","2009","11","10","1681","","10.1039/b914789f","","","0.71073","MoKα","","0.046","0.0364","","","0.0948","0.0991","","","","","","0.996","","","","has coordinates","180345","2020-10-21","18:00:00",""
"7201470","7.6034","0.0001","14.0769","0.0002","18.318","0.0003","90","","109.371","0.001","90","","1849.63","0.05","150","2","150","2","","","","","","","synthesis","6","P 1 21/c 1","-P 2ybc","14","","","","- C14 H25 Cl2 O5 P Ru -","- C14 H25 Cl2 O5 P Ru -","- C56 H100 Cl8 O20 P4 Ru4 -","4","1","","Lastra-Barreira, Beatriz; Díez, Josefina; Crochet, Pascale","Highly water-soluble arene-ruthenium(ii) complexes: application to catalytic isomerization of allylic alcohols in aqueous medium","Green Chemistry","2009","11","10","1681","","10.1039/b914789f","","","0.71073","MoKα","","0.0381","0.0308","","","0.0871","0.1175","","","","","","1.318","","","","has coordinates","180345","2020-10-21","18:00:00",""
"7201477","8.133","0.0002","10.9315","0.0003","11.3491","0.0004","111.001","0.001","103.328","0.002","103.603","0.003","858.68","0.05","293","2","293","2","","","","","","","synthesis as described","6","P -1","-P 1","2","","","","- C18 H16 F N O2 S2 -","- C18 H16 F N O2 S2 -","- C36 H32 F2 N2 O4 S4 -","2","1","","Cohen, Anita; Crozet, Maxime D.; Rathelot, Pascal; Vanelle, Patrice","An efficient aqueous microwave-assisted Suzuki‒Miyaura cross-coupling reaction in the thiazole series","Green Chemistry","2009","11","11","1736","","10.1039/b916123f","","x-ray","0.71073","MoKα","","0.1008","0.0772","","","0.2084","0.2201","","","","","","1.098","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7201484","7.6593","0.0007","12.5747","0.0011","20.4376","0.0018","90","","90","","90","","1968.4","0.3","293","2","293","2","","","","","","","","6","P 21 21 21","P 2ac 2ab","19","","","","- C15 H31 F3 N2 O3 S -","- C15 H31 F3 N2 O3 S -","- C60 H124 F12 N8 O12 S4 -","4","1","","Lin, Jin-Hong; Zhang, Cheng-Pan; Xiao, Ji-Chang","Enantioselective aldol reaction of cyclic ketones with aryl aldehydes catalyzed by a cyclohexanediamine derived salt in the presence of water","Green Chemistry","2009","11","11","1750","","10.1039/b916583e","","","0.71073","MoKα","","0.0521","0.0451","","","0.1018","0.1048","","","","","","0.986","","","","has coordinates","202017","2020-10-21","18:00:00",""