# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-20T15:17:30+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 'Physica B: Condensed Matter') AND volume = 162 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 "1000097","6.1791","0.0014","8.8786","0.0006","6.1655","0.0014","90","","90","","90","","338.3","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","Ammonium trifluorocadmate - low","","- Cd F3 H4 N -","- Cd F3 H4 N -","- Cd4 F12 H16 N4 -","4","0.5","","Le Bail, A.; Fourquet, J. L.; Rubin, J.; Palacios, E.; Bartolome, J.","NH~4~CdF~3~: Structure of the low temperature phase","Physica B: Condensed Matter","1990","162","3","231","236","10.1016/0921-4526(90)90017-O","","","","","","0.029","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1008488","6.538","0.002","3.793","0.002","4.082","0.002","90","","90","","90","","101.2","","","","","","","","","","","","","2","P m m m","-P 2 2","47","","Erbium silicide (2/3.3)","","- Er2 Si3.333 -","- Er2 Si3.334 -","- Er2 Si3.334 -","1","0.125","","Auffret, S.; Pierre, J.; Lambert, B.; Soubeyroux, J. L.; Chroboczek, J. A.","Crystallographic and magnetic structures of Er~3~Si~5~","Physica B: Condensed Matter","1990","162","3","271","280","10.1016/0921-4526(90)90022-M","","","","","","0.082","","","","","","","","","","","","","","","has coordinates","174782","2020-10-21","18:00:00",""