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

the size of the result array is 4

the size of the diff result array is 0

The total results from the merged set is 4

The total number of rows in result set is 4

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('12579.amc', '12586.amc', '13153.amc', '16092.amc') order by fileno

	Eriochalcite
	Harker D
	Zeitschrift fur Kristallographie 93 (1936) 136-145
	The Crystal Structure of Cupric Chloride Dihydrate Cu Cl2 (H2 O)2
	_cod_database_code 1011014
	_database_code_amcsd 0017922
	7.38 8.04 3.72 90 90 90 Pbmn
	atom x y z
	Cu1 0 0 0
	O1 0 .25 0
	Cl1 .25 0 .37
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Eriochalcite
	MacGillavry C H, Bijvoet J M
	Zeitschrift fur Kristallographie 94 (1936) 231-245
	Die kristallstruktur der cadmium-und
	quecksilber-diammin-dihalogenide
	Locality: synthetic
	_database_code_amcsd 0010555
	7.40 8.06 3.74 90 90 90 Pbmn
	atom x y z
	Cu 0 0 0
	Cl .239 0 .378
	Wat 0 .25 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)
	Eriochalcite
	Brownstein S, Han N F, Gabe E, LePage Y
	Zeitschrift fur Kristallographie 189 (1989) 13-15
	A redetermination of the crystal structure of cupric chloride dihydrate
	Locality: synthetic
	_database_code_amcsd 0010986
	7.4141 8.0886 3.7458 90 90 90 Pbmn
	atom x y z Biso
	Cu 0 0 0 1.67
	Cl .23998 0 .3798 1.79
	O 0 .2402 0 2.52
	H .099 .275 .064 5.4
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Eriochalcite
	Peterson S, Levy H
	Journal of Chemical Physics 26 (1957) 220-221
	Proton positions in Cu Cl2 (H2 O)2 by neutron diffraction
	_cod_database_code 1008760
	_database_code_amcsd 0016637
	7.395 8.056 3.728 90 90 90 Pbmn
	atom x y z
	Cu1 0 0 0
	O1 0 .239 0
	Cl1 .2402 0 .3804
	H1 .0822 .3065 .1295
	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 + '4' where hostname='216.73.216.214'