# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-09-09T03:36:52+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 'Journal of the Ceramic Society of Japan') AND volume = 96 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 "1545068","8.181","","8.181","","8.181","","90","","90","","90","","547.544","","","","","","","","","","","","","4","P 43 3 2","P 4acd 2ab 3","212","Li2NiGe3O8","","","- Ge3 Li2 Ni O8 -","- Ge3 Li2 Ni O8 -","- Ge12 Li8 Ni4 O32 -","4","0.166667","","Hirota, K.; Ohtani, M.; Mochida, N.; Ohtsuka, A.","Formation and structure of spinel solid solution in Li2O-MO-GeO2 (M=Zn,Co,Ni) system","Journal of the Ceramic Society of Japan","1988","96","","92","96","","","","","","","","","","","","","","","","","","","","","","has coordinates","190682","2020-10-21","18:00:00","" "1545069","8.193","","8.193","","8.193","","90","","90","","90","","549.957","","","","","","","","","","","","","4","P 43 3 2","P 4acd 2ab 3","212","Li2ZnGe3O8","","","- Ge3 Li2 O8 Zn -","- Ge3 Li2 O8 Zn -","- Ge12 Li8 O32 Zn4 -","4","0.166667","","Hirota, K.; Ohtani, M.; Mochida, N.; Ohtsuka, A.","Formation and structure of spinel solid solution in Li2O-MO-GeO2 (M=Zn,Co,Ni) system","Journal of the Ceramic Society of Japan","1988","96","","92","96","","","","","","","","","","","","","","","","","","","","","","has coordinates","190683","2020-10-21","18:00:00","" "1545070","8.204","","8.204","","8.204","","90","","90","","90","","552.175","","","","","","","","","","","","","4","P 43 3 2","P 4acd 2ab 3","212","Li2CoGe3O8","","","- Co Ge3 Li2 O8 -","- Co Ge3 Li2 O8 -","- Co4 Ge12 Li8 O32 -","4","0.166667","","Hirota, K.; Ohtani, M.; Mochida, N.; Ohtsuka, A.","Formation and structure of spinel solid solution in Li2O-MO-GeO2 (M=Zn,Co,Ni) system","Journal of the Ceramic Society of Japan","1988","96","","92","96","","","","","","","","","","","","","","","","","","","","","","has coordinates","190684","2020-10-21","18:00:00","" "1545123","6.31","0.01","6.31","0.01","10.25","","90","","90","","120","","353.4","0.8","","","","","","","","","","","","3","P -3","-P 3","147","Zr3SO9 anhydrous zirconium oxide sulfate","","","- O9 S Zr3 -","- O9 S Zr3 -","- O18 S2 Zr6 -","2","0.333333","","Li, C.; Daimon, K.; Murase, Y.; Kato, E.","Crystal structure of anhydrous zirconium oxide sulfate","Journal of the Ceramic Society of Japan","1988","96","","980","984","","","","","","","","","","","","","","","","","","","","","","has coordinates","190832","2020-10-21","18:00:00",""