# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-07T13:52:21+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 = 63 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 "1520786","9.254","","12.287","","3.004","","90","","90","","90","","341.567","","","","","","","","","","","","","5","P b a m","-P 2 2ab","55","","(Mg1.93 Fe0.967 Al0.093) O2 (B O3)","","- Al0.093 B Fe0.967 Mg1.93 O5 -","- Al0.093 B Fe0.967 Mg1.93 O5 -","- Al0.372 B4 Fe3.868 Mg7.72 O20 -","4","0.5","","Appel, P.W.U.; Brigatti, M.F.","Ludwigite from central Sweden: new data and crystal structure refinement","Mineralogical Magazine (1969-)","1999","63","","511","518","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "9009512","7.41","","7.41","","17.484","","90","","90","","120","","831.396","","","","","","","","","","","","","5","R -3 m :H","-R 3 2""","166","","","Dussertite","- As2 Ba Fe2.52 O14 Sb0.48 -","- As2 Ba Fe2.52 O14 Sb0.48 -","- As6 Ba3 Fe7.56 O42 Sb1.44 -","3","0.0833333","","Kolitsch, U.; Slade, P. G.; Tiekink, E. R. T.; Pring, A.","The structure of antimonian dussertite and the role of antimony in oxysalt minerals Locality: Clara mine, Black Forest, Germany","Mineralogical Magazine","1999","63","","17","26","10.1180/002646199548277","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009513","4.2023","","9.202","","16.6608","","90","","91.829","","90","","643.938","","","","","","","","","","","","Bounds Cliff, St Endellion, Cornwall","5","P 1 21/m 1","-P 2yb","11","","","Barstowite","- C H2 Cl6 O4 Pb4 -","- C H2 Cl6 O4 Pb4 -","- C2 H4 Cl12 O8 Pb8 -","2","0.5","","Steele, I. M.; Pluth, J. J.; Stanley, C. J.","Crystal structure of barstowite (3PbCl2PbCO3H2O)","Mineralogical Magazine","1999","63","","901","907","10.1180/minmag.1999.063.6.09","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9011805","12.16","","12.16","","7.56","","90","","90","","90","","1117.86","","","","","","","","","","","","McBride Province, Australia","7","I 4/m","-I 4","87","","","Silvialite","- C0.478 Al4.872 Ca2.452 Na1.548 O27.524 S0.522 Si7.128 -","- C0.478 Al4.872 Ca2.452 Na1.548 O27.524 S0.522 Si7.128 -","- C0.956 Al9.744 Ca4.904 Na3.096 O55.048 S1.044 Si14.256 -","2","0.125","","Teertstra, D. K.; Schindler, M.; Sherriff, B. L.; Hawthorne, F. C.","Silvialite, a new sulfate-dominant member of the scapolite group with an Al-Si composition near the I4/m-P42/n phase transition","Mineralogical Magazine","1999","63","","321","329","10.1180/002646199548547","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""