# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-20T07:15: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 'C. R. Acad. Sci. Paris, T. 1, Serie II') 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 "1000505","9.926","0.0001","8.6189","0.0001","9.7622","0.0001","90","","90","","90","","835.2","","","","","","","","","","","","","4","P b c a","-P 2ac 2ab","61","","Gallium phosphate(V) dihydrate","","- Ga H4 O6 P -","- Ga H8 O6 P -","- Ga8 H64 O48 P8 -","8","1","","Loiseau, T; Paulet, C; Ferey, G","Crystal structure determination of the hydrated gallium phosphate Ga P O4 . 2(H2 O), analog of variscite","C. R. Acad. Sci. Paris, T. 1, Serie II","1998","1","","667","674","","","","","","","0.036","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44","" "1009075","3.819","0.001","3.819","0.001","22.96399","0.005","90","","90","","90","","334.9","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Disamarium dititanium pentaoxide disulfide","","- O5 S2 Sm2 Ti2 -","- O5 S2 Sm2 Ti2 -","- O10 S4 Sm4 Ti4 -","2","0.0625","","Boyer, C; Deudon, C; Meerschaut, A","Synthesis and structure determination of the new Sm2 Ti2 O5 S2 compound","C. R. Acad. Sci. Paris, T. 1, Serie II","1999","2","","93","99","","","","","","","0.018","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""