# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T08:52:52+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 'Journal of Agricultural and Food Chemistry') AND volume = 61 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
"1508819","11.6146","0.0008","7.7855","0.0005","35.607","0.002","90","","90","","90","","3219.8","0.4","293","2","293","2","","","","","","","","5","P c a 21","P 2c -2ac","29","","","","- C15 H19 Cl N4 O4 -","- C15 H19 Cl N4 O4 -","- C120 H152 Cl8 N32 O32 -","8","2","","Ye, Zhenjun; Shi, Lina; Shao, Xusheng; Xu, Xiaoyong; Xu, Zhiping; Li, Zhong","Pyrrole- and dihydropyrrole-fused neonicotinoids: design, synthesis, and insecticidal evaluation.","Journal of agricultural and food chemistry","2013","61","2","312","319","10.1021/jf3044132","","","0.71073","MoKα","","0.062","0.0457","","","0.1097","0.1213","","","","","","0.945","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1512126","13.1973","0.0018","10.9585","0.0015","24.226","0.003","90","","100.216","0.002","90","","3448.1","0.8","100","2","100","2","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C64 H96 Cl2 O31 -","- C64 H92 Cl2 O31 -","- C128 H184 Cl4 O62 -","2","1","","Li, Yan-Ping; Li, Xiao-Nian; Gao, Ling-Huan; Li, Hai-Zhou; Wu, Guo-Xing; Li, Rong-Tao","Neopierisoids A and B, Two New Chlorinated 3,4-seco-Grayanane Diterpenoids with Antifeedant Activity from Flowers of Pieris japonica","Journal of Agricultural and Food Chemistry","2013","61","30","7219","","10.1021/jf401921x","","","0.71073","MoKα","","0.0865","0.0627","","","0.1628","0.1804","","","","","","1.037","","","","has coordinates","176729","2020-10-21","18:00:00",""