# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-30T00:37:12+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 'Zeitschrift fur Kristallographie') AND volume = 140 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 "9008240","10.362","","8.101","","6.647","","90","","92.63","","90","","557.378","","","","","","","","","","","","Andreasberg, Harz, Germany","4","P 1 21/n 1","-P 2yn","14","","","Samsonite","- Ag4 Mn S6 Sb2 -","- Ag4 Mn S6 Sb2 -","- Ag8 Mn2 S12 Sb4 -","2","0.5","","Edenharter, A.; Nowacki, W.","Verfeinerung der kristallstruktur von samsonit (SbS3)2Ag2Ag2Mn","Zeitschrift fur Kristallographie","1974","140","","87","99","","","","","","","","","","","","","","","","","","","","","","has coordinates","291455","2024-05-02","11:21:05","" "9008241","19.098","","23.89","","4.057","","90","","90","","90","","1851.01","","","","","","","","","","","","Cariboo gold mines, Wells, British Columbia, Canada","4","P b n m","-P 2c 2ab","62","","","Cosalite","- Bi4 Cu0.12 Pb4 S10 -","- Bi4 Cu0.12 Pb4 S10 -","- Bi16 Cu0.48 Pb16 S40 -","4","0.5","","Srikrishnan, T.; Nowacki, W.","A redetermination of the crystal structure of cosalite, Pb2Bi2S5","Zeitschrift fur Kristallographie","1974","140","","114","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","291455","2024-05-02","11:21:05","" "9011428","5.296","","5.296","","5.296","","90","","90","","90","","148.54","","","","","","","","","","","","Strathcona mine, Sudbury, Ontario","3","F -4 3 m","F -4 2 3","216","","","Isocubanite","- Cu0.333 Fe0.667 S -","- Cu0.333 Fe0.667 S -","- Cu1.332 Fe2.668 S4 -","4","0.0416667","","Szymanski, J. T.","The crystal structure of high-temperature CuFe2S3","Zeitschrift fur Kristallographie","1974","140","","240","248","","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:47",""