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

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

	Cr Cu P2 S6
	Maisonneuve V, Cajipe V, Payen C
	Chemistry of Materials 5 (1993) 758-760
	Low-temperature neutron powder diffraction study of CuCrP2S6:
	observation of an ordered, antipolar copper sublattice
	_cod_database_code 1000355
	_database_code_amcsd 0012200
	5.935 10.282 13.368 90 106.78 90 Pb
	atom x y z
	Cu1 .071 0 .355
	Cu2 .441 .496 .148
	Cr1 0 .332 .25
	Cr2 .527 .830 .246
	P1 .079 .337 .827
	P2 .545 .838 .817
	P3 .954 .668 .154
	P4 .457 .837 .645
	S1 .725 .996 .371
	S2 .247 .491 .368
	S3 .29 .011 .625
	S4 .802 .491 .118
	S5 .288 .176 .867
	S6 .757 .682 .869
	S7 .739 .826 .115
	S8 .230 .684 .626
	S9 .261 .183 .372
	S10 .768 .668 .362
	S11 .786 .832 .627
	S12 .263 .688 .119
	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'