# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-07-25T00:46:12+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 = 9 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
"7202470","20.45","0.004","7.329","0.002","10.31","0.003","90","","99.28","0.02","90","","1525","0.7","160","2","160","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","","","","- C18 H52 N6 O16 P4 -","- C18 H52 N6 O16 P4 -","- C36 H104 N12 O32 P8 -","2","0.5","","Shastri, Kirtida; Cheng, Eileen W. C.; Motevalli, Majid; Schofield, John; Wilkinson, Jennifer S.; Watkinson, Michael","Investigations into the efficacy of methyhlphosphonic acid functionalised 1,4,7-triazacyclononane ligands in bleaching catalysis","Green Chemistry","2007","9","9","996","","10.1039/b609710c","","","0.71073","MoKα","","0.0928","0.0402","","","0.0944","0.1099","","","","","","1.016","","","","has coordinates","180355","2020-10-21","18:00:00",""
"7202471","7.603","0.0007","9.1105","0.0009","13.0353","0.0015","89.455","0.004","75.731","0.004","86.145","0.006","873.06","0.16","120","2","120","2","","","","","","","","6","P -1","-P 1","2","","","","- C9 H28 Br2 N3 O5 P -","- C9 H28 Br2 N3 O5 P -","- C18 H56 Br4 N6 O10 P2 -","2","1","","Shastri, Kirtida; Cheng, Eileen W. C.; Motevalli, Majid; Schofield, John; Wilkinson, Jennifer S.; Watkinson, Michael","Investigations into the efficacy of methyhlphosphonic acid functionalised 1,4,7-triazacyclononane ligands in bleaching catalysis","Green Chemistry","2007","9","9","996","","10.1039/b609710c","","","0.71073","MoKα","","0.157","0.1243","","","0.3384","0.3619","","","","","","1.087","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202474","6.43","0.004","6.715","0.004","11.544","0.007","87.486","0.012","80.11","0.012","80.82","0.01","484.7","0.5","173","2","173","2","","","","","","","","4","P -1","-P 1","2","2-carboxy-1,3-dimethylimidazolium NO3 H2O","","","- C6 H11 N3 O6 -","- C6 H11 N3 O6 -","- C12 H22 N6 O12 -","2","1","","Smiglak, Marcin; Holbrey, John D.; Griffin, Scott T.; Reichert, W. Matthew; Swatloski, Richard P.; Katritzky, Alan R.; Yang, Hongfang; Zhang, Dazhi; Kirichenko, Kostyantyn; Rogers, Robin D.","Ionic liquids via reaction of the zwitterionic 1,3-dimethylimidazolium-2-carboxylate with protic acids. Overcoming synthetic limitations and establishing new halide free protocols for the formation of ILs","Green Chemistry","2007","9","1","90","","10.1039/b610421e","","","0.71073","MoKα","","0.0928","0.0539","","","0.1394","0.1792","","","","","","1.152","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202475","6.628","0.002","11.91","0.004","11.538","0.004","90","","104.508","0.007","90","","881.8","0.5","173","2","173","2","","","","","","","","4","P 1 21/n 1","-P 2yn","14","4-carboxy-1,3-dimethylimidazolium nitrate","","","- C6 H9 N3 O5 -","- C6 H9 N3 O5 -","- C24 H36 N12 O20 -","4","1","","Smiglak, Marcin; Holbrey, John D.; Griffin, Scott T.; Reichert, W. Matthew; Swatloski, Richard P.; Katritzky, Alan R.; Yang, Hongfang; Zhang, Dazhi; Kirichenko, Kostyantyn; Rogers, Robin D.","Ionic liquids via reaction of the zwitterionic 1,3-dimethylimidazolium-2-carboxylate with protic acids. Overcoming synthetic limitations and establishing new halide free protocols for the formation of ILs","Green Chemistry","2007","9","1","90","","10.1039/b610421e","","","0.71073","MoKα","","0.0625","0.0448","","","0.1004","0.1067","","","","","","1.074","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202477","17.365","0.0017","9.9287","0.001","20.981","0.002","90","","113.4","0.002","90","","3319.9","0.6","297","2","298","2","","","","","","","","3","P 1 21/n 1","-P 2yn","14","","2-phenyl-4-p-toluoyl-3H-benzo-[b]-1,5-diazepine-4- (4-methyl phenyl-3H-benzo-[b]-1,5-diazepine","","- C22 H18 N2 -","- C22 H18 N2 -","- C176 H144 N16 -","8","2","","Palimkar, Sanjay S.; Lahoti, Rajgopal J.; Srinivasan, Kumar V.","A novel one-pot three-component synthesis of 2,4-disubstituted-3 H-benzo[ b][1,4]diazepines in water","Green Chemistry","2007","9","2","146","","10.1039/b610523h","","","0.71073","MoKα","","0.1434","0.0771","","","0.172","0.2059","","","","","","1.042","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202516","9.4031","0.0005","9.3855","0.0005","11.006","0.0006","78.01","0.003","84.307","0.003","82.744","0.003","939.84","0.09","173","2","173","2","","","","","","","","4","P -1","-P 1","2","","","","- C21 H26 N2 O3 -","- C21 H26 N2 O3 -","- C42 H52 N4 O6 -","2","1","","Iván Kanizsai; Szilvia Gyónfalvi; Zsolt Szakonyi; Reijo Sillanpää; Ferenc Fülöp","Synthesis of bi- and tricyclic ?-lactam libraries in aqueous medium","Green Chemistry","2007","9","4","357","","10.1039/b613117d","","x-ray","0.71073","MoKα","","0.1134","0.0655","","","0.111","0.1304","","","","","","1.058","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202585","7.1563","0.001","13.1156","0.0015","27.469","0.003","90","","90","","90","","2578.2","0.5","293","2","293","2","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","(1R,2R)-1,3-dihydroxy-N,N-dimethyl-1-(4- (methylthio)phenyl)propan-2-aminium (1R,3R)-2,2-dimethyl-3-(2- methylprop-1-enyl)-cyclopropanecarboxylate, methanol solvated","(1R,2R)-1,3-dihydroxy-N,N-dimethyl-1-[4-(methylthio)phenyl]propan- 2-aminium (1R,3R)-2,2-dimethyl-3-(2-methylprop-1-enyl)- cyclopropanecarboxylate, methanol solvated","","- C23 H39 N O5 S -","- C23 H39 N O5 S -","- C92 H156 N4 O20 S4 -","4","1","","Rosini, Goffredo; Ayoub, Claudia; Borzatta, Valerio; Marotta, Emanuela; Mazzanti, Andrea; Righi, Paolo","The same and not the same. Similarities and differences in the resolution of trans-chrysanthemic acid of industrial origin by the enantiomers of some threo-1-aryl-2-dimethylamino-1,3-propanediols","Green Chemistry","2007","9","5","441","","10.1039/b615785h","","","0.71073","MoKα","","0.056","0.047","","","0.1345","0.1434","","","","","","1.026","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202586","9.994","0.0005","7.8004","0.0004","15.8597","0.0008","90","","106.301","0.001","90","","1186.68","0.1","293","2","293","2","","","","","","","","5","P 1 21 1","P 2yb","4","(1R,2R)-1,3-dihydroxy-N,N-dimethyl-1-(4- (methylthio)phenyl)propan-2-aminium (1R,3R)-2,2-dimethyl-3-(2- methylprop-1-enyl)-cyclopropanecarboxylate","(1R,2R)-1,3-dihydroxy-N,N-dimethyl-1-[4-(methylthio)phenyl]propan- 2-aminium (1R,3R)-2,2-dimethyl-3-(2-methylprop-1-enyl)- cyclopropanecarboxylate","","- C22 H35 N O4 S -","- C22 H35 N O4 S -","- C44 H70 N2 O8 S2 -","2","1","","Rosini, Goffredo; Ayoub, Claudia; Borzatta, Valerio; Marotta, Emanuela; Mazzanti, Andrea; Righi, Paolo","The same and not the same. Similarities and differences in the resolution of trans-chrysanthemic acid of industrial origin by the enantiomers of some threo-1-aryl-2-dimethylamino-1,3-propanediols","Green Chemistry","2007","9","5","441","","10.1039/b615785h","","","0.71073","MoKα","","0.0567","0.0528","","","0.1548","0.1599","","","","","","1.089","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202699","11.6255","0.0013","15.2552","0.0017","15.2882","0.0018","90","","92.341","0.002","90","","2709.1","0.5","294","2","294","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","","Tetra-(n-butylpyridinium) Octamolybdate","","- C36 H56 Mo8 N4 O26 -","- C36 H56 Mo8 N4 O26 -","- C72 H112 Mo16 N8 O52 -","2","0.5","","Ming-Lin, Guo; Hui-Zhen, Li","Selective oxidation of benzyl alcohol to benzaldehyde with hydrogen peroxide over tetra-alkylpyridinium octamolybdate catalysts","Green Chemistry","2007","9","5","421","","10.1039/b700534b","","","0.71073","MoKα","","0.0527","0.0446","","","0.1247","0.1319","","","","","","1.088","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202710","25.39","0.006","5.557","0.002","13.342","0.001","90","","93.826","0.014","90","","1878.3","0.8","100","2","100","2","","","","","","","","4","C 1 2 1","C 2y","5","","","","- C23 H20 N3 O0.5 -","- C23 H19 N3 O0.5 -","- C92 H76 N12 O2 -","4","1","","Smith, Nicole M.; Raston, Colin L.; Smith, Christopher B.; Sobolev, Alexandre N.","PEG mediated synthesis of amino-functionalised 2,4,6-triarylpyridines","Green Chemistry","2007","9","11","1185","","10.1039/b700893g","","","0.71073","MoKα","","0.1599","0.0905","","","0.2019","0.2378","","","","","","1.005","","","","has coordinates","180358","2020-10-21","18:00:00",""
"7202843","8.5166","0.0014","10.879","0.0018","16.006","0.003","90","","103","0.003","90","","1445","0.4","100","2","100","2","","","","","","","","6","P 1 21/n 1","-P 2yn","14","3-methyl-1-(tetrahydro-2H-pyran-2-ylmethyl)-1H-imidazol-3-ium trifluoromethanesulfonate","","","- C11 H17 F3 N2 O4 S -","- C11 H17 F3 N2 O4 S -","- C44 H68 F12 N8 O16 S4 -","4","1","","Leclercq, Loïc; Suisse, Isabelle; Nowogrocki, Guy; Agbossou-Niedercorn, Francine","Halide-free highly-pure imidazolium triflate ionic liquids: Preparation and use in palladium-catalysed allylic alkylation","Green Chemistry","2007","9","10","1097","","10.1039/b703096g","","","0.71073","MoKα","","0.0394","0.035","","","0.0933","0.0968","","","","","","1.07","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202844","8.6516","0.0015","10.1699","0.0017","12.195","0.002","87.354","0.003","85.474","0.003","83.36","0.003","1061.7","0.3","100","2","100","2","","","","","","","","6","P -1","-P 1","2","3-methyl-1-(4-(1-methyl-1H-imidazol-3-ium-3-yl)butyl)-1H- imidazol-3-ium bis(trifluoromethanesulfonate)","","","- C14 H20 F6 N4 O6 S2 -","- C14 H20 F6 N4 O6 S2 -","- C28 H40 F12 N8 O12 S4 -","2","1","","Leclercq, Loïc; Suisse, Isabelle; Nowogrocki, Guy; Agbossou-Niedercorn, Francine","Halide-free highly-pure imidazolium triflate ionic liquids: Preparation and use in palladium-catalysed allylic alkylation","Green Chemistry","2007","9","10","1097","","10.1039/b703096g","","","0.71073","MoKα","","0.0394","0.0341","","","0.089","0.0927","","","","","","1.05","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202845","9.5883","0.0013","9.7729","0.0013","19.198","0.003","85.627","0.002","88.693","0.002","88.563","0.002","1792.8","0.4","100","2","100","2","","","","","","","","6","P -1","-P 1","2","1-methyl-3-(tetrahydrofuran-3-ylmethyl)-1H-imidazol-3-ium trifluoromethanesulfonate / tetrabuthylammonium trifluoromethanesulfonate","","","- C27 H51 F6 N3 O7 S2 -","- C27 H51 F6 N3 O7 S2 -","- C54 H102 F12 N6 O14 S4 -","2","1","","Leclercq, Loïc; Suisse, Isabelle; Nowogrocki, Guy; Agbossou-Niedercorn, Francine","Halide-free highly-pure imidazolium triflate ionic liquids: Preparation and use in palladium-catalysed allylic alkylation","Green Chemistry","2007","9","10","1097","","10.1039/b703096g","","","0.71073","MoKα","","0.0786","0.0578","","","0.157","0.1722","","","","","","1.124","","","","has coordinates","301863","2025-08-22","13:06:28",""
"7202913","16.035","0.005","19.797","0.005","24.936","0.005","90","0.005","104.979","0.005","90","0.005","7647","3","110","2","110","2","","","","","","","","4","P 1 21/n 1","-P 2yn","14","","","","- C79 H122 Na2 O7 -","- C79 H122 Na2 O7 -","- C316 H488 Na8 O28 -","4","1","","Chen, Hsuan-Ying; Zhang, Jubo; Lin, Chu-Chieh; Reibenspies, Joseph H.; Miller, Stephen A.","Efficient and controlled polymerization of lactide under mild conditions with a sodium-based catalyst","Green Chemistry","2007","9","10","1038","","10.1039/b705622b","","","0.71073","MoKα","","0.0806","0.0631","","","0.1693","0.1963","","","","","","1.099","","","","has coordinates,has disorder","180360","2020-10-21","18:00:00",""
"7202999","8.952","0.002","10.126","0.003","14.757","0.004","70.511","0.01","79.526","0.01","76.96","0.01","1220.2","0.6","100","2","100","2","","","","","","","","3","P -1","-P 1","2","","","","- C14 H20 N2 -","- C14 H20 N2 -","- C56 H80 N8 -","4","2","","Waldemar M. Czaplik; Jörg-M. Neudörfl; Axel Jacobi von Wangelin","On the quantitative recycling of Raney–Nickel catalysts on a lab-scale","Green Chemistry","2007","9","11","1163","","10.1039/b708057c","","","0.71073","MoKα","","0.2461","0.0879","","","0.2204","0.2937","","","","","","0.978","","","","has coordinates","301863","2025-08-22","13:06:29",""
"7203081","9.955","0.009","10.404","0.009","10.839","0.009","97.689","0.009","98.771","0.007","111.382","0.016","1011","1.5","113","2","113","2","","","","","","","","5","P -1","-P 1","2","","","","- C16 H27 N O7 P2 -","- C16 H27 N O7 P2 -","- C32 H54 N2 O14 P4 -","2","1","","Zhang, Jianfeng; Cui, Zhanwei; Wang, Fei; Wang, Yadan; Miao, Zhiwei; Chen, Ruyu","Mannich type reactions of chlorophosphites, phosphoramides and aldehydes (ketones) under solvent-free and catalyst-free conditions—synthesis of N-phosphoramino α-aminophosphonates","Green Chemistry","2007","9","12","1341","","10.1039/b710008f","","","0.7107","MoKα","","0.0725","0.0574","","","0.1303","0.1388","","","","","","1.123","","","","has coordinates","301863","2025-08-22","13:06:29",""