# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-15T08:19:40+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 (1969-)') AND volume = 50 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 "1509895","10.61","","10.61","","10.61","","90","","90","","90","","1194.39","","","","","","","","","","","","","5","I -4 3 m","I -4 2 3","217","","Cu6 (Ag4.32 Fe1.68) Sb4 S13","","- Ag4.32 Cu6 Fe1.68 S13 Sb4 -","- Ag4.32 Cu6 Fe1.68 S13 Sb4 -","- Ag8.64 Cu12 Fe3.36 S26 Sb8 -","2","0.0416667","","Miller, I.; Peterson, R.C.","Crystal structure and cation distribution in Freibergite and Tetrahedrite","Mineralogical Magazine (1969-)","1986","50","","717","721","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "9009467","15.065","","15.065","","24.436","","90","","90","","90","","5545.85","","","","","","","","","","","","Boleo, Baja California, Mexico","5","I 4/m m m","-I 4 2","139","","","Cumengeite","- Cl42 Cu20 H40 O40 Pb21 -","- Cl42 Cu20 H40 O40 Pb21 -","- Cl84 Cu40 H80 O80 Pb42 -","2","0.0625","","Hawthorne, F. C.; Groat, L. A.","The crystal structure and chemical composition of cumengeite","Mineralogical Magazine","1986","50","","157","162","10.1180/minmag.1986.050.355.21","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47","" "9009468","10.61","","10.61","","10.61","","90","","90","","90","","1194.39","","","","","","","","","","","","Keno Hill, Yukon, Canada","7","I -4 3 m","I -4 2 3","217","","","Freibergite","- Ag4.2 As0.12 Cu5.82 Fe1.56 S13 Sb3.88 Zn0.42 -","- Ag4.2 As0.12 Cu5.82 Fe1.56 S13 Sb3.88 Zn0.42 -","- Ag8.4 As0.24 Cu11.64 Fe3.12 S26 Sb7.76 Zn0.84 -","2","0.0416667","","Peterson, R. C.; Miller, I.","Crystal structure and cation distribution in freibergite and tetrahedrite","Mineralogical Magazine","1986","50","","717","721","10.1180/minmag.1986.050.358.19","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009469","10.364","","10.364","","10.364","","90","","90","","90","","1113.22","","","","","","","","","","","","Turquetil Lake, Northwest Territories, Canada","6","I -4 3 m","I -4 2 3","217","","","Tetrahedrite","- As0.28 Cu10.08 Fe0.96 S13 Sb3.72 Zn0.96 -","- As0.28 Cu10.08 Fe0.96 S13 Sb3.72 Zn0.96 -","- As0.56 Cu20.16 Fe1.92 S26 Sb7.44 Zn1.92 -","2","0.0416667","","Peterson, R. C.; Miller, I.","Crystal structure and cation distribution in freibergite and tetrahedrite","Mineralogical Magazine","1986","50","","717","721","10.1180/minmag.1986.050.358.19","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9011797","7.318","","7.318","","7.318","","90","","90","","90","","391.902","","","","","","","","","","","","Ambatofinandrahana, Ankarata Mts, Madagascar","8","P -4 3 m","P -4 2 3","215","","","Rhodizite","- Al4 B11.35 Be4.56 Cs0.36 K0.46 Na0.02 O28 Rb0.06 -","- Al4 B11.3496 Be4.5604 Cs0.36 K0.46 Na0.02 O28 Rb0.06 -","- Al4 B11.3496 Be4.5604 Cs0.36 K0.46 Na0.02 O28 Rb0.06 -","1","0.0416667","","Pring, A.; Din, V. K.; Jefferson, D. A.; Thomas, J. M.","The crystal chemistry of rhodizite: a re-examination","Mineralogical Magazine","1986","50","","163","172","10.1180/minmag.1986.050.355.22","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45","" "9014872","5.533","","13.565","","25.09","","90","","94","","90","","1878.55","","","","","","","","","","","","Harstig mine, Pajsberg, Sweden","5","A 1 2/a 1","-A 2ya","15","","","Ganophyllite","- H K0.27 Mn2 O9.47 Si3.36 -","- K0.27 Mn2 O9.47 Si3.36 -","- K2.16 Mn16 O75.76 Si26.88 -","8","1","","Eggleton, R. A.; Guggenheim, S.","A re-examination of the structure of ganophyllite","Mineralogical Magazine","1986","50","","307","315","10.1180/minmag.1986.050.356.18","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18",""