# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-27T19:53:53+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 'Soviet Physics, Crystallography (= Kristallografiya)') AND volume = 34 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 "1539557","3.8256","","3.8256","","21.144","","90","","90","","120","","267.989","","","","","","","","","","","","","3","P -3 m 1","-P 3 2""","164","","","","- Ga1.74 In2.92 S7 -","- Ga1.74 In2.92 S7 -","- Ga1.74 In2.92 S7 -","1","0.0833333","","Amiraslanov, I.R.; Asadov, F.Yu.; Musaev, A.A.; Guseinov, G.G.","Crystal structure of the new layered semiconductor Ga1.74 In2.92 S7","Soviet Physics, Crystallography (= Kristallografiya)","1989","34","","611","612","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1539774","16.679","","16.679","","3.891","","90","","90","","120","","937.415","","","","","","","","","","","","","3","P 63/m","-P 6c","176","","","","- Nd3 Ni7 P5 -","- Nd3 Ni7.005 P5 -","- Nd12 Ni28.02 P20 -","4","0.333333","","Chikhrii, S.I.; Kuz'ma, Yu.B.; Orishchin, S.V.; Glovyak, T.","New ternary phosphides R3 Ni7 P5 (R= La, Pr, Nd, Sm, Gd, Tb)","Soviet Physics, Crystallography (= Kristallografiya)","1989","34","","681","684","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1539822","9.388","","4.046","","8.045","","90","","90","","90","","305.58","","","","","","","","","","","","","3","P m m a","-P 2a 2a","51","","Nd2 Cr9 Ge8","","- Cr9 Ge8 Nd2 -","- Cr9 Ge8 Nd2 -","- Cr9 Ge8 Nd2 -","1","0.125","","Bodak, O.I.; Gladyshevskii, E.I.; Salamakha, P.S.; Pecharskii, V.K.; Bruskov, V.A.","The crystal structure of Nd2 Cr9 Ge8","Soviet Physics, Crystallography (= Kristallografiya)","1989","34","","774","775","","","","","","","","","","","","","","","","","","","","","","has coordinates","168875","2020-10-21","18:00:00","" "1541103","7.3419","","4.239","","7.9315","","90","","128.1","","90","","194.252","","","","","","","","","","","","","3","C 1 2/m 1","-C 2y","12","","Li4 Pd5.48 Ge4.526","","- Ge4.526 Li4 Pd5.48 -","- Ge4.526 Li4 Pd5.48 -","- Ge4.526 Li4 Pd5.48 -","1","0.125","","Pavlyuk, V.V.; Pecharskii, V.K.; Bodak, O.I.","Crystal structure of Li2 Pd2.7 Ge2.3","Soviet Physics, Crystallography (= Kristallografiya)","1989","34","","179","181","","","","","","","","","","","","","","","","","","","","","","has coordinates","172333","2020-10-21","18:00:00",""