# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T14:51:47+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 'Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)') AND volume = 92 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 "1007057","9.88","0.005","5.733","0.002","7.432","0.004","90","","94.1","0.05","90","","419.9","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","Tripotassium calcium hydrogenbis(phosphate)","","- Ca H K3 O8 P2 -","- Ca H0.5 K3 O8 P2 -","- Ca2 H K6 O16 P4 -","2","0.25","","Grenier, J C; Durif, A; Martin, C","Structure cristalline de Ca K~3~ H (P O~4~)~2~","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","30","32","","","","","","","0.09","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1008104","5.524","","8.308","","6.234","","90","","90","","90","","286.1","","","","","","","","","","","","","3","C m c m","-C 2c 2","63","","Cobalt chromate","","- Co Cr O4 -","- Co Cr O4 -","- Co4 Cr4 O16 -","4","0.25","","Pernet, M; Quezel, G; Coing-Boyat, J; Bertaut, E F","Structures magnetiques des chromates de cobalt et de nickel","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","264","273","","","","","","","0.057","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1008105","5.484","","8.22","","6.127","","90","","90","","90","","276.2","","","","","","","","","","","","","3","C m c m","-C 2c 2","63","","Nickel chromate","","- Cr Ni O4 -","- Cr Ni O4 -","- Cr4 Ni4 O16 -","4","0.25","","Pernet, M; Quezel, G; Coing-Boyat, J; Bertaut, E F","Structures magnetiques des chromates de cobalt et de nickel","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","264","273","","","","","","","0.11","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1522364","4.99","","4.99","","24.54","","90","","90","","120","","529.183","","","","","","","","","","","","","2","R -3 m :H","-R 3 2""","166","","","","- Gd Ni3 -","- Gd Ni3 -","- Gd9 Ni27 -","9","0.25","","Lemaire, R.; Paccard, D.","Structures cristallines des composes intermetalliques entre le nickel et les metaux de terres rares ou l'yttrium","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","9","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1522365","4.9","","4.9","","3.97","","90","","90","","120","","82.549","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- Gd Ni5 -","- Gd Ni5 -","- Gd Ni5 -","1","0.0416667","","Lemaire, R.; Paccard, D.","Structures cristallines des composes intermetalliques entre le nickel et les metaux de terres rares ou l'yttrium","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","9","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1522366","4.96","","4.96","","36.14","","90","","90","","120","","769.985","","","","","","","","","","","","","2","R -3 m :H","-R 3 2""","166","","","","- Gd2 Ni7 -","- Gd2 Ni7 -","- Gd12 Ni42 -","6","0.166667","","Lemaire, R.; Paccard, D.","Structures cristallines des composes intermetalliques entre le nickel et les metaux de terres rares ou l'yttrium","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","9","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1522367","8.43","","8.43","","8.04","","90","","90","","120","","494.814","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","","","- Gd2 Ni17 -","- Gd2 Ni17 -","- Gd4 Ni34 -","2","0.0833333","","Lemaire, R.; Paccard, D.","Structures cristallines des composes intermetalliques entre le nickel et les metaux de terres rares ou l'yttrium","Bulletin de la Societe Francaise de Mineralogie et de Cristallographie (72,1949-100,1977)","1969","92","","9","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""