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

the size of the result array is 2

the size of the diff result array is 0

The total results from the merged set is 2

The total number of rows in result set is 2

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('10743.amc', '20407.amc') order by fileno

	Nickelboussingaultite
	Montgomery H, Lingafelter E C
	Acta Crystallographica 17 (1964) 1478-1479
	The crystal structure of Tutton's salts. II.
	Magnesium ammonium sulfate hexahydrate and nickel ammonium sulfate hexahydrate
	Locality: synthetic
	_database_code_amcsd 0020239
	9.241 12.554 6.243 90 106.97 90 P2_1/a
	atom x y z
	N1 .1354 .3452 .3543
	H1 .074 .305 .168
	H2 .192 .323 .391
	H3 .082 .347 .375
	Ni 0 0 0
	S .4074 .1369 .7390
	O1 .4144 .2272 .5912
	O2 .5485 .0754 .7883
	O3 .2789 .0671 .6218
	O4 .3839 .1774 .9478
	O5 .1682 .1071 .1639
	O6 -.1600 .1100 .0357
	O7 .0019 -.0661 .2987
	H4 .137 .399 .337
	H5 .187 .094 .323
	H6 .214 .124 .116
	H7 -.245 .089 -.056
	H8 -.146 .184 .023
	H9 -.086 -.058 .352
	H10 .004 -.143 .333
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Nickelboussingaultite
	Treushnikov E N, Kuskov V I, Soboleva L V, Belov N V
	Soviet Physics Crystallography 23 (1978) 30-41
	Distribution of electron density in nickel ammonium sulphate hexahydrate
	[Ni*6H2O](NH4)2(SO4)2 from x-ray diffraction data
	Locality: synthetic
	_database_code_amcsd 0015578
	6.243 9.484 12.467 90 90 112.067 P2_1/n
	atom x y z Biso B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	N .77845 .13556 .34633 .01744 .00669 .00446 .00289 .00074 .00047
	H7 .634 .087 .356 1.8
	H8 .808 .213 .305 1.3
	H9 .841 .071 .338 1.8
	H10 .831 .175 .416 2.3
	Ni .5 .5 .5 .01062 .00301 .00187 .00177 .00017 .00034
	S .16861 -.09238 .36337 .01283 .00372 .00222 .00244 .00039 .00004
	O1 -.06436 -.11650 .32312 .01600 .00999 .00349 .00563 .00098 -.00046
	O2 .32473 -.08593 .27243 .01744 .01064 .00330 .00535 .00119 .00196
	O3 .26179 .04864 .42481 .03448 .00512 .00525 .00339 -.00133 -.00258
	O4 .15884 -.22062 .43327 .01869 .00551 .00351 .00330 .00136 -.00033
	O5 .29735 -.00195 .06649 .01410 .00688 .00301 .00351 .00025 -.00033
	O6 .00597 .16859 .10708 .01785 .00595 .00349 .00461 -.00115 -.0009
	O7 .30469 .33931 .38990 .01772 .00530 .00293 .00217 -.00031 -.00033
	H1 .415 .086 .072 1.7
	H2 .789 .471 .362 1.9
	H3 .902 .213 .090 1.6
	H4 .145 .241 .125 .6
	H5 .371 .364 .322 1.9
	H6 .291 .243 .408 1.6
	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-170.crawl.commoncrawl.org'

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