# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-01-19T00:59:21+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 'Mineralogical Magazine') AND volume = 35 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
"5000212","9.878","","5.675","","4.328","","90","","90","","90","","242.6","","","","","","","","","","","","Sri Lanka","4","P n m a","-P 2ac 2n","62","","Aluminium magnesium tetraoxoborate","Sinhalite","- Al Mg B O4 -","- Al B Mg O4 -","- Al4 B4 Mg4 O16 -","4","0.5","","Fang, J. H.; Newnham, R. E.","The Crystal Structure of Sinhalite","Mineralogical Magazine","1965","35","269","196","199","10.1180/minmag.1965.035.269.22","","","","","","0.11","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9009434","5.161","","5.161","","8.693","","90","","90","","120","","200.525","","","","","","","","","","","","Mt. Nyiragongo, Congo","4","P 63","P 6c","173","","","Kalsilite","- Al K O4 Si -","- Al K O4 Si -","- Al2 K2 O8 Si2 -","2","0.333333","","Perrotta, A. J.; Smith, J. V.","The crystal structure of kalsilite, KAlSiO4 Sample: Refinement with O2 on triad axis","Mineralogical Magazine","1965","35","","588","595","10.1180/minmag.1965.035.272.02","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009435","5.161","","5.161","","8.693","","90","","90","","120","","200.525","","","","","","","","","","","","Mt. Nyiragongo, Congo","4","P 63","P 6c","173","","","Kalsilite","- Al K O4 Si -","- Al K O3.99999 Si -","- Al2 K2 O7.99998 Si2 -","2","0.333333","","Perrotta, A. J.; Smith, J. V.","The crystal structure of kalsilite, KAlSiO4 Sample: Refinement with O2 off triad axis","Mineralogical Magazine","1965","35","","588","595","10.1180/minmag.1965.035.272.02","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""