# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-07-03T17:20:35+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 = 40 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
"9009832","11.203","","11.203","","4.977","","90","","90","","120","","540.962","","","","","","","","","","","","Tingelstadtjern serpentine-magnesium deposit, Modum, Norway","5","P 3 1 m","P 3 -2","157","","","Holtedahlite","- C0.24 H6.76 Mg12 O29.76 P5.76 -","- C0.24 H6.76 Mg12 O29.76 P5.76 -","- C0.24 H6.76 Mg12 O29.76 P5.76 -","1","0.166667","","Romming, C.; Raade, G.","The crystal structure of natural and synthetic holtedahlite","Mineralogy and Petrology","1989","40","","91","100","10.1007/BF01164319","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:48",""
"9009833","11.186","","11.186","","4.977","","90","","90","","120","","539.322","","","","","","","","","","","","Synthetic","4","P 3 1 m","P 3 -2","157","","","Holtedahlite","- H7 Mg12 O30 P6 -","- H7 Mg12 O30 P6 -","- H7 Mg12 O30 P6 -","1","0.166667","","Romming, C.; Raade, G.","The crystal structure of natural and synthetic holtedahlite","Mineralogy and Petrology","1989","40","","91","100","10.1007/BF01164319","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:48",""
"9009834","10.854","","14.053","","7.086","","90","","90","","90","","1080.84","","","","","","","","","","","","Mine de L'Etoile, Katanga, Zaire","4","P b c a","-P 2ac 2ab","61","","","Cornetite","- Cu3 H3 O7 P -","- Cu3 H3 O7 P -","- Cu24 H24 O56 P8 -","8","1","","Eby, R. K.; Hawthorne, F. C.","Cornetite: modulated densely-packed Cu2+ oxysalt","Mineralogy and Petrology","1989","40","","127","136","10.1007/BF01164323","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:48",""
"9012395","12.632","","12.632","","12.632","","90","","90","","90","","2015.66","","","","","","","","","","","","Aldan, USSR","4","I a -3 d","-I 4bd 2c 3","230","","","Yafsoanite","- Ca3 O12 Te2 Zn3 -","- Ca3 O12 Te2 Zn3 -","- Ca24 O96 Te16 Zn24 -","8","0.0833333","","Jarosch, D.; Zemann, J.","Yafsoanite: a garnet type calcium-tellurium(VI)-zinc oxide","Mineralogy and Petrology","1989","40","","111","116","10.1007/BF01164321","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47",""