# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-26T17:06:28+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') AND volume = 57 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 "9009480","8.683","","9.253","","8.272","","90","","90","","90","","664.604","","","","","","","","","","","","","4","P n a m","-P 2c 2n","62","","","","- B K O8 Si3 -","- B K O8 Si3 -","- B4 K4 O32 Si12 -","4","0.5","","Kimata, M.","Crystal structure of KBSi3O8 isostructural with danburite","Mineralogical Magazine","1993","57","","157","164","10.1180/minmag.1993.057.386.15","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:08","" "9009481","8.318","","8.318","","15.264","","90","","90","","120","","914.612","","","","","","","","","","","","","6","P -3 c 1","-P 3 2""c","165","","","Asbecasite","- As6 Be2 Ca3 O20 Si2 Ti -","- As6 Be2 Ca3 O20 Si2 Ti -","- As12 Be4 Ca6 O40 Si4 Ti2 -","2","0.166667","","Sacerdoti, M.; Parodi, G. C.; Mottana, A.; Maras, A.; Ventura, G. D.","Asbecasite: crystal structure refinement and crystal chemistry","Mineralogical Magazine","1993","57","","315","322","10.1180/minmag.1993.057.387.14","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009482","10.865","","4.006","","7.233","","90","","117.24","","90","","279.903","","","","","","","","","","","","","4","C 1 2/m 1","-C 2y","12","","","Paralaurionite","- Cl H O Pb -","- Cl H O Pb -","- Cl4 H4 O4 Pb4 -","4","0.5","","Merlino, S.; Pasero, M.; Perchialli, N.","Crystal structure of paralaurionite and its OD relationships with laurionite","Mineralogical Magazine","1993","57","","323","328","10.1180/minmag.1993.057.387.15","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009483","6.928","","10.445","","13.501","","90","","90","","90","","976.972","","","","","","","","","","","","","6","C m c e","-C 2ac 2","64","","","Eosphorite","- Al Fe0.2 H4 Mn0.8 O7 P -","- Al Fe0.2 H4 Mn0.8 O7 P -","- Al8 Fe1.6 H32 Mn6.4 O56 P8 -","8","0.5","","Hoyos, M. A.; Calderon, T.; Vergara, I.; Garcia-Sole J","New structural and spectroscopic data for eosphorite Locality: Taquaral, Brazil","Mineralogical Magazine","1993","57","","329","336","10.1180/minmag.1993.057.387.16","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009484","9.962","","18.283","","5.372","","90","","104.87","","90","","945.663","","","","","","","","","","","","West Ongul, East Antarctica","10","C 1 2/m 1","-C 2y","12","","","Hastingsite","- Al2.4 Ca1.992 Cl0.9 Fe3.771 H1.1 K0.685 Mg1.229 Na0.255 O23.1 Si5.6 -","- Al2.4 Ca1.992 Cl0.9 Fe3.771 H1.1 K0.685 Mg1.229 Na0.255 O23.1 Si5.6 -","- Al4.8 Ca3.984 Cl1.8 Fe7.542 H2.2 K1.37 Mg2.458 Na0.51 O46.2 Si11.2 -","2","0.25","","Makino, K.; Tomita, K.; Suwa, K.","Effect of chlorine on the crystal structure of a chlorine-rich hastingsite","Mineralogical Magazine","1993","57","","677","685","10.1180/minmag.1993.057.389.12","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:26","" "9009485","6.855","","13.147","","11.479","","90","","98.97","","90","","1021.87","","","","","","","","","","","","Langban, Sweden","9","I 1 2/a 1","-I 2ya","15","","","Caryinite","- As2.892 Ca1.91 Mg0.56 Mn1.77 Na1.376 O12 P0.09 Pb0.384 V0.018 -","- As2.892 Ca1.91 Mg0.56 Mn1.77 Na1.376 O12 P0.09 Pb0.384 V0.018 -","- As11.568 Ca7.64 Mg2.24 Mn7.08 Na5.504 O48 P0.36 Pb1.536 V0.072 -","4","0.5","","Ercit, T. S.","Caryinite revisited","Mineralogical Magazine","1993","57","","721","727","10.1180/minmag.1993.057.389.16","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""