# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-21T19:10:23+01: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 = 100 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 "9014333","7.0059","","7.0059","","16.3431","","90","","90","","120","","694.693","","","","","","","","","","","","Wheal Remfry, Cornwall, United Kingdom","8","R -3 m :H","-R 3 2""","166","","","Waylandite","- Al3 Bi0.49 Ca0.23 H6 O14 P1.8 Si0.2 Sr0.28 -","- Al3 Bi0.49 Ca0.23 H6 O14 P1.8 Si0.2 Sr0.28 -","- Al9 Bi1.47 Ca0.69 H18 O42 P5.4 Si0.6 Sr0.84 -","3","0.0833333","","Mills, S. J.; Kampf, A. R.; Raudsepp, M.; Birch, W. D.","The crystal structure of waylandite from Wheal Remfry, Cornwall, United Kingdom","Mineralogy and Petrology","2010","100","","249","253","10.1007/s00710-010-0133-7","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:17","" "9015672","5.7797","","11.567","","6.3344","","90","","113.36","","90","","388.767","","","","","","","","","","","","Su Senargiu, near Sarroch, Sardegna, Italy","3","P 1 21/m 1","-P 2yb","11","","","Sardignaite","- Bi Mo2 O10 -","- Bi Mo2 O10 -","- Bi2 Mo4 O20 -","2","0.5","","Orlandi, P.; Pasero, M.; Bigi, S.","Sardignaite, a new mineral, the second known bismuth molybdate: description and crystal structure","Mineralogy and Petrology","2010","100","","17","22","10.1007/s00710-010-0111-0","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""