# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-06T20:21:47+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 = 24 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 "9004185","14.357","","14.357","","5.908","","90","","90","","90","","1217.78","","","","","","","","","","","","","6","I 41/a :2","-I 4ad","88","","","Mannardite","- Ba0.517 Cr0.508 H2 O8.483 Ti2.984 V0.508 -","- Ba0.517 Cr0.508 H0.966 O8.483 Ti2.984 V0.508 -","- Ba4.136 Cr4.064 H7.728 O67.864 Ti23.872 V4.064 -","8","0.5","","Szymanski, J. T.","The crystal structure of mannardite, a new hydrated cryptomelane-group (hollandite) mineral with a doubled short axis","The Canadian Mineralogist","1986","24","","67","78","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:09","" "9004186","28.44","","3.9","","17.55","","90","","106","","90","","1871.17","","","","","","","","","","","","","5","P 1 21/m 1","-P 2yb","11","","","Paderaite","- Ag Bi12 Cu5.9 Pb S22 -","- Ag Bi12 Cu5.9 Pb S22 -","- Ag2 Bi24 Cu11.8 Pb2 S44 -","2","0.5","","Mumme, W. G.","The crystal structure of paderaite, a mineral of the cuprobismutite series.","The Canadian Mineralogist","1986","24","","513","521","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004187","12.776","","12.488","","11.035","","90","","97.2","","90","","1746.71","","","","","","","","","","","","","9","P 1 21/n 1","-P 2yn","14","","","Bobfergusonite","- Al1.38 Ca0.19 Fe0.84 Mg0.09 Mn4.28 Na2 O24 P6 Zn0.05 -","- Al1.38 Ca0.19 Fe0.84 Mg0.09 Mn4.28 Na2 O24 P6 Zn0.05 -","- Al5.52 Ca0.76 Fe3.36 Mg0.36 Mn17.12 Na8 O96 P24 Zn0.2 -","4","1","","Ercit, T. S.; Hawthorne, F. C.; Cerny, P.","The crystal structure of bobfergusonite.","The Canadian Mineralogist","1986","24","","605","614","","","","","","","","","","","","","","","","","","","","","","has coordinates","294031","2024-08-07","17:26:33","" "9004188","5.329","","9.246","","14.442","","90","","97.1","","90","","706.129","","","","","","","","","","","","","7","C -1","-P 1 (1/2*x+1/2*y,1/2*x-1/2*y,-z)","2","","","Chlorite","- Al1.2 Cr0.7 Fe0.1 H7.9 Mg5 O18 Si3 -","- Al1.2 Cr0.7 Fe0.1 H7.9 Mg5 O18 Si3 -","- Al2.4 Cr1.4 Fe0.2 H15.8 Mg10 O36 Si6 -","2","","","Bailey, S. W.","Re-evaluation of ordering and local charge-balance in Ia chlorite","The Canadian Mineralogist","1986","24","","649","654","","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:20","" "9004189","9.089","","12.244","","8.926","","90","","90","","90","","993.336","","","","","","","","","","","","","6","P b c a","-P 2ac 2ab","61","","","Moydite-(Y)","- C H4 B O7 Sm0.1 Y0.9 -","- C H4 B O7 Sm0.1 Y0.9 -","- C8 H32 B8 O56 Sm0.8 Y7.2 -","8","1","","Grice, J. D.; Ercit, T. S.","The crystal structure of moydite","The Canadian Mineralogist","1986","24","","675","678","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:36",""