# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-05-17T10:37:17+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 = 107 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 "9017744","6.3916","","6.4005","","12.3898","","100.884","","96.525","","100.492","","483.635","","","","","","","","","","","","","5","P -1","-P 1","2","","","Galgenbergite-(Ce)","- C4 H2 Ca1.089 Ce1.911 O13 -","- C8 H4 Ca2.178 Ce3.822 O26 -","- C8 H4 Ca2.178 Ce3.822 O26 -","","","","Walter, F.; Bojar, H. P.; Hollerer, C. E.; Mereiter, K.","The crystal structure of galgenbergite-(Ce), CaCe2(CO3)4H2O","Mineralogy and Petrology","2013","107","","189","199","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:19","" "9017745","6.0731","","11.0597","","5.5094","","102.883","","92.348","","92.597","","359.867","","","","","","","","","","","","Kapitalnaya mine, South Urals, Russia","4","P -1","-P 1","2","","","Kobyashevite","- Cu5 H14 O18 S2 -","- Cu5 H14 O18 S2 -","- Cu5 H14 O18 S2 -","","","","Pekov, I. V.; Zubkova, N. V.; Yapaskurt, V. O.; Belakovskiy, D. I.; Chukanov, N. V.; Kasatkin, A. V.; Kuznetsov, A. M.; Pushcharovsky, D. Y.","Kobyashevite, Cu5(SO4)2(OH)6*4H2O, a new devilline-group mineral from the Vishnevye Mountains, South Urals, Russia","Mineralogy and Petrology","2013","107","","201","210","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:19",""