# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-02T01:29:14+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 'The Analyst') AND volume = 139 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 "1513595","23.0762","0.0015","12.6124","0.0006","17.5274","0.0013","90","","116.601","0.001","90","","4561.3","0.5","100","2","100","2","","","","","","","","6","C 1 2/c 1","-C 2yc","15","","","","- C38 H34 Cd2 Cl2 N12 O10 -","- C38 H34 Cd2 Cl2 N12 O10 -","- C152 H136 Cd8 Cl8 N48 O40 -","4","0.5","","Jana, Atanu; Sukul, Pradip K.; Mandal, Sushil K.; Konar, Saugata; Ray, Sangita; Das, Kinsuk; Golen, James A.; Rheingold, Arnold L.; Mondal, Sudipa; Mondal, Tapan K.; Khuda-Bukhsh, Anisur R; Kar, Susanta K.","A novel 2,6-diformyl-4-methylphenol based chemosensor for Zn(II) ions by ratiometric displacement of Cd(II) ions and its application for cell imaging on human melanoma cancer cells.","The Analyst","2014","139","2","495","504","10.1039/c3an01750h","","","0.71073","MoKα","","0.0341","0.0237","","","0.0581","0.0627","","","","","","1.036","","","","has coordinates","176729","2020-10-21","18:00:00","" "1516973","5.3994","0.0012","14.277","0.004","20.499","0.005","90","","90","","90","","1580.2","0.7","296","2","296","2","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C20 H15 N3 O -","- C20 H15 N3 O -","- C80 H60 N12 O4 -","4","1","","Mukherjee, Manjira; Pal, Siddhartha; Lohar, Somenath; Sen, Buddhadeb; Sen, Supriti; Banerjee, Samya; Banerjee, Snehasis; Chattopadhyay, Pabitra","A napthelene-pyrazol conjugate: Al(iii) ion-selective blue shifting chemosensor applicable as biomarker in aqueous solution.","The Analyst","2014","139","19","4828","4835","10.1039/c4an01039f","","","0.71073","MoKα","","0.2337","0.0683","","","0.114","0.1656","","","","","","0.93","","","","has coordinates","176729","2020-10-21","18:00:00",""