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

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

	Qusongite
	Fang Q, Bai W, Yang J, Xu X, Li G, Shi N, Xiong M, Rong H
	American Mineralogist 94 (2009) 387-290
	Qusong (WC): A new mineral
	Locality: Luobusa ophiolite, Qusong County, Tibet, China
	_database_code_amcsd 0004855
	2.902 2.902 2.831 90 90 120 P-6m2
	atom x y z
	W 0 0 0
	C 2/3 1/3 .5
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Qusongite
	Leciejewicz J
	Acta Crystallographica 14 (1961) 200-200
	A note on the structure of tungsten carbide
	_database_code_amcsd 0009247
	2.9065 2.9065 2.8366 90 90 120 P-6m2
	atom x y z Biso
	W 0 0 0 1.11
	C 2/3 1/3 .5 1.11
	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 + '2' where hostname='216.73.216.214'