# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-02-10T17:49:29+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 'Crystallography Reports') AND volume = 38 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 "9012618","5.007","","5.007","","9.642","","90","","90","","120","","209.34","","","","","","","","","","","","Synthetic","4","P -3 1 c","-P 3 2c","163","","","Colquiriite","- Al Ca F6 Li -","- Al Ca F6 Li -","- Al2 Ca2 F12 Li2 -","2","0.166667","","Bolotina, N. B.; Maksimov, B. A.; Simonov, V. I.; Derzhavin, S. I.; Uvarova, T. V.; Apollonov, V. V.","Atomic structure and spectral properties of LiCaAlF6:Cr3+ single crystals","Crystallography Reports","1993","38","","446","450","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012619","5.008","","5.008","","9.642","","90","","90","","120","","209.424","","","","","","","","","","","","Synthetic","4","P -3 1 c","-P 3 2c","163","","","Colquiriite","- Al Ca F6 Li -","- Al Ca F6 Li -","- Al2 Ca2 F12 Li2 -","2","0.166667","","Bolotina, N. B.; Maksimov, B. A.; Simonov, V. I.; Derzhavin, S. I.; Uvarova, T. V.; Apollonov, V. V.","Atomic structure and spectral properties of LiCaAlF6:Cr3+ single crystals Sample: LiCaAlF6:Cr3+","Crystallography Reports","1993","38","","446","450","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012620","10.035","","10.035","","7.499","","90","","90","","120","","653.986","","","","","","","","","","","","metamorphic rocks, Kombat region, Namibia","4","P 3","P 3","143","","","Jaffeite","- Ca6 H6 O13 Si2 -","- Ca6 H6 O13 Si2 -","- Ca12 H12 O26 Si4 -","2","0.666667","","Yamnova, N. A.; Sarp, K.; Egorov-Tismenko Y K; Pushcharovskii, D. Y.","Crystal structure of jaffeite","Crystallography Reports","1993","38","","464","467","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012621","11.503","","10.53","","12.58","","90","","90","","99.48","","1502.96","","","","","","","","","","","","volcanic ash deposit, near Belgrade, Yugoslavia","5","P 1 1 21/b","-P 2bc","14","","","Studenitsite","- B9 Ca2 H8 Na O20 -","- B9 Ca2 H8 Na O20 -","- B36 Ca8 H32 Na4 O80 -","4","1","","Yamnova, N. A.; Egorov-Tismenko Yu K; Pushcharovskii D Yu; Malinko, S. V.; Dorokhova, G. I.","Crystal structure of a new natural Na,Ca-hydroborate NaCa2[B9O14(OH)4]*2H2O","Crystallography Reports","1993","38","","749","752","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48",""