# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-06T20:27:26+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 'The Canadian Mineralogist') AND volume = 26 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 "9004194","17.093","","4.877","","5.558","","90","","90.85","","90","","463.278","","","","","","","","","","","","","3","C 1 2/c 1","-C 2yc","15","","","Foordite","- Nb2 O6 Sn -","- Nb2 O6 Sn -","- Nb8 O24 Sn4 -","4","0.5","","Ercit, T. S.; Cerny, P.","The crystal structure of foordite","The Canadian Mineralogist","1988","26","","899","903","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004195","7.315","","7.315","","17.0355","","90","","90","","120","","789.431","","","","","","","","","","","","","6","R -3 m :H","-R 3 2""","166","","","Beudantite","- Al0.459 As1.07 Fe2.541 O14 Pb1.002 S0.93 -","- Al0.459 As1.07 Fe2.541 O14 Pb1.002 S0.93 -","- Al1.377 As3.21 Fe7.623 O42 Pb3.006 S2.79 -","3","0.0833333","","Szymanski, J. T.","The crystal structure of beudantite, Pb(Fe,Al)3((As,S)O4)2(OH)6","The Canadian Mineralogist","1988","26","","923","932","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41",""