# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-22T02:23:23+01: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 'Geokhimiya') AND volume = 10 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 "9014854","7.738","","7.738","","5.045","","90","","90","","90","","302.078","","","","","","","","","","","","Capo di Bove, Italy","7","P -4 21 m","P -4 2ab","113","","","Akermanite","- Al0.66 Ca1.96 Fe0.12 Mg0.24 Na0.04 O7 Si1.3 -","- Al0.66 Ca1.96 Fe0.12 Mg0.24 Na0.04 O7 Si1.3 -","- Al1.32 Ca3.92 Fe0.24 Mg0.48 Na0.08 O14 Si2.6 -","2","0.25","","Mokeeva, V.; Makarov, E.","Isomorph in melilites: refining of crystal structure of akermanite and intermediate melilite","Geokhimiya","1979","10","","1541","1544","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9015368","7.76","","7.76","","5.029","","90","","90","","90","","302.834","","","","","","","","","","","","Capo di Bove, Italy","7","P -4 21 m","P -4 2ab","113","","","Akermanite","- Al0.41 Ca1.5 Fe0.16 Mg0.39 Na0.5 O7 Si2 -","- Al0.41 Ca1.5 Fe0.16 Mg0.39 Na0.5 O7 Si2 -","- Al0.82 Ca3 Fe0.32 Mg0.78 Na O14 Si4 -","2","0.25","","Mokeeva, V.; Makarov, E.","Isomorph in melilites: refining of crystal structure of akermanite and intermediate melilite","Geokhimiya","1979","10","","1541","1544","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""