# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T12:44:13+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 'Minerals') AND volume = 8 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
"1550511","14.0951","0.0009","5.8123","0.0004","10.0848","0.0007","90","","90","","90","","826.2","0.1","","","","","","","","","","","","9","P n m a","-P 2ac 2n","62","ZrAl2Ti4O11","","carmeltazite","- Al1.89 Ca0.05 Hf0.01 O11 Sc0.06 Si0.13 Ti3.6 Y0.02 Zr1.04 -","- Al1.95 Mg0.22 O11 Si0.13 Ti3.75 Zr0.85 -","- Al7.8 Mg0.88 O44 Si0.52 Ti15 Zr3.4 -","4","0.5","","Griffin, W.L.; Gain, S.E.M.; Bindi, L.; Toledo, V.; Camara, F.; Saunders, M.; O'Reilly, S.Y.","Carmeltazite, ZrAl2Ti4O12, a new mineral trapped in corundum from volcanic rocks of Mt Carmel, Northern Israel","Minerals","2018","8","","601","611","","","","","","","","","","","","","","","","","","","","","","has coordinates","213251","2020-10-21","18:00:00",""
"9017762","9.49","","9.49","","6.4777","","90","","90","","120","","505.224","","","","","","","","","","","","Szklary pegmatite, Lower Silesia, Poland","9","P 63/m","-P 6c","176","","","Parafiniukite","- Ca2.33 Cl0.48 F0.11 H0.41 Mg0.03 Mn2.63 Na0.01 O12.41 P3 -","- Ca2.33 Cl0.48 F0.11 H0.41 Mg0.03 Mn2.63 Na0.01 O12.41 P3 -","- Ca4.66 Cl0.96 F0.22 H0.82 Mg0.06 Mn5.26 Na0.02 O24.82 P6 -","2","0.166667","","Pieczka, A.; Biagioni, C.; Golebiowska, B.; Jelen, P.; Pasero, M.; Sitarz, M.","Parafiniukite, Ca2Mn3(PO4)3Cl, a new member of the apatite supergroup from the Szklary pegmatite, Lower Silesia, Poland: description and crystal structure","Minerals","2018","8","","","485","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017763","22.052","","17.118","","19.354","","90","","90.474","","90","","7305.62","","","","","","","","","","","","Jachymov District, Bohemia, Czech Republic","6","P 1 c 1","P -2yc","7","","","Paddlewheelite","- C24 Ca10 Cu4 Mg2 O154.25 U8 -","- C48 Ca20 Cu8 Mg4 O308.5 U16 -","- C48 Ca20 Cu8 Mg4 O308.5 U16 -","","","","Olds, T. A.; Plasil, J.; Kampf, A. R.; Dal Bo, F.; Burns, P. C.","Paddlewheelite, a new uranyl carbonate from the Jachymov District, Bohemia, Czech Republic","Minerals","2018","8","","","511","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:21",""