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 ( ( contents LIKE '%_database_code_amcsd%') AND ( contents LIKE '%0017036%') )

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

	H4 K4 Mo N8 O2
	Hoard J, Nordsieck H
	Journal of the American Chemical Society 61 (1939) 2853-2863
	The Structure of Potassium Molybdocyanide Dihydrate. The Configuration
	of the Molybdenum Octocyanide Group
	_cod_database_code 1010103
	_database_code_amcsd 0017036
	16.55 11.7 8.68 90 90 90 Pnma
	atom x y z
	K1 .147 .042 .69
	K2 .363 .25 .53
	K3 -.037 .25 .477
	Mo1 .135 .25 .094
	C1 .036 .15 .18
	C2 .168 .07 .072
	C3 .059 .25 -.09
	C4 .214 .25 -.105
	C5 .264 .25 .175
	C6 .14 .25 .34
	N1 -.009 .08 .21
	N2 .181 -.025 .055
	N3 .015 .25 -.21
	N4 .256 .25 -.216
	N5 .325 .25 .214
	N6 .14 .25 .467
	O1 .11 -.05 .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)

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-9-175.crawl.commoncrawl.org'

Line 943: Update statistic set count=count + '1' where hostname='18-97-9-175.crawl.commoncrawl.org'