# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-28T02:34:24+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 'Journal of agricultural and food chemistry') AND volume = 59 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
"1501657","11.724","0.002","9.2465","0.0018","15.567","0.003","90","","95.26","0.03","90","","1680.4","0.5","113","2","113","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C16 H20 N4 O2 S -","- C16 H20 N4 O2 S -","- C64 H80 N16 O8 S4 -","4","1","","Wang, Huan; Yang, Zhikun; Fan, Zhijin; Wu, Qingjun; Zhang, Youjun; Mi, Na; Wang, Shouxin; Zhang, Zhengcai; Song, Haibin; Liu, Feng","Synthesis and insecticidal activity of N-tert-butyl-N,N'-diacylhydrazines containing 1,2,3-thiadiazoles.","Journal of agricultural and food chemistry","2011","59","2","628","634","10.1021/jf104004q","","","0.71073","MoKα","","0.0678","0.0547","","","0.1246","0.1317","","","","","","1.052","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1501658","16.4438","0.0017","10.2569","0.0011","11.1264","0.0012","90","","104.256","0.002","90","","1818.8","0.3","293","2","293","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C16 H13 Cl3 N6 O2 -","- C16 H13 Cl3 N6 O2 -","- C64 H52 Cl12 N24 O8 -","4","1","","Ye, Zhenjun; Xia, Shuang; Shao, Xusheng; Cheng, Jiagao; Xu, Xiaoyong; Xu, Zhiping; Li, Zhong; Qian, Xuhong","Design, synthesis, crystal structure analysis, and insecticidal evaluation of phenylazoneonicotinoids.","Journal of agricultural and food chemistry","2011","59","19","10615","10623","10.1021/jf2029708","","","0.71073","MoKα","","0.0659","0.051","","","0.1347","0.1448","","","","","","0.985","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1501659","15.867","0.002","7.9286","0.0011","15.923","0.002","90","","113.221","0.002","90","","1840.9","0.4","293","2","293","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C18 H19 Cl N6 O2 -","- C18 H19 Cl N6 O2 -","- C72 H76 Cl4 N24 O8 -","4","1","","Ye, Zhenjun; Xia, Shuang; Shao, Xusheng; Cheng, Jiagao; Xu, Xiaoyong; Xu, Zhiping; Li, Zhong; Qian, Xuhong","Design, synthesis, crystal structure analysis, and insecticidal evaluation of phenylazoneonicotinoids.","Journal of agricultural and food chemistry","2011","59","19","10615","10623","10.1021/jf2029708","","","0.71073","MoKα","","0.0698","0.0526","","","0.1343","0.1446","","","","","","1.044","","","","has coordinates","176729","2020-10-21","18:00:00",""