# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-01T00:39:42+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 = 31 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 "1511666","3.202","","18.432","","8.917","","90","","90","","90","","526.275","","","","","","","","","","","","","3","C m c m","-C 2c 2","63","","Co4 Nb3 B7","","- B7 Co4 Nb3 -","- B7 Co4 Nb3 -","- B28 Co16 Nb12 -","4","0.25","","Kuz'ma, Yu.B.; Aksel'rud, L.V.","Crystal structure of the boride Nb3 Co4 B7","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","108","110","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1540316","17.949","","12.223","","8.029","","90","","90","","90","","1761.49","","","","","","","","","","","","","3","I m m m","-I 2 2","71","","","","- Ni18 Sc6 Si11 -","- Ni18 Sc6 Si11 -","- Ni72 Sc24 Si44 -","4","0.25","","Kotur, B.Ya.; Gladyshevskii, E.I.; Sikiritsa, M.","Structure of the silicide Sc6 Ni18 Si11 - a new structural type of intermetallic compound","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","470","472","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1540787","6.679","","6.341","","7.672","","90","","130.32","","90","","247.734","","","","","","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","","","- Ga La Ni -","- Ga La Ni -","- Ga4 La4 Ni4 -","4","1","","Yarmolyuk, Ya.P.; Grin', Yu.N.; Vasilechko, L.O.; Bel'skii, V.K.","Crystal structure of the compound La Ga Ni","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","106","108","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1540788","13.784","","13.784","","4.229","","90","","90","","90","","803.504","","","","","","","","","","","","","3","P 4/m b m","-P 4 2ab","127","","","","- Al7 Co6 Pr7 -","- Al7 Co6 Pr7 -","- Al14 Co12 Pr14 -","2","0.125","","Yarmolyuk, Ya.P.; Zarechnyuk, O.S.; Aksel'rud, L.G.; Rozhdestvenskaya, I.V.; Rykhal', R.M.","Crystal structure of Pr7 Co6 Al7 - a representative of the family R7 Co6 Al7 (R= Pr, Nd, Sm)","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","230","231","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541065","3.355","","3.355","","16.776","","90","","90","","120","","163.533","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Al3 Sc C3","","- C3 Al3 Sc -","- C3 Al3 Sc -","- C6 Al6 Sc2 -","2","0.0833333","","Tsokol', A.O.; Bodak, O.I.; Marusin, E.P.; Baivel'man, M.G.","Crystal structure of the compound Sc Al3 C3","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","467","468","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1541066","8.331","","8.331","","4.0283","","90","","90","","90","","279.586","","","","","","","","","","","","","3","P 4/m b m","-P 4 2ab","127","","La2 Ni5 C3","","- C3 La2 Ni5 -","- C3 La2 Ni5 -","- C6 La4 Ni10 -","2","0.125","","Tsokol', A.O.; Bodak, O.I.; Marusin, E.P.","Crystal structure of the compound R2 Ni5 C3 (R= La, Ce)","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","39","41","","","","","","","","","","","","","","","","","","","","","","has coordinates","172287","2020-10-21","18:00:00","" "1541109","18.637","","4.384","","14.191","","90","","106.13","","90","","1113.83","","","","","","","","","","","","","3","C 1 2/m 1","-C 2y","12","","La11 Ni4 Ge6","","- Ge6 La11 Ni4 -","- Ge6 La11 Ni4 -","- Ge12 La22 Ni8 -","2","0.25","","Pecharskii, V.K.; Bodak, O.I.; Bruskov, V.A.","Crystal structure of the compound La11 Ni4 Ge6 and some systematic aspects of structures with trigonal-prismatic coordination of atoms","Soviet Physics, Crystallography (= Kristallografiya)","1986","31","","184","186","","","","","","","","","","","","","","","","","","","","","","has coordinates","172340","2020-10-21","18:00:00",""