# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-02T03:50:11+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 'Annales de Chimie (Paris) (Vol=Year)') AND volume = 9 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 "1008977","5.918","0.001","3.746","0.001","7.029","0.001","90","","90","","90","","155.8","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Cobalt rhodium arsenide (1/1/1)","","- As Co Rh -","- As Co Rh -","- As4 Co4 Rh4 -","4","0.5","","Roy-Montreuil, J; Chaudouet, P; Rouault, A; Boursier, D; Senateur, J P; Fruchart, R","Analyse de l'ordre dans les arseniures M M' As","Annales de Chimie (Paris) (Vol=Year)","1984","9","","579","586","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1008986","6.482","0.001","6.482","","3.714","0.001","90","","90","","120","","135.1","","","","","","","","","","","","","3","P -6 2 m","P -6 -2","189","","Manganese rhodium arsenide (1/1/1)","","- As Mn Rh -","- As Mn Rh -","- As3 Mn3 Rh3 -","3","0.25","","Roy-Montreuil, J; Chaudouet, P; Rouault, A; Boursier, D; Senateur, J P; Fruchart, R","Analyse de l'ordre dans les arseniures MM'As","Annales de Chimie (Paris) (Vol=Year)","1984","9","","579","586","","","","","","","0.097","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1008989","3.565","0.001","3.565","","6.161","0.001","90","","90","","90","","78.3","","","","","","","","","","","","","3","P 4/n m m :1","P 4ab 2ab -1ab","129","","Nickel rhodium arsenide (1/1/1)","","- As Ni Rh -","- As Ni Rh -","- As2 Ni2 Rh2 -","2","0.125","","Roy-Montreuil, J; Chaudouet, P; Rouault, A; Boursier, D; Senateur, J O; Fruchart, R","Analyse de l'ordre ddans les arseniures MM'As","Annales de Chimie (Paris) (Vol=Year)","1984","9","","579","586","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1008991","6.334","0.001","3.816","0.001","7.388","0.001","90","","90","","90","","178.6","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Rhodium titanium arsenide (1/1/1)","","- As Rh Ti -","- As Rh Ti -","- As4 Rh4 Ti4 -","4","0.5","","Roy-Montreuil, J; Chadouet, P; Rouault, A; Boursier, D; Senateur, J P; Fruchart, R","Analyse de l'ordre dans les arseniures MM'As","Annales de Chimie (Paris) (Vol=Year)","1984","9","","589","586","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""