# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-14T14:16:43+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 = 188 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 "9015055","16.4529","","5.6432","","10.3631","","90","","90","","90","","962.183","","","","","","","","","","","","Synthetic","5","P n m a","-P 2ac 2n","62","","","","- Al3 H O13 Pb2 Si3 -","- Al3 H O13 Pb2 Si3 -","- Al12 H4 O52 Pb8 Si12 -","4","0.5","","Dorsam, G.; Liebscher, A.; Wunder, B.; Franz, G.; Gottschalk, M.","Synthesis of Pb-zoisite and Pb-lawsonite","Neues Jahrbuch fur Mineralogie, Abhandlungen","2011","188","","99","110","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48","" "9015213","5.85","","9.03","","13.31","","90","","90","","90","","703.107","","","","","","","","","","","","Synthetic","5","P b n m","-P 2c 2ab","62","","","","- Al2 H4 O10 Pb Si2 -","- Al2 H4 O10 Pb Si2 -","- Al8 H16 O40 Pb4 Si8 -","4","0.5","","Dorsam, G.; Liebscher, A.; Wunder, B.; Franz, G.; Gottschalk, M.","Synthesis of Pb-zoisite and Pb-lawsonite","Neues Jahrbuch fur Mineralogie, Abhandlungen","2011","188","","99","110","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:51","" "9016543","9.4437","","9.4437","","6.8169","","90","","90","","120","","526.504","","","","","","","","","","","","Lagmannsvik, Hamaroy, Nordland, Norway","15","P 63/m","-P 6c","176","","","Fluorbritholite-(Y)","- Ca1.52 Ce0.35 Dy0.15 Er0.15 F Gd0.12 La0.06 Mn0.03 Nd0.33 O12 Pr0.06 Si3 Sm0.12 Y1.96 Yb0.18 -","- Ca1.52 Ce0.35 Dy0.15 Er0.15 F Gd0.12 La0.06 Mn0.03 Nd0.33 O12 Pr0.06 Si3 Sm0.12 Y1.96 Yb0.18 -","- Ca3.04 Ce0.7 Dy0.3 Er0.3 F2 Gd0.24 La0.12 Mn0.06 Nd0.66 O24 Pr0.12 Si6 Sm0.24 Y3.92 Yb0.36 -","2","0.166667","","Pekov, I. V.; Zubkova, N. V.; Chukanov, N. V.; Husdal, T. A.; Zadov, A. E.; Pushcharovsky, D. Y.","Fluorbritholite-(Y), (Y,Ca,Ln)5[(Si,P)O4]3F, a new mineral of the britholite group","Neues Jahrbuch fur Mineralogie, Abhandlungen","2011","188","","191","197","","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:11","" "9016606","7.328","","9.123","","5.769","","90","","90","","90","","385.677","","","","","","","","","","","","Tsumeb, Namibia","6","P 21 21 21","P 2ac 2ab","19","","","Hermannroseite","- As0.5 Ca Cu H O5 P0.5 -","- As0.5 Ca Cu H O5 P0.5 -","- As2 Ca4 Cu4 H4 O20 P2 -","4","1","","Schluter, J.; Pohl, D.; Gebhard, G.","The new mineral hermannroseite, CaCu(PO4,AsO4)(OH), the phosphate analogue of conichalcite, from Tsumeb, Namibia","Neues Jahrbuch fur Mineralogie, Abhandlungen","2011","188","","135","140","10.1127/0077-7757/2011/0186","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:52",""