# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2025-12-06T12:56:21+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 'Journal of Physics: Condensed Matter') AND volume = 17 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 "1528905","15.161","","8.756","","17.428","","90","","96.64","","90","","2298.04","","","","","","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","(C (N H2)3)3 (Sb2 Cl9)","","- C3 H18 Cl9 N9 Sb2 -","- C3 H18 Cl9 N9 Sb2 -","- C12 H72 Cl36 N36 Sb8 -","4","0.5","","Szklarz, P.; Zaleski, J.; Falinska, K.; Jakubas, R.; Medycki, W.; Bator, G.","The structure, phase transition and molecular dynamics of [C (N H2)3]3 [Sb2 Br9]","Journal of Physics: Condensed Matter","2005","17","","2509","2528","","","","","","","","","","","","","","","","","","","","","","has coordinates","151721","2020-10-21","18:00:00","" "1528906","15.725","","9.04","","18.681","","90","","96.68","","90","","2637.55","","","","","","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","(C (N H2)3)3 (Sb2 Br9)","","- C3 H18 Br9 N9 Sb2 -","- C3 H18 Br9 N9 Sb2 -","- C12 H72 Br36 N36 Sb8 -","4","0.5","","Szklarz, P.; Jakubas, R.; Zaleski, J.; Bator, G.; Falinska, K.; Medycki, W.","The structure, phase transition and molecular dynamics of [C (N H2)3]3 [Sb2 Br9]","Journal of Physics: Condensed Matter","2005","17","","2509","2528","","","","","","","","","","","","","","","","","","","","","","has coordinates","151722","2020-10-21","18:00:00",""