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

the size of the result array is 8

the size of the diff result array is 0

The total results from the merged set is 8

The total number of rows in result set is 8

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('06027.amc', '06028.amc', '06029.amc', '06030.amc', '12273.amc', '12284.amc', '13778.amc', '19721.amc') order by fileno

	Zincite
	Kihara K, Donnay G
	The Canadian Mineralogist 23 (1985) 647-654
	Anharmonic thermal vibrations in ZnO
	Model: 2-c, at T = 293 K
	_database_code_amcsd 0005203
	3.2494 3.2494 5.2038 90 90 120 P6_3mc
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Zn 1/3 2/3 0 .0182 .0182 .0054 .0091 0 0
	O 1/3 2/3 .3821 .0181 .0181 .0054 .00905 0 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)
	Zincite
	Kihara K, Donnay G
	The Canadian Mineralogist 23 (1985) 647-654
	Anharmonic thermal vibrations in ZnO
	Model: 2-c, at T = 473 K
	_database_code_amcsd 0005204
	3.2533 3.2533 5.2073 90 90 120 P6_3mc
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Zn 1/3 2/3 0 .0280 .0280 .0083 .0140 0 0
	O 1/3 2/3 .3820 .0261 .0261 .0076 .01305 0 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)
	Zincite
	Kihara K, Donnay G
	The Canadian Mineralogist 23 (1985) 647-654
	Anharmonic thermal vibrations in ZnO
	Model: 3-c, at T = 293 K
	_database_code_amcsd 0005205
	3.2494 3.2494 5.2038 90 90 120 P6_3mc
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Zn 1/3 2/3 0 .0183 .0183 .0054 .00915 0 0
	O 1/3 2/3 .3830 .0182 .0182 .0054 .0091 0 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)
	Zincite
	Kihara K, Donnay G
	The Canadian Mineralogist 23 (1985) 647-654
	Anharmonic thermal vibrations in ZnO
	Model: 3-c, at T = 473 K
	_database_code_amcsd 0005206
	3.2533 3.2533 5.2073 90 90 120 P6_3mc
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Zn 1/3 2/3 0 .0278 .0278 .0082 .0139 0 0
	O 1/3 2/3 .3778 .0259 .0259 .0074 .01295 0 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)
	Zincite
	Aminoff G
	Zeitschrift fur Kristallographie 56 (1921) 495-505
	Ueber Lauephotogramme und Struktur von Zinkit.
	_cod_database_code 1011258
	_database_code_amcsd 0018119
	3.22 3.22 5.2 90 90 120 P6_3mc
	atom x y z
	Zn1 1/3 2/3 0
	O1 1/3 2/3 .375
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Zincite
	Weber L
	Zeitschrift fur Kristallographie 58 (1923) 398-403
	Die Struktur von Zn O.
	_cod_database_code 1011259
	_database_code_amcsd 0018120
	3.351 3.351 5.226 90 90 120 P6_3mc
	atom x y z
	Zn1 1/3 2/3 0
	O1 1/3 2/3 .375
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Zincite
	Wyckoff R W G
	Crystal Structures 1 (1963) 85-237
	Second edition. Interscience Publishers, New York, New York
	Note: wurtzite structure
	_database_code_amcsd 0011555
	3.24950 3.24950 5.2069 90 90 120 P6_3mc
	atom x y z
	Zn 1/3 2/3 0
	O 1/3 2/3 .345
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Zincite
	Xu Y N, Ching W Y
	Physical Review B48 (1993) 4335-4351
	Electronic, optical, and structural properties of some wurtzite crystals
	_database_code_amcsd 0015176
	3.249 3.249 5.207 90 90 120 P6_3mc
	atom x y z
	Zn 2/3 1/3 0
	O 2/3 1/3 .345
	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-81.crawl.commoncrawl.org'

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