# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T10:50:50+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 = 108 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
"1522137","12.457","","12.457","","3.942","","90","","90","","90","","611.707","","","","","","","","","","","","","5","P 4 b m","P 4 -2ab","100","","Ba3.75 (Y0.833 Sm0.833)0.5 Nb10 O30","","- Ba3.75 Nb10 O30 Sm0.4165 Y0.4165 -","- Ba3.75 Nb10 O30 Sm0.4166 Y0.4166 -","- Ba3.75 Nb10 O30 Sm0.4166 Y0.4166 -","1","0.125","","Wang, J.-K.; Mizutani, N.; Wakiya, N.; Shinozaki, K.","Structural and ferroelectric properties of (1-X)(Ba~3.75~Y~0.83~Nb~10~O~30~) - X(Ba~3.75~Sm~0.83~Nb~10~O~30~) solid solutions","Journal of the Ceramic Society of Japan","2000","108","1253","36","39","10.2109/jcersj.108.36","","","","","","","","","","","","","","","","","","","","","has coordinates","175216","2020-10-21","18:00:00",""
"1544435","5.7411","0.0006","5.7411","0.0006","7.044","0.0007","90","","90","","120","","201.07","0.04","","","","","","","","","","","","4","R 3 m :H","R 3 -2""","160","PbZn0.333Nb0.667O3","","","- Nb0.667 O3 Pb Zn0.333 -","- Nb0.6667 O3 Pb0.999 Zn0.3333 -","- Nb2.0001 O9 Pb2.997 Zn0.9999 -","3","0.166667","","Matsushima, Y.; Ishizawa, N.; Wakiya, N.; Mizutani, N.","Structural study of PbZn1/3Nb2/3O3 by single crystal X-ray diffraction an EXAFS","Journal of the Ceramic Society of Japan","2000","108","","617","622","","","","","","","","","","","","","","","","","","","","","","has coordinates","208816","2020-10-21","18:00:00",""