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 'Stottite%')

the size of the result array is 4

the size of the diff result array is 0

The total results from the merged set is 4

The total number of rows in result set is 4

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('01213.amc', '10683.amc', '18602.amc', '18603.amc') order by fileno

	Stottite
	Ross C R, Bernstein L R, Waychunas G A
	American Mineralogist 73 (1988) 657-661
	Crystal-structure refinement of stottite, FeGe(OH)6
	_database_code_amcsd 0001167
	7.594 7.594 7.488 90 90 90 *P4_2/n
	.25 .25 .25
	atom x y z B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	Fe 0 0 0 .0029 .0019 .0038 .0003 .0001 .0002
	Ge .5 0 0 .0017 .0022 .0036 .0000 -.0001 .0000
	OH1 .267 .443 .583 .0050 .0064 .0049 .0006 .0003 -.0013
	OH2 .573 .268 .565 .0049 .0033 .0051 -.0006 -.0012 -.0001
	OH3 .437 .421 .267 .0043 .0063 .0053 -.0012 -.0007 .0000
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Stottite
	Strunz V H, Giglio M
	Acta Crystallographica 14 (1961) 205-208
	Die Kristallstruktur von Stottit: FeGe(OH)6
	Locality: Ongopolo mine, Namibia, Africa
	_database_code_amcsd 0020264
	7.55 7.55 7.47 90 90 90 *P4_2/n
	.25 .25 .25
	atom x y z Biso
	Ge .5 .5 .5 .43
	Fe 0 0 0 .43
	OH1 .26 .53 .595 .43
	OH2 .54 .26 .595 .43
	OH3 .42 .42 .27 .43
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Stottite
	Kleppe A K, Welch M D, Crichton W A, Jephcoat A P
	Mineralogical Magazine 76 (2012) 949-962
	Phase transitions in hydroxide perovskites: a Raman spectroscopic study
	of stottite, FeGe(OH)6, to 21 GPa
	Locality: Tsumeb mine, Nambia
	_database_code_amcsd 0019858
	7.5520 7.5520 7.4694 90 90 90 *P4_2/n
	.25 .25 .25
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Ge .5 0 .5 .0067 .0065 .0069 .0068 .0000 -.0001 -.0001
	Fe .5 0 0 .0078 .0078 .0074 .0081 .0001 -.0001 .0002
	OH1 .2670 .0552 .5825 .0121 .008 .013 .015 .001 -.001 .001
	OH2 .5708 .2317 .5638 .0119 .012 .008 .015 .000 -.002 -.002
	OH3 .5637 -.0763 .7329 .0102 .012 .011 .008 .001 -.000 -.001
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Stottite
	Kleppe A K, Welch M D, Crichton W A, Jephcoat A P
	Mineralogical Magazine 76 (2012) 949-962
	Phase transitions in hydroxide perovskites: a Raman spectroscopic study
	of stottite, FeGe(OH)6, to 21 GPa
	Note: this is the preferred structure
	Locality: Tsumeb mine, Nambia
	_database_code_amcsd 0019859
	7.5509 7.4695 7.5531 90 90.005 90 P2/n
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Ge1 0 .5 0 .0068 .0064 .0070 .0069 .0002 .0002 .0002
	Ge2 .5 0 0 .0066 .0065 .0068 .0064 -.0001 .0004 .0002
	Fe1 0 0 0 .0078 .0076 .0079 .0080 .0000 .0001 -.0003
	Fe2 .5 .5 0 .0078 .0075 .0077 .0081 .0002 .0000 .0003
	OH1 .2675 .5826 .5548 .0122 .009 .014 .014 -.001 .001 .001
	OH2 .5553 .0826 .2330 .0126 .014 .014 .009 -.002 -.001 .001
	OH3 -.4290 .5639 .7316 .0120 .012 .015 .009 -.002 .000 -.002
	OH4 -.2689 .0640 .9290 .0120 .009 .014 .013 -.003 .000 .002
	OH5 -.5639 .2672 .5762 .0100 .0121 .007 .011 .000 .000 .001
	OH6 .5765 .7672 .0634 .0100 .008 .012 .008 .001 .001 .011
	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 + '4' where hostname='18-97-14-81.crawl.commoncrawl.org'