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

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

	Likasite
	Effenberger H
	Neues Jahrbuch fur Mineralogie, Monatshefte 1986 (1986) 101-110
	Likasite, Cu3(OH)5(NO3)*2(H2O): Revision of the chemical formula and
	redetermination of the crystal structure
	Locality: Likasi Mine, Zaire
	_database_code_amcsd 0014798
	5.830 6.775 21.711 90 90 90 Pcmn
	atom x y z U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Cu1 .8224 .25 .1055 .003 .011 .023 0 -.001 0
	Cu2 .3284 .25 .1003 .003 .010 .024 0 -.003 0
	Cu3 0 0 0 .016 .014 .021 .002 -.004 -.001
	N .080 .25 .242 .038 .012 .023 0 -.001 0
	O1 .261 .25 .210 .012 .046 .036 0 .001 0
	O2 -.103 .25 .214 .014 .048 .028 0 -.006 0
	O3 .088 .25 .299 .030 .013 .019 0 .001 0
	OH1 .158 .75 .002 .004 .012 .027 0 -.008 0
	OH2 .076 .060 .086 .017 .009 .018 -.004 -.005 .002
	OH3 .573 .055 .109 .006 .011 .026 -.004 .001 .002
	Wat1 .082 .75 .170 .029 .019 .026 0 .000 0
	Wat2 .628 .75 .030 .035 .018 .043 0 -.005 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-9-168.crawl.commoncrawl.org'

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