# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T16:42:45+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 'Doklady Chemistry') AND volume = 391 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 "9012753","18.846","","7.242","","12.65","","90","","111.84","","90","","1602.59","","","","","","","","","","","","Khibiny alkaline massif, Kola Peninsula, Russia","8","C 1 m 1","C -2y","8","","","Canasite","- Ca4.6 F2.75 H2.05 K3 Mn0.4 Na3 O32.25 Si12 -","- Ca4.6 F2.75 H3.25 K3 Mn0.4 Na3 O32.25 Si12 -","- Ca9.2 F5.5 H6.5 K6 Mn0.8 Na6 O64.5 Si24 -","2","0.5","","Rastsvetaeva, R. K.; Rozenberg, K. A.; Khomyakov, A. P.; Rozhdestvenskaya, I. V.","Crystal structure of F-canasite","Doklady Chemistry","2003","391","","177","180","10.1023/A:1024738629041","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:55:07",""