# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-29T11:55:04+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 'Molecules (Basel, Switzerland)') AND volume = 21 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 "1543018","10.044","0.0009","17.0692","0.0018","12.0304","0.0012","90","","95.588","0.003","90","","2052.7","0.4","296","2","296","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","","","","- C20 H19 Cl N2 O7 -","- C20 H19 Cl N2 O7 -","- C80 H76 Cl4 N8 O28 -","4","1","","Xu, Wen-Qin; Chen, Min; Wang, Kun-Yao; Ren, Zheng-Jiao; Lu, Ai-Min; Yang, Chun-Long","Synthesis, Characterization, and Antifungal Activity of Phenylpyrrole-Substituted Tetramic Acids Bearing Carbonates.","Molecules (Basel, Switzerland)","2016","21","3","355","","10.3390/molecules21030355","","","0.71073","MoKα","","0.1007","0.0569","","","0.1644","0.1984","","","","","","1.023","","","","has coordinates,has disorder","181481","2020-10-21","18:00:00","" "1543463","16.1899","0.0012","18.2778","0.0014","27.093","0.002","90","","101.513","0.002","90","","7855.9","1","120","","120","","","","","","","","","8","P 1 21/n 1","-P 2yn","14","","","","- C138 H178 Cl N2 Na Ni6 O52 Si12 -","- C138 H178 Cl N2 Na Ni6 O52 Si12 -","- C276 H356 Cl2 N4 Na2 Ni12 O104 Si24 -","2","0.5","","Bilyachenko, Alexey N.; Yalymov, Alexey I.; Shul'pina, Lidia S.; Mandelli, Dalmo; Korlyukov, Alexander A.; Vologzhanina, Anna V.; Es'kova, Marina A.; Shubina, Elena S.; Levitsky, Mikhail M.; Shul'pin, Georgiy B.","Novel Cage-Like Hexanuclear Nickel(II) Silsesquioxane. Synthesis, Structure, and Catalytic Activity in Oxidations with Peroxides.","Molecules (Basel, Switzerland)","2016","21","5","665","","10.3390/molecules21050665","","","0.71073","MoKα","","0.1883","0.0823","","","0.1614","0.205","","","","","","1.006","","","","has coordinates,has disorder","183650","2020-10-21","18:00:00",""