# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-18T19:50:46+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 = 62 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
"1513354","12.1371","0.0011","16.7863","0.0014","10.8176","0.0009","90","","96.76","0.002","90","","2188.6","0.3","140","2","140","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C21 H21 Cl N8 O6 -","- C21 H21 Cl N8 O6 -","- C84 H84 Cl4 N32 O24 -","4","1","","Xu, Renbo; Xia, Rui; Luo, Ming; Xu, Xiaoyong; Cheng, Jiagao; Shao, Xusheng; Li, Zhong","Design, Synthesis, Crystal Structures, and Insecticidal Activities of Eight-Membered Azabridge Neonicotinoid Analogues.","Journal of agricultural and food chemistry","2014","62","2","381","","10.1021/jf4046683","","","0.71073","MoKα","","0.0469","0.0378","","","0.1077","0.1144","","","","","","1.033","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1513801","9.6767","0.0007","13.3568","0.001","14.8222","0.0011","90","","90","","90","","1915.8","0.2","293","2","293","2","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C21 H22 Cl N5 O2 -","- C21 H22 Cl N5 O2 -","- C84 H88 Cl4 N20 O8 -","4","1","","Xu, Renbo; Xia, Rui; Luo, Ming; Xu, Xiaoyong; Cheng, Jiagao; Shao, Xusheng; Li, Zhong","Design, Synthesis, Crystal Structures, and Insecticidal Activities of Eight-Membered Azabridge Neonicotinoid Analogues.","Journal of agricultural and food chemistry","2014","62","2","381","","10.1021/jf4046683","","","0.71073","MoKα","","0.0367","0.0331","","","0.0844","0.087","","","","","","1.035","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1517408","6.1375","0.0012","7.7099","0.0015","20.954","0.004","90","","90","","90","","991.5","0.3","113","2","113","2","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C11 H11 Cl O2 -","- C11 H11 Cl O2 -","- C44 H44 Cl4 O8 -","4","1","","Lu, Aidang; Wang, Jinjin; Liu, Tengjiao; Han, Jian; Li, Yinhui; Su, Min; Chen, Jianxin; Zhang, Hui; Wang, Lizhong; Wang, Qingmin","Small Changes Result in Large Differences: Discovery of (-)-Incrustoporin Derivatives as Novel Antiviral and Antifungal Agents.","Journal of agricultural and food chemistry","2014","62","35","8799","8807","10.1021/jf503060k","","","0.71073","MoKα","","0.0422","0.0373","","","0.0854","0.0889","","","","","","1.062","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1518258","7.9515","0.0012","9.9767","0.0016","23.502","0.004","90","","97.878","0.003","90","","1846.8","0.5","293","2","293","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","","","","- C20 H20 Cl N5 O2 -","- C20 H20 Cl N5 O2 -","- C80 H80 Cl4 N20 O8 -","4","1","","Xu, Renbo; Luo, Ming; Xia, Rui; Meng, Xiaoqing; Xu, Xiaoyong; Xu, Zhiping; Cheng, Jiagao; Shao, Xusheng; Li, Houju; Li, Zhong","Seven-membered azabridged neonicotinoids: synthesis, crystal structure, insecticidal assay, and molecular docking studies.","Journal of agricultural and food chemistry","2014","62","46","11070","11079","10.1021/jf504014y","","","0.71073","MoKα","","0.0644","0.0542","","","0.1462","0.1541","","","","","","1.022","","","","has coordinates","176729","2020-10-21","18:00:00",""