# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-01T15:28:39+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 = 140 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
"9015215","6.306","","8.643","","11.31","","90","","92.26","","90","","615.947","","","","","","","","","","","","Second cinder cone, North Branch, Tolbach volcano, Kamchatka, Russia","3","P 1 21/c 1","-P 2ybc","14","","","Lammerite-beta","- As2 Cu3 O8 -","- As2 Cu3 O8 -","- As8 Cu12 O32 -","4","1","","Starova, G. L.; Vergasova, L. P.; Filatov, S. K.; Britvin S N. Ananyev V V","Lammerite-beta, Cu3(AsO4)2 - a new mineral from fumaroles of the Great Fissure Tolbachic eruption (Kamchatka, Russia)","Zapiski Rossiiskogo Mineralogicheskogo Obshchetstva","2011","140","","46","51","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""
"9016243","13.668","","5.6601","","11.743","","90","","113.64","","90","","832.229","","","","","","","","","","","","Dellen pumice quarry, Eifel Mountains, Rhineland-Palatinate, Germany","9","P 1 21/a 1","-P 2yab","14","","","Perrierite-(La)","- Al0.5 Ca0.6 Fe La3.4 Mn0.5 Nb0.5 O22 Si4 Ti2.5 -","- Al0.5 Ca0.6 Fe La3.4 Mn0.5 Nb0.5 O22 Si4 Ti2.5 -","- Al Ca1.2 Fe2 La6.8 Mn Nb O44 Si8 Ti5 -","2","0.5","","Chukanov, N. V.; Blass, G.; Pekov, I. V.; Belakovskiy, D. I.; Van, K. V.; Rastsvetaeva, R. K.; Aksenov, S. M.","Perrierite-(La) (La,Ce,Ca)4Fe2+(Ti,Fe)4(Si2O7)2O8 - a new mineral species from volcanic region Eifel, Germany","Zapiski Rossiiskogo Mineralogicheskogo Obshchetstva","2011","140","","34","44","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54",""