# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-09-29T01:17:58+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 'Molbank') AND volume = 2024 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 "1570898","9.834","0.009","12.609","0.01","16.946","0.016","90","","90.94","0.03","90","","2101","3","100","","100","","","","","","","","","5","P 1 c 1","P -2yc","7","","","","- C19 H30 N3 O6.5 S -","- C19 H30 N3 O6.5 S -","- C76 H120 N12 O26 S4 -","4","2","","Buikin, Petr A.; Vologzhanina, Anna V.; Korlyukov, Alexander A.","Sumatriptan Succinate Hemi(Ethanol Solvate)","Molbank","2024","2024","1","M1766","","10.3390/M1766","","","0.71073","MoKα","","0.0561","0.0467","","","0.1134","0.1188","","","","","","1.025","","","","has coordinates","289656","2024-02-05","03:59:15","" "1571120","30.7102","0.0006","18.9149","0.0004","15.7234","0.0002","90","","90.301","0.001","90","","9133.3","0.3","173","2","173","2","","","","","","","","7","C 1 2/c 1","-C 2yc","15","","","","- C202 H222 Cl12 Fe8 Ir8 N8 O -","- C202 H222 Cl12 Fe8 Ir8 N8 O -","- C404 H444 Cl24 Fe16 Ir16 N16 O2 -","2","0.25","","Weigand, Stefan; Sünkel, Karlheinz","Chlorido-pentamethylcyclopentadienyl-[2-(2-pyridyl-кN)-ferrocenyl-кC]-iridium(III)","Molbank","2024","2024","1","M1770","","10.3390/M1770","","","0.71069","MoKα","","0.0434","0.0303","","","0.0734","0.0811","","","","","","1.029","","","","has coordinates","290302","2024-03-05","12:05:15",""