# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-01T02:40:18+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 'Soviet Physics, Crystallography (= Kristallografiya)') AND volume = 30 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 "1540199","4.388","","7.574","","12.11","","90","","90","","90","","402.472","","","","","","","","","","","","","3","P m m n :1","P 2 2ab -1ab","59","","La Ni3 In6","","- In6 La Ni3 -","- In6 La Ni3 -","- In12 La2 Ni6 -","2","0.25","","Kalychak, Ya.M.; Gladyshevskii, E.I.; Bodak, O.I.; Dmytrakh, O.V.; Kotur, B.Ya.","Crystal structure of La Ni3 In6, Ce Ni3 In6, and Pr Ni3 In6","Soviet Physics, Crystallography (= Kristallografiya)","1985","30","","344","345","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1540315","9.757","","9.757","","13.884","","90","","90","","90","","1321.74","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","","","- Cr4.8 Sc7 Si9.2 -","- Cr4.8 Sc7 Si9.2 -","- Cr19.2 Sc28 Si36.8 -","4","0.125","","Kotur, B.Ya.; Bodak, O.I.; Zavodnik, V.E.","The silicide Sc7 Cr4+x Si10-x (x=0.8): the first representative of a superlattice structure of the Ho11Ge10 type","Soviet Physics, Crystallography (= Kristallografiya)","1985","30","","521","523","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1540985","9.617","","9.617","","9.821","","90","","90","","120","","786.621","","","","","","","","","","","","","3","P -3 m 1","-P 3 2""","164","","","","- Co6 Ho7 Sn23 -","- Co6 Ho7 Sn23 -","- Co6 Ho7 Sn23 -","1","0.0833333","","Skolozdra, R.V.; Koretskaya, O.E.; Aksel'rud, L.G.","Crystal structure of Ho7 Co6 Sn23","Soviet Physics, Crystallography (= Kristallografiya)","1985","30","","584","585","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""