# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T13:35:29+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 'Mineralogy and Petrology') AND volume = 114 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
"9017754","9.416","","5.3","","10.893","","90","","91.77","","90","","543.354","","","","","","","","","","","","Lavrion Mining District, Greece","5","P 1 c 1","P -2yc","7","","","Stergiouite","- As2 Ca H8 O12 Zn2 -","- As4 Ca2 H16 O24 Zn4 -","- As4 Ca2 H16 O24 Zn4 -","","","","Rieck, B.; Giester, G.; Lengauer, C. L.; Chanmuang, N. C.; Topa, D.","Stergiouite, CaZn2(AsO4)2*4H2O - a new mineral from the Lavrion Mining District, Greece","Mineralogy and Petrology","2020","114","","319","327","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:20",""
"9017755","9.9587","","18.2524","","5.3409","","90","","105.02","","90","","937.649","","","","","","","","","","","","Keshiketeng Banner, Inner Mongolia, China","12","C 1 2/m 1","-C 2y","12","","","Potassic-hastingsite","- Al2.148 Ca2.07 Cl0.86 Fe4.68 H1.14 K0.61 Mg0.06 Mn0.06 Na0.2 O23.14 Si5.972 Ti0.04 -","- Al2.148 Ca2.07 Cl0.86 Fe4.68 K0.61 Mg0.06 Mn0.06 Na0.2 O23.14 Si5.972 Ti0.04 -","- Al4.296 Ca4.14 Cl1.72 Fe9.36 K1.22 Mg0.12 Mn0.12 Na0.4 O46.28 Si11.944 Ti0.08 -","2","0.25","","Ren, G.; Li, G.; Shi, J.; Gu, X.; Fan, G.; Yu, A.; Liu, Q.; Shen, G.","Potassic-hastingsite, KCa2(Fe2+4Fe3+)(Si6Al2)O22(OH)2, from the Keshiketeng Banner, Inner Mongolia, China: description of the neotype and its implication","Mineralogy and Petrology","2020","114","","403","412","","","","","","","","","","","","","","","","","","","","","","has coordinates","284046","2023-05-28","13:40:52",""
"9017756","9.7856","","9.7856","","10.7582","","90","","90","","90","","1030.18","","","","","","","","","","","","Tsangli chromitites, Othrys ophiolite, Greece","6","I 4/m m m","-I 4 2","139","","","Arsenotucekite","- As0.65 Co1.08 Fe0.72 Ni16.2 S16 Sb3.35 -","- As1.3 Co2.16 Fe1.44 Ni32.4 S32 Sb6.7 -","- As1.3 Co2.16 Fe1.44 Ni32.4 S32 Sb6.7 -","","","","Zaccarini, F.; Luca Bindi, L.; Tsikouras, B.; Grammatikopoulos, T.; Stanley, C. J.; Garuti, G.","Arsenotucekite, Ni18Sb3AsS16, a new mineral from the Tsangli chromitites, Othrys ophiolite, Greece","Mineralogy and Petrology","2020","114","","435","442","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:20",""
"9017757","5.0052","","7.9921","","13.5969","","90","","90","","90","","543.904","","","","","","","","","","","","Roter Bar mine, Harz Mountains, Germany","4","P 21 21 21","P 2ac 2ab","19","","","Roterbarite","- Bi Cu Pd Se3 -","- Bi4 Cu4 Pd4 Se12 -","- Bi4 Cu4 Pd4 Se12 -","","","","Vymazalova, A.; Cabral, A. R.; Laufek, F.; Liebmann, W.; Stanley, C. J.; Lehmann, B.","Roterbarite, PdCuBiSe3, a new mineral species from the Roter Bar mine, Harz Mountains, Germany","Mineralogy and Petrology","2020","114","","443","451","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:20",""