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

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

	Mo3 O25 P5.8 Si2 Tl
	Leclaire A, Monier J, Raveau B
	Acta Crystallographica B40 (1984) 180-185
	A molybdosilicophosphate with an intersecting - tunnel structure, which
	exhibits ion - exchange properties, a Mo3 P5.8 Si2 O25 (A = Rb, Tl)
	_cod_database_code 1001853
	_database_code_amcsd 0009804
	8.2832 8.2832 17.4343 90 90 120 P-31c
	atom x y z occ
	Mo1 1/3 -.3333 .02220
	Mo2 -.3333 1/3 .25
	Tl1 1/3 -.3333 .25
	P1 .37818 .32978 .11045 .97
	Si1 0 0 .09101
	O1 .11354 -.40731 .09473
	O2 -.19013 .24785 .45347
	O3 .46868 .33401 .18721
	O4 0 0 0
	O5 .03358 -.16436 .12344
	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'