# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-01T02:08:42+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 'Journal of Combinatorial Chemistry') AND volume = 8 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
"1505676","4.945","0.001","10.887","0.002","18.475","0.004","90","","96.32","0.03","90","","988.6","0.3","173","2","173","2","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","","","","- C10 H8 N2 O4 -","- C10 H8 N2 O4 -","- C40 H32 N8 O16 -","4","1","","Harju, Kirsi; Kylänlahti, Irene; Paananen, Timo; Polamo, Mika; Nielsen, John; Yli-Kauhaluoma, Jari","Solid-Phase Synthesis of Pyrazolopyridines from Polymer-Bound Alkyne and Azomethine Imines","Journal of Combinatorial Chemistry","2006","8","3","344","","10.1021/cc050138j","","","0.71073","MoKα","","0.0885","0.0641","","","0.1878","0.1983","","","","","","1.178","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1505677","5.888","0.0012","10.699","0.003","17.013","0.002","90","","90","","90","","1071.7","0.4","173","2","173","2","","","","","","","","3","P 21 21 21","P 2ac 2ab","19","","","","- C14 H12 N2 -","- C14 H12 N2 -","- C56 H48 N8 -","4","1","","Harju, Kirsi; Kylänlahti, Irene; Paananen, Timo; Polamo, Mika; Nielsen, John; Yli-Kauhaluoma, Jari","Solid-Phase Synthesis of Pyrazolopyridines from Polymer-Bound Alkyne and Azomethine Imines","Journal of Combinatorial Chemistry","2006","8","3","344","","10.1021/cc050138j","","","0.71073","MoKα","","0.0461","0.0363","","","0.0844","0.0874","","","","","","1.139","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1505678","11.654","0.005","5.471","0.002","26.609","0.01","90","","102.416","0.006","90","","1656.9","1.1","208","2","208","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C21 H16 F N3 O2 -","- C21 H16 F N3 O2 -","- C84 H64 F4 N12 O8 -","4","1","","Nie, Aihua; Huang, Ziwei","Microwave-Assisted Reaction of 2‘-Hydroxychalcones with Hydrazides to Synthesize Flavanone Hydrazone and 4,5-Dihydropyrazole Derivatives","Journal of Combinatorial Chemistry","2006","8","5","655","","10.1021/cc060085l","","","0.71073","MoKα","","0.0695","0.0505","","","0.1191","0.1279","","","","","","1.049","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1505679","9.705","0.001","5.644","0.0006","15.603","0.0016","90","","98.293","0.002","90","","845.72","0.15","100","2","100","2","","","","","","","","5","P 1 n 1","P -2yac","7","","","","- C21 H16 F N3 O2 -","- C21 H16 F N3 O2 -","- C42 H32 F2 N6 O4 -","2","1","","Nie, Aihua; Huang, Ziwei","Microwave-Assisted Reaction of 2‘-Hydroxychalcones with Hydrazides to Synthesize Flavanone Hydrazone and 4,5-Dihydropyrazole Derivatives","Journal of Combinatorial Chemistry","2006","8","5","655","","10.1021/cc060085l","","","0.71073","MoKα","","0.0285","0.0284","","","0.0723","0.0723","","","","","","1.077","","","","has coordinates","176729","2020-10-21","18:00:00",""