# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-17T09:39:08+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 = 54 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 "9017873","13.2197","","13.2197","","5.8591","","90","","90","","120","","886.757","","","","","","","","","","","","Yavapai County, Arizona, USA","14","P 63/m","-P 6c","176","","","Petersite-(Ce)","- Ca0.42 Ce0.18 Cu6 Dy0.01 Gd0.03 H12 La0.12 Nd0.09 O21 P2.85 Pr0.02 Si0.15 Sm0.01 Y0.16 -","- Ca0.42 Ce0.18 Cu6 Dy0.01 Gd0.03 H12 La0.12 Nd0.09 O21 P2.85 Pr0.02 Si0.15 Sm0.01 Y0.16 -","- Ca0.84 Ce0.36 Cu12 Dy0.02 Gd0.06 H24 La0.24 Nd0.18 O42 P5.7 Pr0.04 Si0.3 Sm0.02 Y0.32 -","2","0.166667","","Morrison, S. M.; Domanik, K. J.; Yang, H.; Downs, R. T.","Petersite-(Ce), Cu2+6Ce(PO4)3(OH)6*3H2O, a new mixite group mineral from Yavapai County, Arizona, USA","The Canadian Mineralogist","2016","54","","1505","1511","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""