# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2025-01-17T21:08:54+01: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 'Solid State Ionics') AND volume = 147 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 "1509015","6.3317","","6.3317","","6.3317","","90","","90","","90","","253.841","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Silver lead iodide (0.67/0.17/1)","","- Ag0.667 I Pb0.167 -","- Ag0.667 I Pb0.1668 -","- Ag2.668 I4 Pb0.6672 -","4","0.0208333","","Hull, S.; Berastegui, P.; Keen, D.A.","Structural description of the superionic behaviour in the system (Ag I)x - (Pb I2)1-x, 2/3 <= x <= 4/5","Solid State Ionics","2002","147","","97","106","10.1016/S0167-2738(02)00008-5","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1531548","6.3519","","6.3519","","6.3519","","90","","90","","90","","256.278","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","(Ag0.5 Pb0.25) I","","- Ag0.5 I Pb0.25 -","- Ag0.5 I Pb0.25 -","- Ag2 I4 Pb -","4","0.0208333","","Hull, S.; Keen, D.A.; Berastegui, P.","Structural description of the superionic behaviour in the system (Ag I)x - (Pb I2)1-x, 2/3 <= x <= 4/5","Solid State Ionics","2002","147","","97","106","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1532173","6.0748","","6.0748","","6.5954","","90","","90","","120","","210.783","","","","","","","","","","","","","4","P -3 1 m","-P 3 2","162","","","","- Li3.333 Mg0.333 P2 S6 -","- Li3.3332 Mg0.3334 P2 S6 -","- Li3.3332 Mg0.3334 P2 S6 -","1","0.0833333","","Takada, K.; Kondo, S.; Inada, T.; Kajiyama, A.; Sasaki, H.; Kanda, M.; Watanabe, M.","Lithium ion conduction in lithium magnesium thio-phosphate","Solid State Ionics","2002","147","","23","27","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1532176","6.0831","","6.0831","","6.5863","","90","","90","","120","","211.068","","","","","","","","","","","","","4","P -3 1 m","-P 3 2","162","","","","- Li2.667 Mg0.667 P2 S6 -","- Li2.6668 Mg0.6666 P2 S6 -","- Li2.6668 Mg0.6666 P2 S6 -","1","0.0833333","","Takada, K.; Watanabe, M.; Inada, T.; Kajiyama, A.; Kanda, M.; Sasaki, H.; Kondo, S.","Lithium ion conduction in lithium magnesium thio-phosphate","Solid State Ionics","2002","147","","23","27","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""