# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-19T14:23:25+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 'Polyhedron') AND volume = 28 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 "1500031","8.4735","0.0006","9.1517","0.0007","10.25","0.0008","89.138","0.001","88.455","0.001","64.069","0.001","714.57","0.09","298","2","298","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H30 Mn N12 O8 -","- C22 H30 Mn N12 O8 -","- C22 H30 Mn N12 O8 -","1","0.5","","Carmen R. Maldonado; Miguel Quirós; Juan M. Salas","","Polyhedron","2009","28","","911","916","10.1016/j.poly.2009.01.037","","","0.71073","MoKα","","0.0379","0.0354","","","0.0985","0.1007","","","","","","1.011","","","","has coordinates","176729","2020-10-21","18:00:00","" "1500032","8.4326","0.0005","9.0674","0.0005","10.2434","0.0006","89.034","0.001","88.769","0.001","63.924","0.001","703.32","0.07","298","2","298","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H30 Co N12 O8 -","- C22 H30 Co N12 O8 -","- C22 H30 Co N12 O8 -","1","0.5","","Carmen R. Maldonado; Miguel Quirós; Juan M. Salas","","Polyhedron","2009","28","","911","916","10.1016/j.poly.2009.01.037","","","0.71073","MoKα","","0.033","0.0316","","","0.0885","0.0895","","","","","","1.156","","","","has coordinates","176729","2020-10-21","18:00:00","" "1500033","8.4471","0.0004","8.6061","0.0004","11.4137","0.0006","83.422","0.001","69.44","0.001","61.375","0.001","680.47","0.06","100","2","100","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H30 N12 Ni O8 -","- C22 H30 N12 Ni O8 -","- C22 H30 N12 Ni O8 -","1","0.5","","Carmen R. Maldonado; Miguel Quirós; Juan M. Salas","","Polyhedron","2009","28","","911","916","10.1016/j.poly.2009.01.037","","","0.71073","MoKα","","0.0287","0.0284","","","0.0772","0.0773","","","","","","1.147","","","","has coordinates","176729","2020-10-21","18:00:00","" "1500034","8.6913","0.0005","11.2673","0.0007","14.9465","0.0009","110.327","0.001","92.4","0.001","98.579","0.001","1350.22","0.14","100","2","100","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H30 Cu N12 O8 -","- C22 H30 Cu N12 O8 -","- C44 H60 Cu2 N24 O16 -","2","1","","Carmen R. Maldonado; Miguel Quirós; Juan M. Salas","","Polyhedron","2009","28","","911","916","10.1016/j.poly.2009.01.037","","","0.71073","MoKα","","0.0302","0.029","","","0.0811","0.082","","","","","","1.065","","","","has coordinates","176729","2020-10-21","18:00:00","" "1500035","8.409","0.0009","8.9126","0.0009","9.9452","0.001","86.016","0.002","86.98","0.002","66.681","0.001","682.56","0.12","100","2","100","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H30 N12 O8 Zn -","- C22 H30 N12 O8 Zn -","- C22 H30 N12 O8 Zn -","1","0.5","","Carmen R. Maldonado; Miguel Quirós; Juan M. Salas","","Polyhedron","2009","28","","911","916","10.1016/j.poly.2009.01.037","","","0.71073","MoKα","","0.0245","0.024","","","0.0634","0.0637","","","","","","1.1","","","","has coordinates","176729","2020-10-21","18:00:00","" "1500036","8.5015","0.0004","9.1721","0.0005","10.1821","0.0005","87.25","0.001","87.41","0.001","65.661","0.001","722.29","0.06","298","2","298","2","","","","","","","","5","P -1","-P 1","2","","","","- C22 H30 Cd N12 O8 -","- C22 H30 Cd N12 O8 -","- C22 H30 Cd N12 O8 -","1","0.5","","Carmen R. Maldonado; Miguel Quirós; Juan M. Salas","","Polyhedron","2009","28","","911","916","10.1016/j.poly.2009.01.037","","","0.71073","MoKα","","0.023","0.0229","","","0.0605","0.0606","","","","","","1.095","","","","has coordinates","176729","2020-10-21","18:00:00",""