# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-29T03:47:25+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 'Tetrahedron Letters') AND volume = 51 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
"1548693","7.988","0.002","9.116","0.003","11.625","0.003","86.69","0.006","73.837","0.014","80.279","0.012","801.3","0.4","100","2","100","2","","","","","","","","7","P 1","P 1","1","","","","- C22 H42 Br4 Cu2 N6 O2 S2 -","- C22 H42 Br4 Cu2 N6 O2 S2 -","- C22 H42 Br4 Cu2 N6 O2 S2 -","1","1","","Musabbir A. Saeed; Douglas R. Powell; Md. Alamgir Hossain","Fluorescent detection of phosphate anion by a highly selective chemosensor in water","Tetrahedron Letters","2010","51","","4904","4907","10.1016/j.tetlet.2010.07.078","","","0.71073","MoKα","","0.0644","0.0474","","","0.1008","0.106","","","","","","1.005","","","","has coordinates,has disorder","205255","2020-10-21","18:00:00",""
"7106302","13.581","","8.659","","24.036","","90","","95.24","","90","","2814.77","","120","2","120","2","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","","","- C32 H26 N6 O4 -","- C32 H26 N6 O4 -","- C128 H104 N24 O16 -","4","0.5","","da Silva, Daniel Botelho; Samadi, Abdelouahid; Infantes, Lourdes; Carreiras, María do Carmo; Marco-Contelles, José","Synthesis of (E)-diethyl 6,6'-(diazene-1,2-diyl)bis(5-cyano-2-methyl-4-phenylnicotinates), a new type of 2,2'-azopyridine dyes","Tetrahedron Letters","2010","51","48","6278","6281","10.1016/j.tetlet.2010.09.095","","x-ray","1.54178","CuKα","","0.0581","0.0548","","","0.1639","0.166","","","","","","1.209","","","","has coordinates","210845","2020-10-21","18:00:00",""