# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T12:01:00+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 'Neues Jahrbuch fur Mineralogie, Abhandlungen') AND volume = 197 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
"9017784","5.6062","","6.1294","","23.834","","90","","95.29","","90","","815.511","","","","","","","","","","","","Casualidad mine, Banos de Alhamilla, Almeria, Spain","6","P 1 21/c 1","-P 2ybc","14","","","Fehrite","- Cu4 H18 Mg0.672 O20 S2 Zn0.328 -","- Cu4 H18 Mg0.672 O20 S2 Zn0.328 -","- Cu8 H36 Mg1.344 O40 S4 Zn0.656 -","2","0.5","","Schluter, J.; Malcherek, T.; Mihailova, B.; Rewitzer, C.; Hochleitner, R.; Muller, D.; Gunther, A.","Fehrite, MgCu4(SO4)2(OH)6*6H2O, the magnesium analogue of ktenasite from the Casualidad mine near Banos de Alhamilla, Almeria, Spain","Neues Jahrbuch fur Mineralogie, Abhandlungen","2021","197","","1","10","","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:12",""