# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-28T03:59:47+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 the Ceramic Society of Japan') AND volume = 104 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 "1544429","3.7718","0.0002","3.7718","0.0002","12.0829","0.0006","90","","90","","90","","171.897","0.015","","","","","","","","","","","","4","P 4/n m m","P 4ab 2ab -1ab","129","LiLaTiO4","","","- La Li O4 Ti -","- La Li O4 Ti -","- La2 Li2 O8 Ti2 -","2","","","Toda, K.; Kurita, S.; Sato, M.","New layered perovskite compounds, LiLa2TiO4 and LiEuTiO4","Journal of the Ceramic Society of Japan","1996","104","","140","142","","","","","","","","","","","","","","","","","","","","","","has coordinates","187735","2020-10-21","18:00:00","" "1544430","11.4155","0.0007","5.355","0.001","5.353","0.001","90","","90","","90","","327.23","0.09","","","","","","","","","","","","4","P b c m","-P 2c 2b","57","LiEuTiO4","","","- Eu Li O4 Ti -","- Eu Li O4 Ti -","- Eu4 Li4 O16 Ti4 -","4","0.5","","Toda, K.; Kurita, S.; Sato, M.","New layered perovskite compounds, LiLa2TiO4 and LiEuTiO4","Journal of the Ceramic Society of Japan","1996","104","","140","142","","","","","","","","","","","","","","","","","","","","","","has coordinates","187736","2020-10-21","18:00:00","" "1544434","3.596","0.001","20.111","0.002","14.1092","0.0009","90","","92.12","0.02","90","","1019.7","0.3","","","","","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","C3N6H6 2H3BO3 melamine diborate","","","- C3 H12 B2 N6 O6 -","- C3 H12 B2 N6 O6 -","- C12 H48 B8 N24 O24 -","4","1","","Kawasaki, T.; Kuroda, Y.; Nishikawa, H.","The crystal structure of melamine diborate","Journal of the Ceramic Society of Japan","1996","104","","935","038","","","","","","","","","","","","","","","","","","","","","","has coordinates","187740","2020-10-21","18:00:00",""