# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-15T00:27:08+01: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 = 41 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 "1530076","9.8659","","18.01389","","5.3545","","90","","105.082","","90","","918.84","","","","","","","","","","","","","10","C 1 2/m 1","-C 2y","12","","Na0.82 K0.30 Ca1.74 (Mg1.17 Fe3.00 Ti0.39 Al0.58) Si5.27 Al2.73 O22.56 (O H)1.44","","- Al3.31 Ca1.74 Fe3 H1.44 K0.3 Mg1.17 Na0.82 O24 Si5.27 Ti0.39 -","- Al3.3 Ca1.74 Fe2.963 K0.3 Mg1.207 Na0.82 O24 Si5.28 Ti0.39 -","- Al6.6 Ca3.48 Fe5.926 K0.6 Mg2.414 Na1.64 O48 Si10.56 Ti0.78 -","2","0.25","","Hawthorne, F.C.; Grundy, H.D.","The crystal chemistry of the amphiboles. Refinement of the crystal structure of a sub-silicic hastingsite","Mineralogical Magazine (1969-)","1977","41","","43","50","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "9009455","10.458","","5.75","","6.693","","90","","97.79","","90","","398.759","","","","","","","","","","","","Mendip Hills, Somerset, England","5","P 1 21/m 1","-P 2yb","11","","","Chloroxiphite","- Cl2 Cu H2 O4 Pb3 -","- Cl2 Cu H2 O4 Pb3 -","- Cl4 Cu2 H4 O8 Pb6 -","2","0.5","","Finney, J. J.; Graeber, E. J.; Rosenzweig, A.; Hamilton, R. D.","The structure of chloroxiphite, Pb3CuO2(OH)2Cl2","Mineralogical Magazine","1977","41","","357","361","10.1180/minmag.1977.041.319.07","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47","" "9009456","6.807","","15.459","","6.811","","90","","97.76","","90","","710.154","","","","","","","","","","","","Killala Bay, Ireland","4","P 1 21/m 1","-P 2yb","11","","","Killalaite","- Ca6.43 H3.14 O17.14 Si4 -","- Ca6.43 H3.14 O17.14 Si4 -","- Ca12.86 H6.28 O34.28 Si8 -","2","0.5","","Taylor, H. F. W.","The crystal structure of killalaite","Mineralogical Magazine","1977","41","","363","369","10.1180/minmag.1977.041.319.08","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47","" "9009457","15.566","","15.566","","8.69","","90","","90","","120","","1823.49","","","","","","","","","","","","Sierra Gorda, Chile","5","P -3","-P 3","147","","","Ferrinatrite","- Fe H6 Na3 O15 S3 -","- Fe H6 Na3 O15 S3 -","- Fe6 H36 Na18 O90 S18 -","6","1","","Scordari, F.","The crystal structure of ferrinatrite, Na3(H2O)3[Fe(SO4)3] and its relationship to Maus's salt, (H3O)2K2{K0.5(H2O)0.5}6[Fe3O(H2O)3(SO4)6](OH)2","Mineralogical Magazine","1977","41","","375","383","10.1180/minmag.1977.041.319.10","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47","" "9011794","17.53","","19.35","","11.25","","90","","95.92","","90","","3795.71","","","","","","","","","","","","","5","A 1 a 1","A -2ya","9","","","Mitridatite","- Ca2 Fe3 H6 O17 P3 -","- Ca2 Fe3 H6 O17 P3 -","- Ca24 Fe36 H72 O204 P36 -","12","3","","Moore, P. B.; Araki, T.","Mitridatite - a remarkable octahedral sheet structure Loclaity: White Elephant pegmatite, Custer, South Dakota, USA","Mineralogical Magazine","1977","41","","527","528","10.1180/minmag.1977.041.320.16","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""