# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-07T14:30:15+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 'Materials Chemistry and Physics') 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 "1001502","5.172","0.002","5.172","0.002","13.847","0.006","90","","90","","120","","320.8","","","","","","","","","","","","","4","R 3 :H","R 3","146","","Dilithium zirconium tellurate","","- Li2 O6 Te Zr -","- Li2 O6 Te Zr -","- Li6 O18 Te3 Zr3 -","3","0.333333","","Archaimbault, F; Choisnet, J; Rulmont, A; Tarte, P","Lithium defect and ordering phenomena in the new LiNbO~3~ like mixed tellurates: Li~2-x~(Zr^4+^,Nb^5+^,Te^6+^)~2~O~6~ (x<0.5)","Materials Chemistry and Physics","1992","30","","245","252","10.1016/0254-0584(92)90232-W","","","","","","0.043","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1001503","5.1732","0.0025","5.1732","0.0005","13.8508","0.0007","90","","90","","120","","321","","","","","","","","","","","","","4","R 3 :H","R 3","146","","Dilithium zirconium tellurate","","- Li2 O6 Te Zr -","- Li2 O6 Te Zr -","- Li6 O18 Te3 Zr3 -","3","0.333333","","Archaimbault, F; Choisnet, J; Rulmont, A; Tarte, P","Lithium defect and ordering phenomena in the new LiNbO~3~ like mixed tellurates: Li~2-x~(Zr^4+^,Nb^5+^,Te^6+^)~2~O~6~ (x<0.5)","Materials Chemistry and Physics","1992","30","","245","252","10.1016/0254-0584(92)90232-W","","","","","","0.06","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1001504","5.167","0.002","5.167","0.002","13.795","0.006","90","","90","","120","","319","","","","","","","","","","","","","5","R 3 :H","R 3","146","","Lithium zirconium niobium tellurium(VI) oxide (1.75/.75/.25/1/6)","","- Li1.75 Nb0.25 O6 Te Zr0.75 -","- Li1.75 Nb0.25 O6 Te Zr0.75 -","- Li5.25 Nb0.75 O18 Te3 Zr2.25 -","3","0.333333","","Archaimbault, F; Choisnet, J; Rulmont, A; Tarte, P","Lithium defect and ordering phenomena in the new LiNbO~3~ like mixed tellurates: Li~2-x~(Zr^4+^,Nb^5+^,Te^6+^)~2~O~6~ (x<0.5)","Materials Chemistry and Physics","1992","30","","245","252","10.1016/0254-0584(92)90232-W","","","","","","0.035","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1001505","5.148","0.003","5.148","0.003","13.763","0.008","90","","90","","120","","315.9","","","","","","","","","","","","","4","R 3 c :H","R 3 -2""c","161","","Lithium niobium tellurium(VI) oxide (1.75/1.75/0.25/6)","","- Li1.75 Nb1.75 O6 Te0.25 -","- Li1.75 Nb1.75 O6 Te0.25 -","- Li5.25 Nb5.25 O18 Te0.75 -","3","0.166667","","Archaimbault, F; Choisnet, J; Rulmont, A; Tarte, P","Lithium defect and ordering phenomena in the new LiNbO~3~ like mixed tellurates: Li~2-x~(Zr^4+^,Nb^5+^,Te^6+^)~2~O~6~ (x<0.5)","Materials Chemistry and Physics","1992","30","","245","252","10.1016/0254-0584(92)90232-W","","","","","","0.047","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""