The query is now

select distinct Amc_Table.fileno from Amc_Table LEFT JOIN Amc_Author ON Amc_Table.fileno=Amc_Author.fileno LEFT JOIN atomic_data ON Amc_Table.fileno = atomic_data.fileno WHERE ( Mineral LIKE 'Masutomilite%')

the size of the result array is 2

the size of the diff result array is 0

The total results from the merged set is 2

The total number of rows in result set is 2

The paginate value is 1

entering paginate loop

The total number to display on this page is 2 2 matching records for this search.

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('04449.amc', '18250.amc') order by fileno

	Masutomilite
	Brigatti M F, Mottana A, Malferrari D, Cibin G
	American Mineralogist 92 (2007) 1395-1400
	Crystal structure and chemical composition of Li-, Fe-, and Mn-rich micas
	Locality: Sawtooth Mountains, Boise county, Idaho, USA
	Sample: Boise
	_database_code_amcsd 0004418
	5.2984 9.1461 10.0966 90 100.818 90 C2
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	SiT1 .0745 .1699 .2275 .78 .011 .008 .011 .014 .001 .002 0
	AlT1 .0745 .1699 .2275 .22 .011 .008 .011 .014 .001 .002 0
	SiT11 .5852 .3328 .2273 .78 .011 .008 .011 .013 .001 .001 0
	AlT11 .5852 .3328 .2273 .22 .011 .008 .011 .013 .001 .001 0
	LiM1 0 .9921 .5 .51 .012 .012 .010 .014 0 .004 0
	FeM1 0 .9921 .5 .22 .012 .012 .010 .014 0 .004 0
	MnM1 0 .9921 .5 .26 .012 .012 .010 .014 0 .004 0
	MgM1 0 .9921 .5 .01 .012 .012 .010 .014 0 .004 0
	AlM2 0 .3231 .5 .91 .009 .008 .010 .008 0 .001 0
	LiM2 0 .3231 .5 .05 .009 .008 .010 .008 0 .001 0
	TiM2 0 .3231 .5 .02 .009 .008 .010 .008 0 .001 0
	MgM2 0 .3231 .5 .02 .009 .008 .010 .008 0 .001 0
	LiM3 .5 .1615 .5 .50 .013 .008 .015 .016 0 0 0
	FeM3 .5 .1615 .5 .24 .013 .008 .015 .016 0 0 0
	MnM3 .5 .1615 .5 .26 .013 .008 .015 .016 0 0 0
	KA 0 .5029 0 .92 .029 .026 .030 .030 0 .003 0
	NaA 0 .5029 0 .05 .029 .026 .030 .030 0 .003 0
	RbA 0 .5029 0 .02 .029 .026 .030 .030 0 .003 0
	O1 .0359 1.0025 .1718 .023 .027 .020 .020 -.002 .001 -.001
	O2 .3222 .2398 .1724 .021 .017 .027 .019 -.006 .005 -.001
	O22 .8149 .2616 .1594 .021 .019 .026 .017 .006 .003 .001
	O3 .1143 .1754 .3924 .012 .011 .013 .012 .002 .004 .001
	O33 .6641 .3272 .3921 .014 .010 .014 .018 .002 .001 0
	OH4 .1092 .4718 .3978 .06 .016 .015 .017 .015 -.002 .002 .003
	F4 .1092 .4718 .3978 .94 .016 .015 .017 .015 -.002 .002 .003
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Masutomilite
	Mizota T, Kato T, Harada K
	Mineralogical Journal 13 (1986) 13-21
	The crystal structure of masutomilite, Mn analogue of zinnwaldite
	Locality: Tanakamiyama, Ohtsu, Japan
	_database_code_amcsd 0014426
	5.262 9.102 10.094 90 100.83 90 C2
	atom x y z occ Biso B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	K 0 .5 0 .861 2.15 .018 .0072 .0054 0 .0018 0
	Na 0 .5 0 .072 2.15 .018 .0072 .0054 0 .0018 0
	Rb 0 .5 0 .067 2.15 .018 .0072 .0054 0 .0018 0
	LiM1 0 -.0081 .5 .635 1.09 .007 .004 .004 0 .002 0
	MnM1 0 -.0081 .5 .25 1.09 .007 .004 .004 0 .002 0
	FeM1 0 -.0081 .5 .05 1.09 .007 .004 .004 0 .002 0
	AlM2 0 .3190 .5 .98 .97 .005 .005 .002 0 .000 0
	FeM2 0 .3190 .5 .02 .97 .005 .005 .002 0 .000 0
	LiM3 .5 .1587 .5 .635 1.00 .009 .003 .003 0 .001 0
	MnM3 .5 .1587 .5 .25 1.00 .009 .003 .003 0 .001 0
	FeM3 .5 .1587 .5 .05 1.00 .009 .003 .003 0 .001 0
	SiT1 .0751 .166 .2282 .89 .54 .004 .002 .002 -.001 .002 .000
	AlT1 .0751 .166 .2282 .11 .54 .004 .002 .002 -.001 .002 .000
	SiT11 .5852 .3297 .2287 .78 .78 .003 .003 .002 -.002 .000 -.0001
	AlT11 .5852 .3297 .2287 .22 .78 .003 .003 .002 -.002 .000 -.0001
	O1 .0396 -.0034 .1727 1.38 .013 .004 .003 -.001 .001 .002
	O2 .3183 .2346 .1716 1.76 .004 .008 .006 -.003 .003 -.002
	O22 .8214 .2573 .1611 1.36 .018 .004 .002 .002 .003 -.001
	O3 .1148 .1699 .3919 1.16 .008 .005 .002 .000 .001 -.001
	O33 .6586 .3219 .3923 .63 .003 .002 .002 .002 .000 -.001
	F .1088 .4677 .3984 .73 .88 .007 .003 .003 -.001 .002 .000
	OH .1088 .4677 .3984 .27 .88 .007 .003 .003 -.001 .002 .000
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)

Download in: Amc Format Cif Format Diffraction data

Multiple datasets can be concatenated into a single downloadable file by selecting the datasets and then clicking

Multiple datasets can be downloaded as individual files inside a ZIP archive by selecting the datasets and then clicking

Line 935: Select count from statistic where hostname='18-97-14-81.crawl.commoncrawl.org'

Line 943: Update statistic set count=count + '2' where hostname='18-97-14-81.crawl.commoncrawl.org'