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

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 ('12684.amc', '15596.amc', '20319.amc') order by fileno

	Jamesonite
	Niizeki N, Buerger M J
	Zeitschrift fur Kristallographie 109 (1957) 161-183
	The crystal structure of jamesonite, FePb4Sb6S14
	_database_code_amcsd 0010581
	15.57 18.98 4.03 90 91.8 90 P2_1/a
	atom x y z Biso
	Fe 0 0 0 1.08
	Pb1 .182 .141 .036 1.21
	Pb2 .425 .240 .062 1.08
	Sb1 .319 .437 .408 .75
	Sb2 .396 .049 .623 .74
	Sb3 .130 .340 .620 1.05
	S1 .419 .395 .968 .21
	S2 .095 .042 .524 .59
	S3 .316 .158 .555 .73
	S4 .226 .297 .076 .73
	S5 .050 .230 .573 .17
	S6 .002 .398 .052 .71
	S7 .285 .004 .027 .41
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Jamesonite
	Matsushita Y, Ueda Y
	Inorganic Chemistry 42 (2003) 7830-7838
	Structure and physical properties of 1D magnetic chalcogenide,
	jamesonite (FePb4Sb6S14)
	Locality: synthetic
	_database_code_amcsd 0018283
	15.750 19.125 4.030 90 91.68 90 P2_1/a
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Pb1 -.07429 .26108 .0556 .0211 .023 .0210 .0198 .0003 .0023 -.0006
	Pb2 -.31702 .35932 .0341 .0233 .015 .0353 .0200 .0037 .0015 -.0014
	Sb1 .1312 .34110 -.3872 .0201 .006 .0223 .0319 -.0053 -.0066 .0088
	Sb2 -.10379 .45257 -.3874 .0153 .001 .0190 .0259 .0011 .0030 -.0005
	Sb3 -.17991 .06342 .4116 .0167 .007 .0172 .0263 .0037 .0085 .0018
	Fe 0 0 0 .017 .006 .016 .028 .007 .008 .0033
	S1 -.2157 .4968 .0268 .015 .003 .022 .022 .003 .006 -.003
	S2 -.0796 .1056 -.0108 .018 .016 .011 .027 .000 .010 .0022
	S3 .0959 .0436 -.4770 .014 .010 .013 .020 .001 .003 .0025
	S4 .0516 .2307 -.4319 .019 .025 .015 .017 -.002 .001 .0002
	S5 -.1833 .3414 -.4505 .016 .015 .017 .016 -.001 -.003 -.0017
	S6 .0024 .3981 .0466 .017 .007 .021 .021 -.003 -.005 .001
	S7 -.2747 .2038 .0747 .019 .003 .022 .032 .003 .005 -.001
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Jamesonite
	Leone P, Le Leuch L M, Palvadeau P, Molinie P, Moelo Y
	Solid State Sciences 5 (2003) 771-776
	Single crystal structures and magnetic properties of two iron or
	manganese-lead-antimony sulfides: MPb4Sb6S14 (M: Fe, Mn)
	Locality: Siberia
	_database_code_amcsd 0015519
	4.0235 19.074 15.737 90 91.89 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)
	Pb1 .4415 .23983 .57470 .0349 .0354 .0328 .0364 .0005 -.0001 .0005
	Pb2 .4638 .14056 .81770 .0376 .0352 .0437 .0340 -.0006 -.0003 .0033
	Sb1 .8819 .04877 .60418 .0325 .0420 .0280 .0277 -.0026 .0030 .0012
	Sb2 .9109 .93675 .81978 .0315 .0374 .0288 .0288 -.0020 .0072 -.0035
	Sb3 .8814 .15908 .36996 .0373 .0480 .0304 .0329 -.0102 -.0092 .0055
	Fe .5 0 0 .0359 .053 .025 .030 -.005 .009 -.004
	S1 .4548 .1021 .4970 .0315
	S2 .9492 .1591 .6826 .0293
	S3 .9767 .0437 .9042 .0259
	S4 .9301 .2691 .4479 .0293
	S5 .4690 .0038 .7141 .0295
	S6 .4230 .2964 .7757 .0342
	S7 .5126 .3937 .5812 .0323
	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-89.crawl.commoncrawl.org'

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