# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-01T11:27:25+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 'Applied Physics Letters') AND volume = 80 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 "1531751","5.531","","5.534","","24.98","","90","","90","","90","","764.602","","","","","","","","","","","","","4","A 21 a m","A -2 2a","36","","Sr (Bi2 Ta2 O9)","","- Bi2 O9 Sr Ta2 -","- Bi2 O9 Sr Ta2 -","- Bi8 O36 Sr4 Ta8 -","4","0.5","","Miura, K.","Electronic properties of ferroelectric Sr Bi2 Ta2 O9, Sr Bi2 Nb2 O9 and Pb Bi2 Nb2 O9","Applied Physics Letters","2002","80","","2967","2969","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1531753","5.506","","5.506","","25","","90","","90","","90","","757.901","","","","","","","","","","","","","4","A 21 a m","A -2 2a","36","","Sr Bi2 (Nb2 O9)","","- Bi2 Nb2 O9 Sr -","- Bi2 Nb2 O9 Sr -","- Bi8 Nb8 O36 Sr4 -","4","0.5","","Miura, K.","Electronic properties of ferroelectric Sr Bi2 Ta2 O9, Sr Bi2 Nb2 O9and Pb Bi2 Nb2 O9","Applied Physics Letters","2002","80","","2967","2969","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1531756","5.496","","5.496","","25.55","","90","","90","","90","","771.764","","","","","","","","","","","","","4","A 21 a m","A -2 2a","36","","Pb Bi2 (Nb2 O9)","","- Bi2 Nb2 O9 Pb -","- Bi2 Nb2 O9 Pb -","- Bi8 Nb8 O36 Pb4 -","4","0.5","","Miura, K.","Electronic properties of ferroelectric Sr Bi2 Ta2 O9, Sr Bi2 Nb2 O9 and Pb Bi2 Nb2 O9","Applied Physics Letters","2002","80","","2967","2969","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1532431","10.72768","","10.72768","","10.72768","","90","","90","","90","","1234.57","","","","","","","","","","","","","4","P m -3 n","-P 4n 2 3","223","","Sr4.53 Eu3.47 Ga14.48 Ge31.52","","- Eu3.47 Ga14.48 Ge31.52 Sr4.53 -","- Eu3.464 Ga14.478 Ge31.522 Sr4.536 -","- Eu3.464 Ga14.478 Ge31.522 Sr4.536 -","1","0.0208333","","Zhang, Y.; Lee, P.-L.; Wilkinson, A.P.; Nolas, G.S.","Gallium distribution in the clathrates Sr8 Ga16 Ge30 and Sr4 Eu4 Ga16 Ge30 by resonant diffraction","Applied Physics Letters","2002","80","","2931","2933","","","","","","","","","","","","","","","","","","","","","","has coordinates","158143","2020-10-21","18:00:00",""