# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-17T23:15:51+02: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 'Zapiski Rossiiskogo Mineralogicheskogo Obshchetstva') AND volume = 141 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 "9017836","10.0959","","10.0959","","14.3282","","90","","90","","120","","1264.77","","","","","","","","","","","","Bellerberg, Eifel volcanic area, Germany","9","P 6/m c c","-P 6 2c","192","","","Osumilite-(Mg)","- Al4.23 Ca0.01 Fe0.45 K0.72 Mg1.96 Mn0.04 Na0.03 O30 Si10.32 -","- Al8.46 Ca0.02 Fe0.9 K1.44 Mg3.92 Mn0.08 Na0.06 O60 Si20.64 -","- Al8.46 Ca0.02 Fe0.9 K1.44 Mg3.92 Mn0.08 Na0.06 O60 Si20.64 -","","","","Chukanov, N. V.; Pekov, I. V.; Rastsvetaeva, R. K.; Aksenov, S. M.; Belakovskiy, D. I.; Van, K. V.; Schuller, V.; Ternes, B.","Osumilite-(Mg): Validation as a mineral species and new data","Zapiski Rossiiskogo Mineralogicheskogo Obshchetstva","2012","141","","27","36","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:25","" "9017838","8.743","","8.698","","11.581","","91.54","","98.29","","105.65","","837.184","","","","","","","","","","","","Lovozero alkaline massif, Kola Peninsula, Russia","14","P -1","-P 1","2","","","Vigrishinite","- Ba0.04 Ca0.12 Fe0.36 H1.6 K0.16 Mg0.14 Mn0.44 Na0.46 Nb0.82 O41.42 Si8 Ti5.32 Zn2.62 Zr0.24 -","- Ba0.04 Ca0.12 Fe0.36 H1.6 K0.16 Mg0.14 Mn0.44 Na0.46 Nb0.82 O41.42 Si8 Ti5.32 Zn2.62 Zr0.24 -","- Ba0.04 Ca0.12 Fe0.36 H1.6 K0.16 Mg0.14 Mn0.44 Na0.46 Nb0.82 O41.42 Si8 Ti5.32 Zn2.62 Zr0.24 -","1","0.5","","Pekov, I. V.; Britvin, S. N.; Zubkova, N. V.; Chukanov, N. V.; Bryzfalov, I. A.; Lykova, I. S.; Belakovskiy, D. I.; Pushcharovsky, D. Y.","Vigrishinite, Zn2Ti4-xSi4O14(OH,H2O,[_])8, a new mineral from Lovozero alkaline massif (Kola Peninsula, Russia)","Zapiski Rossiiskogo Mineralogicheskogo Obshchetstva","2012","141","","12","27","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53","" "9017839","4.7281","","4.7281","","7.9936","","90","","90","","120","","154.756","","","","","","","","","","","","Tolbachik volcano, Kamchatka, Russia","5","P 3 1 2","P 3 2","149","","","Steklite","- Al0.89 Fe0.11 K O8 S2 -","- Al0.89 Fe0.11 K O8 S2 -","- Al0.89 Fe0.11 K O8 S2 -","","","","Murashko, M. N.; Pekov, I. V.; Krivovichev, S. V.; Chernyatyeava, A. P.; Yapaskurt, V. O.; Zadov, A. E.; Zelensky, M. E.","Steklite, KAl(SO4)2: the find at Tolbachik volcano (Kamchatka, Russia). Validation as a mineral species and crystal structure","Zapiski Rossiiskogo Mineralogicheskogo Obshchetstva","2012","141","","36","44","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:26",""