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

the size of the result array is 3

the size of the diff result array is 0

The total results from the merged set is 3

The total number of rows in result set is 3

The paginate value is 1

entering paginate loop

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

the file_query is

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

	Heazlewoodite
	Fleet M E
	American Mineralogist 62 (1977) 341-345
	The crystal structure of heazlewoodite, and metallic bonds in sulfide minerals
	_database_code_amcsd 0000575
	4.0821 4.0821 4.0821 89.475 89.475 89.475 R32
	atom x y z Biso
	Ni .5 .247 -.247 1.13
	S .255 .255 .255 .05
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Heazlewoodite
	Parise J B
	Acta Crystallographica B36 (1980) 1179-1180
	Structure of hazelwoodite (Ni3S2)
	Locality: synthetic
	_database_code_amcsd 0009709
	4.0718 4.0718 4.0718 89.459 89.459 89.459 R32
	atom x y z B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	Ni .5 .2449 -.2449 .0162 .0124 .0124 .0002 .0002 .0004
	S .2521 .2521 .2521 .0138 .0138 .0138 .0008 .0008 .0008
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Heazlewoodite
	Westgren A
	Zeitschrift fur Anorganische und Allgemeine Chemie 239 (1938) 82-84
	Die Kristallstruktur von Ni3 S2
	_cod_database_code 1011250
	_database_code_amcsd 0018112
	4.049 4.049 4.049 90.3 90.3 90.3 R32
	atom x y z
	Ni1 .5 .25 -.25
	S1 .25 .25 .25
	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-84.crawl.commoncrawl.org'

Line 943: Update statistic set count=count + '3' where hostname='18-97-14-84.crawl.commoncrawl.org'