# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T07:16:01+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 'Chemistry of Materials (1,1989-)') AND volume = 9 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
"4001750","9.563","","9.563","","7.575","","90","","90","","120","","599.931","","","","","","","","","","","","","5","R 3 2 :H","R 3 2""","155","","(Y0.5 Bi0.5) Fe3 (B O3)4","","- B4 Bi0.5 Fe3 O12 Y0.5 -","- B4 Bi0.5 Fe3 O12 Y0.5 -","- B12 Bi1.5 Fe9 O36 Y1.5 -","3","0.166667","","Cascales, C.; Monge, M.A.; Ruiz-Valero, C.; Gutierrez-Puebla, E.; Campa, J.A.; Rasines, I.","Crystal structure, magnetic order, and vibrational behavior in iron rare-earth borates","Chemistry of Materials (1,1989-)","1997","9","","237","240","","","","","","","","","","","","","","","","","","","","","","has coordinates","178377","2020-10-21","18:00:00",""
"4001752","9.592","","9.592","","7.597","","90","","90","","120","","605.328","","","","","","","","","","","","","4","R 3 2 :H","R 3 2""","155","","La Fe3 (B O3)4","","- B4 Fe3 La O12 -","- B4 Fe3 La O12 -","- B12 Fe9 La3 O36 -","3","0.166667","","Campa, J.A.; Rasines, I.; Cascales, C.; Ruiz-Valero, C.; Monge, M.A.; Gutierrez-Puebla, E.","Crystal structure, magnetic order, and vibrational behavior in iron rare-earth borates","Chemistry of Materials (1,1989-)","1997","9","","237","240","","","","","","","","","","","","","","","","","","","","","","has coordinates","176467","2020-10-21","18:00:00",""
"4001753","9.578","","9.578","","7.605","","90","","90","","120","","604.198","","","","","","","","","","","","","4","R 3 2 :H","R 3 2""","155","","Nd Fe3 (B O3)4","","- B4 Fe3 Nd O12 -","- B4 Fe3 Nd O12 -","- B12 Fe9 Nd3 O36 -","3","0.166667","","Monge, M.A.; Rasines, I.; Gutierrez-Puebla, E.; Ruiz-Valero, C.; Cascales, C.; Campa, J.A.","Crystal structure, magnetic order, and vibrational behavior in iron rare-earth borates","Chemistry of Materials (1,1989-)","1997","9","","237","240","","","","","","","","","","","","","","","","","","","","","","has coordinates","176467","2020-10-21","18:00:00",""