# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-29T16:08:57+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 'Comptes Rendus Chimie') AND volume = 22 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 "1566108","8.431","0.003","12.696","0.004","21.701","0.007","85.465","0.007","84.808","0.006","82.95","0.007","2290.4","1.3","173","2","173","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H22 N4 O8 Zn -","- C22 H14 N4 O8 Zn -","- C88 H56 N16 O32 Zn4 -","4","2","","Tella, Adedibu C.; Obaleye, Joshua A.; Olawale, Margaret D.; Vianney Ngororabanga, Jean Marie; Ogunlaja, Adeniyi S.; Bourne, Susan A.","Synthesis, crystal structure, and density functional theory study of a zinc(II) complex containing terpyridine and pyridine-2,6-dicarboxylic acid ligands: Analysis of the interactions with amoxicillin","Comptes Rendus Chimie","2019","22","1","3","12","10.1016/j.crci.2018.11.007","","","0.71073","MoKα","","0.1011","0.0554","","","0.1292","0.1527","","","","","","1.034","","","","has coordinates","272209","2022-01-24","08:35:26",""