# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T08:30:56+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 'Analytical chemistry') AND volume = 92 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 "1557785","22.4736","0.0019","24.012","0.002","20.6252","0.0017","90","","97.765","0.002","90","","11028","1.6","173","","173","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","","","- C69 H154 O47 Ti17 -","- C48 H102 O46 Ti17 -","- C192 H408 O184 Ti68 -","4","0.5","","Liu, Caiyun; Hu, Junyi; Biswas, Subharanjan; Zhu, Feng; Zhan, Jinhua; Wang, Guo; Tung, Chen-Ho; Wang, Yifeng","Surface-Enhanced Raman Scattering of Phenols and Catechols by a Molecular Analogue of Titanium Dioxide.","Analytical chemistry","2020","92","8","5929","5936","10.1021/acs.analchem.0c00047","","","0.71073","MoKα","","0.1231","0.0676","","","0.1849","0.2127","","","","","","1.063","","","","has coordinates,has disorder","251432","2020-10-21","18:00:00","" "1559392","24.8883","0.0007","7.2668","0.0003","34.9364","0.0013","90","","90","","90","","6318.5","0.4","170","2","170","","","","","","","","","5","P b c a","-P 2ac 2ab","61","","","","- C38 H34 N2 O2 Si -","- C38 H34 N2 O2 Si -","- C304 H272 N16 O16 Si8 -","8","1","","Guo, Jinna; Feng, Weiqiang; Du, Peiyao; Zhang, Ruizhong; Liu, Jia; Liu, Yu; Wang, Zhiming; Lu, Xiaoquan","Aggregation-Induced Electrochemiluminescence of Tetraphenylbenzosilole Derivatives in an Aqueous Phase System for Ultrasensitive Detection of Hexavalent Chromium.","Analytical chemistry","2020","92","21","14838","14845","10.1021/acs.analchem.0c03709","","","0.71073","MoKα","","0.0805","0.0623","","","0.175","0.1898","","","","","","1.061","","","","has coordinates","258705","2020-11-04","01:18:52",""