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

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

	Hephaistosite
	Campostrini I, Demartin F, Gramaccioli C M, Orlandi P
	The Canadian Mineralogist 46 (2008) 701-708
	Hephaistosite, TlPb2Cl5, a new thallium mineral series from La Fossa Crater,
	Vulcano, Aeolian Islands, Italy
	Location: La Fossa Crater, Vulcano, Aeolian Islands, Italy
	_database_code_amcsd 0006195
	8.9477 7.9218 12.4955 90 90.092 90 P2_1/c
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Tl .98934 -.05117 .16638 .0341 .0314 .0340 .0368 .0058 .0030 .0059
	Pb1 .49483 -.00984 .17439 .0235 .0250 .0239 .0215 -.0028 .0003 -.0017
	Pb2 .75346 .43582 .0062 .0206 .0185 .0223 .0209 .0007 .0011 -.0015
	Cl1 .0409 .3220 .0800 .0269 .0170 .0262 .0375 -.0005 .0005 .0156
	Cl2 .4574 .3343 .0965 .0210 .0179 .0185 .0266 .0017 -.0003 .0044
	Cl3 .2748 .1575 .3118 .0209 .0269 .0206 .0152 .0073 .0073 .0047
	Cl4 .7189 .0408 .0016 .0203 .0220 .0207 .0183 .0003 .0006 -.0015
	Cl5 .7308 .1875 .2782 .0221 .0245 .0223 .0196 -.0021 -.0001 -.0019
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Hephaistosite
	Mitolo D, Pinto D, Garavelli A, Bindi L, Vurro F
	Mineralogy and Petrology 96 (2009) 121-128
	The role of the minor substitutions in the crystal structure of natural
	challacolloite, KPb2Cl5, and hephaistosite, TiPb2Cl5, from Vulcano
	(Aeolian Archipelago, Italy)
	Locality: rim of La Fossa Crater, Vulcano, Aeolian Archipelago, Italy
	_database_code_amcsd 0019023
	9.0026 7.9723 12.5693 90 90.046 90 P2_1/c
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Tl .51061 .0513 .16613 .96 .03742 .03398 .03732 .04096 .00587 -.0019313 -.00614
	K .51061 .0513 .16613 .04 .03742 .03398 .03732 .04096 .00587 -.0019313 -.00614
	Pb1 .00494 .01016 .17445 .02627 .02654 .02688 .02540 -.00280 .00120 .00190
	Pb2 .25319 .43580 .99381 .02340 .01982 .02576 .02461 .00065 .00044 .00152
	Cl1 .95742 .16571 .40370 .02330 .02016 .02126 .02845 -.00042 .00058 .00482
	Cl2 .21853 .04106 .99871 .02268 .02305 .02462 .02038 -.00030 .00026 .00069
	Cl3 .54089 .17836 .42000 .95 .03292 .02124 .03215 .04540 .00124 .00150 .01348
	Br3 .54089 .17836 .42000 .05 .03292 .02124 .03215 .04540 .00124 .00150 .01348
	Cl4 .23033 .31284 .22191 .98 .02560 .02646 .02501 .02533 .00262 .00210 -.00312
	Br4 .23033 .31284 .22191 .02 .02560 .02646 .02501 .02533 .00262 .00210 -.00312
	Cl5 .77524 .34302 .18835 .89 .03040 .03638 .02868 .02613 -.00712 -.00700 .00560
	Br5 .77524 .34302 .18835 .11 .03040 .03638 .02868 .02613 -.00712 -.00700 .00560
	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-80.crawl.commoncrawl.org'

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