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 ( Mineral LIKE 'Atacamite%')

the size of the result array is 3

the size of the diff result array is 0

The total results from the merged set is 3

The total number of rows in result set is 3

The paginate value is 1

entering paginate loop

The total number to display on this page is 3 3 matching records for this search.

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('10552.amc', '11736.amc', '19824.amc') order by fileno

	Atacamite
	Wells A F
	Acta Crystallographica 2 (1949) 175-180
	The crystal structure of atacamite and the crystal chemistry of
	cupric compounds
	_database_code_amcsd 0009136
	6.01 9.13 6.84 90 90 90 Pnam
	atom x y z
	Cu1 0 0 0
	Cu2 .192 .258 .25
	Cl .350 .058 .75
	OH1 .185 0 .25
	OH2 .430 .292 .065
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Atacamite
	Parise J B, Hyde B G
	Acta Crystallographica C42 (1986) 1277-1280
	The structure of atacamite and its relationship to spinel
	Locality: Mina La Farola, Chile
	_database_code_amcsd 0010032
	6.030 6.865 9.120 90 90 90 Pnma
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Cu1 0 0 0 .007 .008 .008 .007 -.002 .001 -.001
	Cu2 .1906 .25 .2553 .007 .005 .008 .010 0 -.002 0
	Cl .3518 .75 .0556 .012 .009 .015 .013 0 -.002 0
	O1 .1498 .25 -.0018 .011 .011 .010 .014 0 .002 0
	O2 .4406 .0651 .2879 .008 .009 .009 .009 .001 -.001 -.001
	H1 .3049 .25 -.0148 .003
	H2 .4331 -.0334 .2279 .003
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Atacamite
	Zheng X G, Mori T, Nishiyama K, Higemoto W, Yamada H, Nishikubo K, Xu C N
	Physical Review B - Condensed Matter 71 (2005) 174404-8
	Antiferromagnetic transitions in polymorphous minerals of
	the natural cuprates atacamite and botallackite Cu2Cl(OH)3
	Locality: synthetic
	_database_code_amcsd 0019936
	6.02797 6.86383 9.11562 90 90 90 Pnma
	atom x y z Uiso
	Cu1 0 0 0 .0080
	Cu2 .19257 .25 .25603 .0086
	Cl .3514 .75 .0565 .0133
	O1 .1498 .25 -.0069 .0066
	O2 .4394 .0636 .2875 .0067
	H1 .585 .75 .059 .0066
	H2 .389 .579 .133 .0066
	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-85.crawl.commoncrawl.org'

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