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

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 ('01986.amc') order by fileno

	Bamfordite
	Birch W D, Pring A, McBriar E M, Gatehouse B M, McCammon C A
	American Mineralogist 83 (1998) 172-177
	Bamfordite, a new hydrated iron molybdenum oxyhydroxide from Queensland,
	Australia: Description and crystal chemistry
	_database_code_amcsd 0001962
	5.878 7.536 9.436 71.66 83.43 72.85 P-1
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Mo1 .2370 .4809 .26057 .0060 .0057 .0056 -.0021 .0005 -.0003
	Mo2 .0943 .2340 .05694 .0091 .0058 .0068 -.0031 .0004 -.0002
	Fe1 -.0817 .8948 .4069 .0095 .0091 .0099 -.0027 .0011 -.0014
	O1 -.216 .1160 .5005 .006 .008 .013 -.001 -.002 -.004
	O2 -.401 .925 .3281 .014 .028 .010 -.009 -.002 -.003
	O3 .081 .6791 .3278 .022 .007 .016 -.003 .002 -.006
	O4 .530 .4586 .2840 .008 .013 .027 -.005 -.001 -.004
	O5 .170 .2863 .4072 .020 .010 .011 -.007 .006 .002
	O6 .338 .2860 .1252 .012 .009 .009 -.001 .000 -.002
	O7 .076 .4876 -.1364 .008 .007 .007 -.002 .002 .002
	O8 -.234 .3275 -.0392 .017 .011 .016 -.004 -.002 -.001
	O9 -.017 .091 .2212 .011 .017 .011 -.004 .001 -.002
	O10 .244 .081 -.0363 .017 .015 .014 -.001 .003 -.009
	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.159'

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