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

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

	Ba1.04 Ca0.78 Cu2 O7 Sr0.96 Tl1.22
	Labbe P, Ledesert M, Maignan A, Martin C, Leligny H, Raveau B
	Acta Crystallographica B51 (1995) 18-22
	Single crystal study of the 'BaSr' 1212 superconductor Tl1+xBaSrCa1-xCu2O7-d
	_cod_database_code 1001659
	_database_code_amcsd 0009886
	3.8234 3.8234 12.384 90 90 90 P4/mmm
	atom x y z occ
	Tl1 .0862 0 0 .25
	Ca1 .5 .5 .5 .78
	Tl2 .5 .5 .5 .22
	Ba1 .5 .5 .2128 .52
	Sr1 .5 .5 .2128 .48
	Cu1 0 0 .3675
	O1 .5 0 .3749
	O2 0 0 .164
	O3 .5 .5 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)

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

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