# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-28T06:30:53+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 Asian Ceramic Societies') AND volume = 2 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 "1544910","5.5406","0.0006","5.5406","0.0006","5.34","0.001","90","","90","","120","","141.97","0.03","","","","","","","","","","","","3","P -3 1 m","-P 3 2","162","SrBi2O6","","SrBi2O6","- Bi2 O6 Sr -","- Bi2 O6 Sr -","- Bi2 O6 Sr -","1","0.0833333","","Kumada, N.; Miura, A.; Takei, T.; Yashima, M.","Crystal structures of a pentavalent bismuthate, SrBi2O6 and a lead bismuth oxide (Pb1/3Bi2/3)O1.4","Journal of Asian Ceramic Societies","2014","2","","150","153","","","","","","","","","","","","","","","","","","","","","","has coordinates","189474","2020-10-21","18:00:00","" "1544911","5.532","0.001","5.532","0.001","5.532","0.001","90","","90","","90","","169.3","0.05","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","Pb1/3Bi2/3O1.4","","Pb1/3Bi2/3O1.4","- Bi0.667 O1.4 Pb0.333 -","- Bi0.6667 O1.36 Pb0.3333 -","- Bi2.6668 O5.44 Pb1.3332 -","4","0.0208333","","Kumada, N.; Miura, A.; Takei, T.; Yashima, M.","Crystal structures of a pentavalent bismuthate, SrBi2O6 and a lead bismuth oxide (Pb1/3Bi2/3)O1.4","Journal of Asian Ceramic Societies","2014","2","","150","153","","","","","","","","","","","","","","","","","","","","","","has coordinates","189475","2020-10-21","18:00:00",""