# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-28T06:36:25+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 'Zeitschrift für Kristallographie - Crystalline Materials') AND volume = 223 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 "8103062","13.5385","0.0008","7.1338","0.0004","10.6689","0.0006","90","","113.231","0.004","90","","946.87","0.1","298","","298","","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- Ca2 F Na O4 Si -","- Ca2 F Na O4 Si -","- Ca16 F8 Na8 O32 Si8 -","8","2","","Krüger, Hannes; Kahlenberg, Volker","Ca2NaSiO4F: a new monoclinic polymorph","Zeitschrift für Kristallographie - Crystalline Materials","2008","223","6","382","388","10.1524/zkri.2008.0038","","","0.71073","MoKα","","0.0354","0.0299","","","0.032","0.0327","","","","2.06","2.06","1.98","","","","has coordinates","176432","2020-10-21","18:00:00","" "8103063","5.3388","0.0004","7.1542","0.0007","12.4116","0.0011","90","","90","","90","","474.06","0.07","298","","298","","","","","","","","","5","P n m a","-P 2ac 2n","62","","","","- Ca2 F Na O4 Si -","- Ca2 F Na O4 Si -","- Ca8 F4 Na4 O16 Si4 -","4","0.5","","Krüger, Hannes; Kahlenberg, Volker","Ca2NaSiO4F: a new monoclinic polymorph","Zeitschrift für Kristallographie - Crystalline Materials","2008","223","6","382","388","10.1524/zkri.2008.0038","","","0.71073","MoKα","","0.0282","0.0251","","","0.032","0.0329","","","","2.51","2.51","2.47","","","","has coordinates","176432","2020-10-21","18:00:00",""