# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-03-11T17:09:34+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 'Physics and Chemistry of Minerals') AND volume = 8 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
"9005767","8.0806","","8.0806","","8.0806","","90","","90","","90","","527.632","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","","Spinel","- Al2 Mg O4 -","- Al2 Mg O4 -","- Al16 Mg8 O32 -","8","0.0416667","","Ishii, M.; Hiraishi, J.; Yamanaka, T.","Structure and lattice vibrations of Mg-Al spinel solid solution Sample: Stoichiometric MgO.Al2O3","Physics and Chemistry of Minerals","1982","8","","64","68","10.1007/BF00309015","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:42",""
"9005768","8.0878","","8.0878","","8.0878","","90","","90","","90","","529.043","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","","Spinel","- Al2.401 Mg0.398 O4 -","- Al2.401 Mg0.398 O4 -","- Al19.208 Mg3.184 O32 -","8","0.0416667","","Ishii, M.; Hiraishi, J.; Yamanaka, T.","Structure and lattice vibrations of Mg-Al spinel solid solution Sample: Nonstoichiometric MgO.3Al2O3","Physics and Chemistry of Minerals","1982","8","","64","68","10.1007/BF00309015","","","","","","","","","","","","","","","","","","","","","has coordinates","294031","2024-08-07","17:26:33",""