# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T16:35:32+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 Communications') AND volume = 5 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 "1008091","5.326","","5.602","","7.635","","90","","90","","90","","227.8","","","","","","","","","","","","","3","P b n m","-P 2c 2ab","62","","Terbium iron(III) oxide","","- Fe O3 Tb -","- Fe O3 Tb -","- Fe4 O12 Tb4 -","4","0.5","","Bertaut, E F; Chappert, J; Mareschal, J; Rebouillat, J P; Sivardiere, J","Structures magnetiques de Tb Fe O~3~","Solid State Communications","1967","5","","293","298","10.1016/0038-1098(67)90276-1","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1008159","5.223","","5.516","","7.519","","90","","90","","90","","216.6","","","","","","","","","","","","","3","P b n m","-P 2c 2ab","62","","Erbium chromium oxide","","- Cr Er O3 -","- Cr Er O3 -","- Cr4 Er4 O12 -","4","0.5","","Bertaut, E F; Mareschal, J","Etude de la Structure Magnetique des Chromites d'Erbium et de Neodyme par Diffraction Neutronique","Solid State Communications","1967","5","","93","97","10.1016/0038-1098(67)90001-4","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1008160","5.425","","5.478","","7.694","","90","","90","","90","","228.7","","","","","","","","","","","","","3","P b n m","-P 2c 2ab","62","","Neodymium chromium oxide","","- Cr Nd O3 -","- Cr Nd O3 -","- Cr4 Nd4 O12 -","4","0.5","","Bertaut, E F; Mareschal, J","Etude de la Structure Magnetique des Chromites d'Erbium et de Neodyme par Diffraction Neutronique","Solid State Communications","1967","5","","93","97","10.1016/0038-1098(67)90001-4","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1523039","4.828","","4.828","","4.828","","90","","90","","90","","112.539","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Pd V3 -","- Pd V3 -","- Pd2 V6 -","2","0.0416667","","Vielhaber, E.; Luo, H.L.","New A15-phases","Solid State Communications","1967","5","","221","223","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1523040","5.626","","5.626","","5.626","","90","","90","","90","","178.073","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Tl0.8 Zr3.2 -","- Tl0.8 Zr3.2 -","- Tl1.6 Zr6.4 -","2","0.0416667","","Vielhaber, E.; Luo, H.L.","New A15 phases","Solid State Communications","1967","5","","221","223","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1523041","5.187","","5.187","","5.187","","90","","90","","90","","139.556","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Hg Ti3 -","- Hg Ti3 -","- Hg2 Ti6 -","2","0.0416667","","Vielhaber, E.; Luo, H.L.","New A15-phases","Solid State Communications","1967","5","","221","223","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1528163","5.256","","5.256","","5.256","","90","","90","","90","","145.2","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","Ti3 (Ti0.2 Tl0.8)","","- Ti3.2 Tl0.8 -","- Ti3.2 Tl0.8 -","- Ti6.4 Tl1.6 -","2","0.0416667","","Vielhaber, E.; Luo, H.L.","New A-15 phases","Solid State Communications","1967","5","","221","223","","","","","","","","","","","","","","","","","","","","","","has coordinates","150113","2020-10-21","18:00:00","" "1539214","5.56","","5.56","","5.56","","90","","90","","90","","171.88","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Hg Zr3 -","- Hg Zr3 -","- Hg2 Zr6 -","2","0.0416667","","Vielhaber, E.; Luo, H.L.","New A-15 phases","Solid State Communications","1967","5","","221","223","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""