# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-07T07:02:37+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 'Mineralogy and Petrology') AND volume = 63 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 "6000448","5.543","","21.995","","6.079","","90","","92.04","","90","","740.67","","","","","","","","","","","","","5","P 1 21/m 1","","","","","","- Cd Cu4 H12 O18 S2 -","","","","","","Giester, G.; Rieck, B.; Brandstatter, F.","Niedermayrite, Cu4Cd(SO4)(2)(OH)(6 .)4H(2)O, a new mineral from the Lavrion mining district, Greece","Mineralogy and Petrology","1998","63","","19","34","10.1007/BF01162766","","","","","","","","","","","","","","","","","","","","","","176292","2020-10-21","18:00:00","" "9009847","12.278","","3.815","","6.899","","90","","111.14","","90","","301.406","","","","","","","","","","","","Schneeberg, Germany","6","C 1 2/m 1","-C 2y","12","","","Brendelite","- Bi Fe H O7 P Pb -","- Bi Fe H O7 P Pb -","- Bi2 Fe2 H2 O14 P2 Pb2 -","2","0.25","","Krause, W.; Bernhardt, H. J.; McCammon, C.; Effenberger, H.","Brendelite, (Bi,Pb)2Fe3+,2+O2(OH)(PO4), a new mineral from Schneeberg, Germany: description and crystal structure","Mineralogy and Petrology","1998","63","","263","277","10.1007/BF01164154","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48","" "9012399","5.543","","21.995","","6.079","","90","","92.04","","90","","740.672","","","","","","","","","","","","Lavrion mining district, Attica peninsula, Greece","5","P 1 21/m 1","-P 2yb","11","","","Niedermayrite","- Cd Cu4 H14 O18 S2 -","- Cd Cu4 H14 O18 S2 -","- Cd2 Cu8 H28 O36 S4 -","2","0.5","","Giester, G.; Rieck, B.; Brandstatter, F.","Niedermayrite, Cu4Cd(SO4)2(OH)6*4H2O, a new mineral from the Lavrion Mining District, Greece Locality: Lavrion mining district, Attica peninsula, Greece","Mineralogy and Petrology","1998","63","","19","34","10.1007/BF01162766","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48",""