# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T08:33:16+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 'Crystals') AND volume = 4 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 "1513836","14.477","0.0013","10.8678","0.0009","21.627","0.002","90","","122.78","0.006","90","","2860.8","0.5","170","2","170","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","Tetraguaninium decatungstate acetonitrile tetrahydrate","Tetraguaninium di-mu5-oxo-icosa-mu-oxo-decaoxodecatungstate acetonitrile tetrahydrate","","- C22 H37 N20 O41 W10 -","- C22 H27 N21 O41 W10 -","- C44 H54 N42 O82 W20 -","2","0.5","","Kulikov, Vladislav; Meyer, Gerd","Polyoxotungstates in Molecular Boxes of Purine Bases","Crystals","2014","4","1","64","","10.3390/cryst4010064","","","0.71073","MoKα","","0.0612","0.0434","","","0.1103","0.1316","","","","","","1.073","","","","has coordinates,has disorder","176729","2020-10-21","18:00:00","" "1513837","16.81","0.003","13.0514","0.0019","15.675","0.003","90","","109.73","0.013","90","","3237.1","1","293","2","293","2","","","","","","","","5","C 1 2/c 1","-C 2yc","15","Ditheobrominium hexatungstate dihydrate","Ditheobrominium μ6-oxo-dodeca-μ-oxo-hexaoxohexatungstate(VI) dihydrate","","- C14 H22 N8 O25 W6 -","- C14 H18 N8 O25 W6 -","- C56 H72 N32 O100 W24 -","4","0.5","","Kulikov, Vladislav; Meyer, Gerd","Polyoxotungstates in Molecular Boxes of Purine Bases","Crystals","2014","4","1","64","","10.3390/cryst4010064","","","0.71073","MoKα","","0.1037","0.0361","","","0.0628","0.0745","","","","","","0.75","","","","has coordinates","176729","2020-10-21","18:00:00","" "1513838","13.4905","0.0012","15.1707","0.0014","17.0692","0.0017","79.594","0.008","89.386","0.008","70.001","0.007","3223.8","0.6","293","2","293","2","","","","","","","","5","P -1","-P 1","2","Hydronium tritheobrominium decatungstate trihydrate","Hydronium tritheobrominium di-mu5-oxo-icosa-mu-oxo-decaoxodecatungstate hemipentadecahydrate","","- C21 H45 N12 O46.5 W10 -","- C21 H27 N12 O46.5 W10 -","- C42 H54 N24 O93 W20 -","2","1","","Kulikov, Vladislav; Meyer, Gerd","Polyoxotungstates in Molecular Boxes of Purine Bases","Crystals","2014","4","1","64","","10.3390/cryst4010064","","","0.71073","MoKα","","0.059","0.0347","","","0.0847","0.095","","","","","","0.882","","","","has coordinates,has disorder","176729","2020-10-21","18:00:00","" "1518356","7.8532","0.0016","10","0.002","13.192","0.003","90","","105.06","0.03","90","","1000.4","0.4","210","2","210","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","","","","- C2 H13 Co N4 O9 -","- C2 H13 Co N4 O9 -","- C8 H52 Co4 N16 O36 -","4","1","","Hrib, Cristian; Blaurock, Steffen; Edelmann, Frank","Crystallization and Structure Determination of Fac-Triammin-Aquo-Oxalato-Cobalt (III)-Nitrate Monohydrate","Crystals","2014","4","4","490","","10.3390/cryst4040490","","","0.71073","MoKα","","0.0793","0.0525","","","0.126","0.1327","","","","","","0.881","","","","has coordinates","176729","2020-10-21","18:00:00",""