# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-17T10:31:10+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 'Mineralogical Magazine') AND volume = 83 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 "1557166","7.0429","0.001","7.0429","0.001","11.444","0.002","90","","90","","90","","567.65","0.15","100","2","100","2","","","","","","","","4","I 4/m","-I 4","87","Bavsiite, Ba2V2O2(Si4O12), idealized","","","- Ba2 O14 Si4 V2 -","- Ba2 O14 Si4 V2 -","- Ba4 O28 Si8 V4 -","2","0.125","","Hans-Peter Bojar; Franz Walter; Judith Baumgartner","Bavsiite, Ba2V2O2[Si4O12], mineral data and crystal structure","Mineralogical Magazine","2019","83","","821","827","10.1180/mgm.2019.59","","","0.71073","MoKα","","0.0159","0.0159","","","0.0399","0.0399","","","","","","1.175","","","","has coordinates","247283","2020-10-21","18:00:00","" "1560194","9.9866","0.0007","5.67205","0.00019","12.2351","0.0014","90","","111.913","0.007","90","","642.98","0.09","293","2","293","2","","","","","","","","3","I 1 2/a 1","-I 2ya","15","carlfriesite","","","- Ca O8 Te3 -","- Ca O8 Te3 -","- Ca4 O32 Te12 -","4","0.5","","Owen P. Missen; Anthony R. Kampf; Stuart J. Mills; Robert M. Housley; John Spratt; Mark D. Welch; Mark F. Coolbaugh; Joe Marty; Marek Chorazewicz; Cristiano Ferraris","The crystal structures of the mixed-valence tellurium oxysalts tlapallite, (Ca,Pb)3CaCu6[Te4+3Te6+O12]2(Te4+O3)2(SO4)2 . 3H2O, and carlfriesite, CaTe4+2Te6+O8","Mineralogical Magazine","2019","83","","439","549","10.1180/mgm.2019.9","","","0.71075","MoKα","","0.0247","0.023","","","0.0528","0.0538","","","","","","1.298","","","","has coordinates","261186","2021-01-25","09:45:53","" "1560195","9.1219","0.0017","9.1219","0.0017","11.932","0.0009","90","","90","","120","","859.8","0.2","293","2","293","2","","","","","","","","8","P 3 2 1","P 3 2""","150","tlapallite","","","- Ca1.81 Cu3 H3 O20.5 Pb0.19 S Sb0.13 Te4.87 -","- Ca1.8065 Cu3 H3 O20.5 Pb0.1935 S Sb0.1339 Te4.8661 -","- Ca3.613 Cu6 H6 O41 Pb0.387 S2 Sb0.2678 Te9.7322 -","2","0.333333","","Owen P. Missen; Anthony R. Kampf; Stuart J. Mills; Robert M. Housley; John Spratt; Mark D. Welch; Mark F. Coolbaugh; Joe Marty; Marek Chorazewicz; Cristiano Ferraris","The crystal structures of the mixed-valence tellurium oxysalts tlapallite, (Ca,Pb)3CaCu6[Te4+3Te6+O12]2(Te4+O3)2(SO4)2 . 3H2O, and carlfriesite, CaTe4+2Te6+O8","Mineralogical Magazine","2019","83","","439","549","10.1180/mgm.2019.9","","","0.71075","MoKα","","0.0329","0.0296","","","0.0608","0.0625","","","","","","1.072","","","","has coordinates","261187","2021-01-25","09:46:10","" "9017715","11.035","","25.383","","6.411","","90","","90","","90","","1795.73","","","","","","","","","","","","Hagendorf-Sud pegmatite, Oberpfalz, Bavaria, Germany","6","P m a b","-P 2b 2a","57","","","Schmidite","- Fe2.22 H16 Mn0.94 O23 P3 Zn1.681 -","- Fe2.22 H16 Mn0.94 O23 P3 Zn1.681 -","- Fe8.88 H64 Mn3.76 O92 P12 Zn6.724 -","4","0.5","","Grey, I. E.; Keck, E.; Kampf, A. R.; Cashion, J. D.; MacRae, C. M.; Glenn, A. M.","Schmidite and wildenauerite, two new schoonerite-group minerals from the Hagendorf-Sud pegmatite, Oberpfalz, Bavaria Note: Sample IGC-1","Mineralogical Magazine","2019","83","","181","190","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:49","" "9017716","11.002","","25.31","","6.39","","90","","90","","90","","1779.36","","","","","","","","","","","","Hagendorf-Sud pegmatite, Oberpfalz, Bavaria, Germany","8","P m a b","-P 2b 2a","57","","","Schmidite","- Al0.06 Fe2.31 H16.2 Mg0.05 Mn0.88 O23 P3 Zn1.499 -","- Al0.06 Fe2.31 H16.2 Mg0.05 Mn0.88 O23 P3 Zn1.499 -","- Al0.24 Fe9.24 H64.8 Mg0.2 Mn3.52 O92 P12 Zn5.996 -","4","0.5","","Grey, I. E.; Keck, E.; Kampf, A. R.; Cashion, J. D.; MacRae, C. M.; Glenn, A. M.","Schmidite and wildenauerite, two new schoonerite-group minerals from the Hagendorf-Sud pegmatite, Oberpfalz, Bavaria Note: Sample IGC-31","Mineralogical Magazine","2019","83","","181","190","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:49","" "9017717","3.928","","3.928","","5.385","","90","","90","","120","","71.955","","","","","","","","","","","","Ognit ultramafic complex, Eastern Sayans, Russia","3","P 3 m 1","P 3 -2""","156","","","Ognitite","- Bi0.98 Ni Te -","- Bi0.98 Ni Te -","- Bi0.98 Ni Te -","","","","Barkov, A. Y.; Bindi, L.; Tamura, N.; Shvedov, G. I.; Winkler, B.; Stan, C. V.; Morgenroth, W.; Martin, R. F.; Zaccarini, F.; Stanley, C. J.","Ognitite, NiBiTe, a new mineral species, and Co-rich maucherite from the Ognit ultramafic complex, Eastern Sayans, Russia","Mineralogical Magazine","2019","83","","695","703","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:17",""