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

the size of the result array is 1

the size of the diff result array is 0

The total results from the merged set is 1

The total number of rows in result set is 1

The paginate value is 1

entering paginate loop

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

the file_query is

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

	Oxykinoshitalite
	Kogarko L N, Uvarova Y A, Sokolova E, Hawthorne F C, Ottolini L, Grice J D
	The Canadian Mineralogist 43 (2005) 1501-1510
	Oxykinoshitalite, a new species of mica from Fernando-do-Noronha island, Brazil:
	Occurrence and crystal structure
	Locality: Fernando-do-Noronha island, Brazil
	_database_code_amcsd 0006061
	5.3516 9.2817 10.0475 90 100.337 90 C2/m
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	BaI 0 0 0 .47 .0229 .0197 .0205 .0285 0 .0046 0
	KI 0 0 0 .42 .0229 .0197 .0205 .0285 0 .0046 0
	NaI 0 0 0 .06 .0229 .0197 .0205 .0285 0 .0046 0
	CaI 0 0 0 .01 .0229 .0197 .0205 .0285 0 .0046 0
	MgM1 0 .5 .5 .52 .0102 .0082 .0065 .0167 0 .0043 0
	Fe2+M1 0 .5 .5 .13 .0102 .0082 .0065 .0167 0 .0043 0
	Fe3+M1 0 .5 .5 .27 .0102 .0082 .0065 .0167 0 .0043 0
	Ti4+M1 0 .5 .5 .08 .0102 .0082 .0065 .0167 0 .0043 0
	MgM2 0 .15509 .5 .42 .0127 .0067 .0175 .0139 0 .0014 0
	Ti4+M2 0 .15509 .5 .335 .0127 .0067 .0175 .0139 0 .0014 0
	Fe3+M2 0 .15509 .5 .165 .0127 .0067 .0175 .0139 0 .0014 0
	Fe2+M2 0 .15509 .5 .075 .0127 .0067 .0175 .0139 0 .0014 0
	MnM2 0 .15509 .5 .005 .0127 .0067 .0175 .0139 0 .0014 0
	SiT .5736 .16750 .22032 .578 .0111 .0083 .0106 .0145 -.0005 .0024 .0001
	AlT .5736 .16750 .22032 .39 .0111 .0083 .0106 .0145 -.0005 .0024 .0001
	O1 .8179 .2354 .1586 .0227 .0192 .0287 .0210 -.0075 .0060 -.0030
	O2 .6314 .1709 .3903 .0135 .0120 .0107 .0180 -.0007 .0031 .0007
	O3 .5223 0 .1603 .0202 .029 .0163 .013 0 -.0012 0
	O4 .1257 0 .3964 .72 .0160 .0093 .023 .016 0 .0031 0
	OH4 .1257 0 .3964 .155 .0160 .0093 .023 .016 0 .0031 0
	F4 .1257 0 .3964 .125 .0160 .0093 .023 .016 0 .0031 0
	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='216.73.216.214'

Line 943: Update statistic set count=count + '1' where hostname='216.73.216.214'