# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-05T20:41:14+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 'The Analyst') AND volume = 136 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 "1515409","8.724","0.011","13.085","0.015","13.323","0.015","90","","97.447","0.01","90","","1508","3","293","2","293","2","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","","","- C19 H14 N4 -","- C19 H14 N4 -","- C76 H56 N16 -","4","1","","Sen, Supriti; Mukherjee, Titas; Sarkar, Sandipan; Mukhopadhyay, Subhra Kanti; Chattopadhyay, Pabitra","Development of a highly selective cell-permeable ratiometric fluorescent chemosensor for oxorhenium(V) ion.","The Analyst","2011","136","22","4839","4845","10.1039/c1an15609h","","","0.71073","Mo","","0.0684","0.0539","","","0.1202","0.1258","","","","","","1.183","","","","has coordinates","176435","2020-10-21","18:00:00","" "1515410","20.459","0.011","9.635","0.005","23.657","0.012","90","","111.067","0.006","90","","4352","4","298","2","298","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","","","","- C12 H10 N2 O S -","- C12 H10 N2 O S -","- C192 H160 N32 O16 S16 -","16","4","","Cui, Daoping; Li, Yueqing; Lian, Mingming; Yang, Feng; Meng, Qingwei","Development of a simple and stability-indicating RP-HPLC method for determining olanzapine and related impurities generated in the preparative process.","The Analyst","2011","136","15","3149","3156","10.1039/c1an15155j","","","0.71073","MoKα","","0.1111","0.0632","","","0.1616","0.1982","","","","","","1.007","","","","has coordinates","176729","2020-10-21","18:00:00","" "1515961","9.23","0.002","12.017","0.003","14.264","0.004","80.136","0.005","84.48","0.005","87.213","0.005","1550.7","0.7","293","2","293","2","","","","","","","","4","P -1","-P 1","2","","","","- C36 H26 N4 O4 -","- C36 H26 N4 O4 -","- C72 H52 N8 O8 -","2","1","","Kim, Ha Na; Nam, Seong-Won; Swamy, K. M. K.; Jin, Yan; Chen, Xiaoqiang; Kim, Yonugmee; Kim, Sung-Jin; Park, Sungsu; Yoon, Juyoung","Rhodamine hydrazone derivatives as Hg2+ selective fluorescent and colorimetric chemosensors and their applications to bioimaging and microfluidic system.","The Analyst","2011","136","7","1339","1343","10.1039/c0an00804d","","","0.71073","MoKα","","0.1892","0.0682","","","0.1705","0.2154","","","","","","0.856","","","","has coordinates,has disorder","176729","2020-10-21","18:00:00",""