# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T16:53:29+01: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 Inorganic Biochemistry') AND volume = 212 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 "3000220","14.3058","0.0009","7.1686","0.0004","30.771","0.002","90","","90","","90","","3155.6","0.3","100","2","100","2","","","","","","","","4","P b c a","-P 2ac 2ab","61","","","","- C6 H9 N5 O -","- C6 H9 N5 O -","- C96 H144 N80 O16 -","16","2","","Gines M. Esteban-Parra; Eider San Sebastián; Javier Cepeda; Cristina Sánchez-González; Lorenzo Rivas; Juan Llopis; Pilar Aranda; Miguel Quirós; Antonio Rodríguez-Diéguez","Anti-diabetic and anti-parasitic properties of a family of luminescent zinc coordination compounds based on the 7-amino-5-methyl-1,2,4-triazolo[1,5-a]pyrimidine ligand","Journal of Inorganic Biochemistry","2020","212","","111235","","10.1016/j.jinorgbio.2020.111235","","","0.71069","MoKα","","0.0603","0.0453","","","0.1031","0.1099","","","","","","1.089","","","","has coordinates,has disorder,has Fobs","274292","2022-04-04","05:56:25","" "3000221","14.9427","0.0006","7.5063","0.0003","15.7715","0.0006","90","","107.883","0.0013","90","","1683.53","0.12","100","2","100","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C12 H14 Cl2 N10 Zn -","- C12 H14 Cl2 N10 Zn -","- C48 H56 Cl8 N40 Zn4 -","4","1","","Gines M. Esteban-Parra; Eider San Sebastián; Javier Cepeda; Cristina Sánchez-González; Lorenzo Rivas; Juan Llopis; Pilar Aranda; Miguel Quirós; Antonio Rodríguez-Diéguez","Anti-diabetic and anti-parasitic properties of a family of luminescent zinc coordination compounds based on the 7-amino-5-methyl-1,2,4-triazolo[1,5-a]pyrimidine ligand","Journal of Inorganic Biochemistry","2020","212","","111235","","10.1016/j.jinorgbio.2020.111235","","","0.71069","MoKα","","0.0396","0.0302","","","0.0715","0.0778","","","","","","1.11","","","","has coordinates,has Fobs","274293","2022-04-04","05:59:39","" "3000222","7.1837","0.0005","11.4156","0.0009","12.8451","0.001","80.763","0.003","82.269","0.003","77.782","0.003","1010.63","0.13","100","2","100","2","","","","","","","","5","P -1","-P 1","2","","","","- C24 H48 N22 O16 Zn -","- C24 H48 N22 O16 Zn -","- C24 H48 N22 O16 Zn -","1","0.5","","Gines M. Esteban-Parra; Eider San Sebastián; Javier Cepeda; Cristina Sánchez-González; Lorenzo Rivas; Juan Llopis; Pilar Aranda; Miguel Quirós; Antonio Rodríguez-Diéguez","Anti-diabetic and anti-parasitic properties of a family of luminescent zinc coordination compounds based on the 7-amino-5-methyl-1,2,4-triazolo[1,5-a]pyrimidine ligand","Journal of Inorganic Biochemistry","2020","212","","111235","","10.1016/j.jinorgbio.2020.111235","","","0.71069","MoKα","","0.0462","0.0363","","","0.0919","0.0988","","","","","","0.924","","","","has coordinates,has Fobs","274294","2022-04-04","06:01:49","" "3000223","8.0644","0.0006","11.9048","0.001","12.3145","0.001","71.664","0.003","74.549","0.003","76.161","0.003","1065.96","0.15","100","2","100","2","","","","","","","","6","P -1","-P 1","2","","","","- C12 H25 N10 O9.5 S Zn -","- C12 H20 N10 O9.5 S Zn -","- C24 H40 N20 O19 S2 Zn2 -","2","1","","Gines M. Esteban-Parra; Eider San Sebastián; Javier Cepeda; Cristina Sánchez-González; Lorenzo Rivas; Juan Llopis; Pilar Aranda; Miguel Quirós; Antonio Rodríguez-Diéguez","Anti-diabetic and anti-parasitic properties of a family of luminescent zinc coordination compounds based on the 7-amino-5-methyl-1,2,4-triazolo[1,5-a]pyrimidine ligand","Journal of Inorganic Biochemistry","2020","212","","111235","","10.1016/j.jinorgbio.2020.111235","","","0.71073","MoKα","","0.0467","0.039","","","0.0962","0.1021","","","","","","0.935","","","","has coordinates,has disorder,has Fobs","274295","2022-04-04","06:03:53",""