# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-14T12:36: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 'General Meeting of the International Mineralogical Association') AND volume = 18 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 "9014939","16.549","","10.053","","24.618","","90","","106.55","","90","","3925.95","","","","","","","","","","","","Rapid Creek, Yukon, Canada","8","C 1 c 1","C -2yc","9","","","Arrojadite-(KNa)","- Al Ca0.984 Fe10.54 K0.902 Mg2.46 Na4.858 O50 P12 -","- Al Ca0.984 Fe10.54 K0.902 Mg2.46 Na4.858 O50 P12 -","- Al4 Ca3.936 Fe42.16 K3.608 Mg9.84 Na19.432 O200 P48 -","4","1","","Steele, I. M.","Arrojadite: variations in space group and composition based on four new refinements Sample: red06ye","General Meeting of the International Mineralogical Association","2002","18","","MO2","117","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9015151","16.531","","10.004","","24.644","","90","","105.943","","90","","3918.77","","","","","","","","","","","","Palermo No. 1 mine, Groton, New Hampshire, USA","10","C 1 c 1","C -2yc","9","","","Arrojadite-(KNa)","- Al Ba0.06 Ca0.23 Fe11.69 K0.68 Mg1.85 Na4.459 O50 P12 Sr0.23 -","- Al Ba0.06 Ca0.23 Fe11.69 K0.68 Mg1.85 Na4.459 O50 P12 Sr0.23 -","- Al4 Ba0.24 Ca0.92 Fe46.76 K2.72 Mg7.4 Na17.836 O200 P48 Sr0.92 -","4","1","","Steele, I. M.","Arrojadite: variations in space group and composition based on four new refinements Sample: arropala","General Meeting of the International Mineralogical Association","2002","18","","MO2","117","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9015466","16.506","","10.036","","24.723","","90","","105.67","","90","","3943.25","","","","","","","","","","","","Nickel Plate mine, South Dakota, USA","9","C 1 2/c 1","-C 2yc","15","","","Fluorarrojadite-(KFe)","- Al Ca1.168 F2 Fe12.26 K0.908 Mg2.52 Na3.152 O48 P11.916 -","- Al Ca1.168 F2 Fe12.26 K0.908 Mg2.52 Na3.152 O48 P11.916 -","- Al4 Ca4.672 F8 Fe49.04 K3.632 Mg10.08 Na12.608 O192 P47.664 -","4","0.5","","Steele, I. M.","Arrojadite: variations in space group and composition based on four new refinements Sample: arronpc","General Meeting of the International Mineralogical Association","2002","18","","MO2","117","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19","" "9015722","16.459","","10.018","","24.597","","90","","105.78","","90","","3902.86","","","","","","","","","","","","Chandler Mills quarry, Newport, New Hampshire, USA","11","C 1 2/c 1","-C 2yc","15","","","Fluorarrojadite-(KFe)","- Al Ca0.84 F2 Fe10.52 K0.83 Mg3.48 Na3.106 O48 P11.74 Pb0.17 Sr0.16 -","- Al Ca0.84 F2 Fe10.52 K0.83 Mg3.48 Na3.106 O48 P11.74 Pb0.17 Sr0.16 -","- Al4 Ca3.36 F8 Fe42.08 K3.32 Mg13.92 Na12.424 O192 P46.96 Pb0.68 Sr0.64 -","4","0.5","","Steele, I. M.","Arrojadite: variations in space group and composition based on four new refinements Sample: arro135C","General Meeting of the International Mineralogical Association","2002","18","","MO2","117","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:53",""