# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T05:33:57+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 'Science') AND volume = 306 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 "1534581","28.596","","31.788","","38.347","","90","","90","","90","","34857.8","","","","","","","","","","","","","7","F d d d :2","-F 2uv 2vw","70","","K7 Na9 (Pt O (H2 O) (P W9 O34)2) (H2 O)21.5","","- H45 K7 Na9 O91.5 P2 Pt W18 -","- K7 Na9 O91.5 P2 Pt W18 -","- K112 Na144 O1464 P32 Pt16 W288 -","16","0.5","","Anderson, T.M.; Neiwert, W.A.; Kirk, M.L.; Rui Cao,; Piccoli, P.M.B.; Schultz, A.J.; Koetzle, F.; Hill, C.L.; Keiji Morokuma,; Musaev, D.G.","A Late-Transition Metal Oxo Complex: K7 Na9 [O=PtIV (H2 O)L2], L = [P W9 O34]9-","Science","2004","306","","2074","2077","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1534583","28.637","","31.735","","38.228","","90","","90","","90","","34741.4","","","","","","","","","","","","","7","F d d d :2","-F 2uv 2vw","70","","H5.6 K7.6 Na1.4 ((Pd (H2 O)2)0.3 (W O (H2 O))0.7 (P W9 O34)2) (H2 O)20.5","","- H49.2 K7.6 Na1.4 O90.5 P2 Pd0.3 W18.7 -","- K7.6 Na1.4 O90.5 P2 Pd0.3 W18.7 -","- K121.6 Na22.4 O1448 P32 Pd4.8 W299.2 -","16","0.5","","Anderson, T.M.; Musaev, D.G.; Kirk, M.L.; Neiwert, W.A.; Schultz, A.J.; Piccoli, P.M.B.; Koetzle, F.","A Late-Transition Metal Oxo Complex: K7 Na9 [O=PtIV (H2 O)L2], L = [P W9 O34]9-","Science","2004","306","","2074","2077","","","","","","","","","","","","","","","","","","","","","","has coordinates","161423","2020-10-21","18:00:00","" "1534585","28.494","","31.687","","37.988","","90","","90","","90","","34299","","","","","","","","","","","","","7","F d d d :2","-F 2uv 2vw","70","","K7 Na9 (Pt0.5 (O) (H2 O) (P W9 O34)2) (H2 O)21.5","","- H45 K7 Na9 O91.5 P2 Pt0.5 W18 -","- H7.78028 K7 Na9 O89.79 P2 Pt0.5 W18 -","- H124.484 K112 Na144 O1436.64 P32 Pt8 W288 -","16","0.5","","Anderson, T.M.; Neiwert, W.A.; Kirk, M.L.; Koetzle, F.; Piccoli, P.M.B.; Schultz, A.J.; Musaev, D.G.","A Late-Transition Metal Oxo Complex: K7 Na9 [O=PtIV (H2 O) L2], L = [P W9 O34]9-","Science","2004","306","","2074","2077","","","","","","","","","","","","","","","","","","","","","","has coordinates","161428","2020-10-21","18:00:00",""