# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-15T22:16:54+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 'Comptes Rendus Hebdomadaires des Seances de l\'Academie des Sciences, Serie C, Sciences Chimiques (1966-)') AND volume = 309 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 "1008449","14.59","0.01","14.59","0.01","14.59","0.01","90","","90","","90","","3105.7","","","","","","","","","","","","","5","I a -3","-I 2b 2c 3","206","","Tris(guanidinium) diberyllium fluoride","","- C3 H18 Be2 F7 N9 -","- C3 H18 Be2 F7 N9 -","- C24 H144 Be16 F56 N72 -","8","0.166667","","Aleonard, S; Gorius, M","Structure cristalline du pyrofluoroberyllate de guanidinium (C N~3~ H~6~)~3~ Be~2~ F~7~","Comptes Rendus Hebdomadaires des Seances de l'Academie des Sciences, Serie C, Sciences Chimiques (1966-)","1989","309","","683","687","","","","","","","0.051","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1529902","17.266","","9.738","","17.092","","90","","111.03","","90","","2682.37","","","","","","","","","","","","","4","C 1 c 1","C -2yc","9","","Li Zn (P O4)","","- Li O4 P Zn -","- Li O4 P Zn -","- Li32 O128 P32 Zn32 -","32","8","","Elfakir, A.; Souron, J.P.; Robert, F.; Quarton, M.","Structure cristalline de l'orthophosphate Li Zn P O4","Comptes Rendus Hebdomadaires des Seances de l'Academie des Sciences, Serie C, Sciences Chimiques (1966-)","1989","309","","199","203","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""