# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-07-05T22:01:19+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 'ACS nano') AND volume = 10 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
"4516817","7.7704","0.0005","16.1957","0.001","10.2976","0.0006","90","","90.612","0.002","90","","1295.85","0.14","120","","120","","","","","","","","","6","P 1 m 1","P -2y","6","","","","- C24.75 H29 Cl2 N2 O2.75 S2 -","- C24.75 H29 Cl2 N2 O2.75 S2 -","- C49.5 H58 Cl4 N4 O5.5 S4 -","2","1","","Zhang, Wei; Gan, Shiyu; Vezzoli, Andrea; Davidson, Ross J.; Milan, David C.; Luzyanin, Konstantin V.; Higgins, Simon J.; Nichols, Richard J.; Beeby, Andrew; Low, Paul J.; Li, Buyi; Niu, Li","Single-Molecule Conductance of Viologen-Cucurbit[8]uril Host-Guest Complexes.","ACS nano","2016","10","5","5212","5220","10.1021/acsnano.6b00786","","x-ray","0.71073","MoKα","","0.0486","0.0416","","","0.1105","0.1145","","","","","","1.035","","","","has coordinates,has disorder","239565","2020-10-21","18:00:00",""