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

the size of the result array is 5

the size of the diff result array is 0

The total results from the merged set is 5

The total number of rows in result set is 5

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('06937.amc', '06938.amc', '10323.amc', '10324.amc', '11450.amc') order by fileno

	Geikielite
	Liferovich R P, Mitchell R H
	The Canadian Mineralogist 44 (2006) 1099-1107
	The pyrophanite-geikielite solid-solution series: crystal structures of the
	Mn1-xMgxTiO3 series (0 < x < 0.7)
	Sample: XMg = 0.6
	Locality: synthetic
	_database_code_amcsd 0006107
	5.0921 5.0921 14.0532 90 90 120 R-3
	atom x y z occ Biso
	Mn 0 0 .35827 .4 .46
	Mg 0 0 .35827 .6 .46
	Ti 0 0 .14632 .28
	O1 .31649 .02532 .24459 .66
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Geikielite
	Liferovich R P, Mitchell R H
	The Canadian Mineralogist 44 (2006) 1099-1107
	The pyrophanite-geikielite solid-solution series: crystal structures of the
	Mn1-xMgxTiO3 series (0 < x < 0.7)
	Sample: XMg = 1.0
	Locality: synthetic
	Note: No bond lengths could be reproduced with the reported dataset
	_database_code_amcsd 0006108
	5.0567 5.0567 13.9034 90 90 120 R-3
	atom x y z Biso
	Mg 0 0 .35986 .47
	Ti 0 0 .14590 .28
	O1 .31915 .02141 .24575 .71
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Geikielite
	Liferovich R P, Mitchell R H
	Physics and Chemistry of Minerals 32 (2005) 442-449
	Rhombohedral ilmenite group nickel titanates with Zn, Mg, and Mn:
	synthesis and crystal structures
	_database_code_amcsd 0008980
	5.0544 5.0544 13.8737 90 90 120 R-3
	atom x y z occ Biso
	NiA 0 0 .3555 1/3 .57
	ZnA 0 0 .3555 1/3 .57
	MgA 0 0 .3555 1/3 .57
	TiB 0 0 .1452 .36
	O1 .3188 .0197 .2442 .20
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Geikielite
	Liferovich R P, Mitchell R H
	Physics and Chemistry of Minerals 32 (2005) 442-449
	Rhombohedral ilmenite group nickel titanates with Zn, Mg, and Mn:
	synthesis and crystal structures
	_database_code_amcsd 0008981
	5.0418 5.0418 13.8494 90 90 120 R-3
	atom x y z occ Biso
	NiA 0 0 .3518 .5 .44
	MgA 0 0 .3518 .5 .44
	TiB 0 0 .1448 .26
	O1 .3183 .0192 .2460 .33
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Geikielite
	Wechsler B A, Von Dreele R B
	Acta Crystallographica B45 (1989) 542-549
	Structure refinements of Mg2TiO4, MgTiO3 and MgTi2O5 by time-of-flight neutron
	powder diffraction
	Locality: synthetic
	_database_code_amcsd 0009834
	5.05478 5.05478 13.8992 90 90 120 R-3
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Mg 0 0 .35570 .0050 .0050 .0055 .0025 0 0
	Ti 0 0 .14510 .0035 .0035 .0042 .0018 0 0
	O .31591 .02146 .24635 .0040 .0041 .0059 .0016 .0010 .0013
	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-9-170.crawl.commoncrawl.org'

Line 943: Update statistic set count=count + '5' where hostname='18-97-9-170.crawl.commoncrawl.org'