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

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 ('04048.amc', '04049.amc', '10915.amc') order by fileno

	Pentahydrite
	Peterson R C, Hammarstrom J M, Seal R R
	American Mineralogist 91 (2006) 261-269
	Alpersite (Mg,Cu)SO4*7H2O, a new mineral of the melanterite group, and cuprian
	pentahydrite: Their occurrence within mine waste
	Locality: Big Mike mine, Nevada, USA
	_database_code_amcsd 0004016
	6.2490 10.5846 6.0384 82.461 109.433 104.805 P-1
	atom x y z occ Uiso
	Mg1 0 0 0 .2 .049
	Cu1 0 0 0 .8 .049
	Mg2 .5 .5 0 .7 .048
	Cu2 .5 .5 0 .3 .048
	S .0363 .2884 .6392 .036
	O1 .910 .1601 .669 .037
	O2 .261 .3232 .842 .037
	O3 .872 .3715 .638 .037
	O4 .051 .2981 .408 .037
	Wat1 .820 .0683 .173 .037
	Wat2 .314 .1172 .174 .037
	Wat3 .530 .5959 .672 .037
	Wat4 .232 .5913 .981 .037
	Wat5 .453 .1276 .648 .037
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Pentahydrite
	Peterson R C, Hammarstrom J M, Seal R R
	American Mineralogist 91 (2006) 261-269
	Alpersite (Mg,Cu)SO4*7H2O, a new mineral of the melanterite group, and cuprian
	pentahydrite: Their occurrence within mine waste
	Locality: Miami, Arizona, USA
	_database_code_amcsd 0004017
	6.2470 10.5995 6.0395 82.530 109.408 104.794 P-1
	atom x y z occ Uiso
	Mg1 0 0 0 .1 .056
	Cu1 0 0 0 .9 .056
	Mg2 .5 .5 0 .7 .037
	Cu2 .5 .5 0 .3 .037
	S .0368 .2935 .6402 .039
	O1 .911 .1662 .666 .037
	O2 .263 .3227 .847 .037
	O3 .872 .3720 .639 .037
	O4 .053 .2958 .411 .037
	Wat1 .821 .0687 .178 .037
	Wat2 .312 .1161 .173 .037
	Wat3 .535 .5917 .671 .037
	Wat4 .230 .5917 .988 .037
	Wat5 .446 .1289 .647 .037
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Pentahydrite
	Baur W H, Rolin J L
	Acta Crystallographica B28 (1972) 1448-1455
	Salt hydrates. IX. The comparison of the crystal structure of magnesium sulfate
	pentahydrate with copper sulfate pentahydrate and magnesium chromate pentahydrate
	Locality: synthetic
	_database_code_amcsd 0009436
	6.314 10.505 6.030 81.12 109.82 105.08 P-1
	atom x y z Biso B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	Mg1 0 0 0 .0093 .0018 .0078 -.0005 -.0022 -.0002
	Mg2 .5 .5 0 .0068 .0018 .0061 .0006 .0022 -.0002
	S .0371 .2897 .6624 .0060 .0017 .0053 .0003 .0012 .0000
	O1 .9464 .1509 .7309 .0125 .0023 .0104 -.0010 .0014 .0015
	O2 .2680 .3344 .8331 .0083 .0028 .0128 -.0002 -.0019 -.0014
	O3 .8808 .3711 .6610 .0126 .0046 .0128 .0044 .0036 -.0008
	O4 .0590 .2986 .4256 .0135 .0038 .0074 -.0012 .0056 -.0003
	O5 .8279 .0768 .1639 .0192 .0039 .0186 -.0004 .0114 -.0032
	O6 .3086 .1139 .1848 .0149 .0032 .0119 -.0008 .0012 -.0006
	O7 .4745 .4042 .3153 .0118 .0052 .0085 .0013 .0028 .0016
	O8 .7567 .4077 .0318 .0118 .0063 .0104 .0047 .0022 -.0006
	O9 .4589 .1324 .6699 .0113 .0051 .0178 .0009 .0035 .0006
	H54 .908 .146 .260 2.5
	H59 .724 .023 .230 2.5
	H62 .331 .192 .117 1.9
	H69 .336 .148 .321 1.9
	H73 .562 .402 .411 1.8
	H74 .350 .392 .349 1.8
	H83 .786 .385 .919 2.1
	H84 .842 .374 .179 2.1
	H91 .585 .115 .733 2.2
	H92 .433 .201 .706 2.2
	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-81.crawl.commoncrawl.org'

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