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

the size of the result array is 1

the size of the diff result array is 0

The total results from the merged set is 1

The total number of rows in result set is 1

The paginate value is 1

entering paginate loop

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

the file_query is

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

	Diaphorite
	Armbruster T, Makovicky E, Berlepsch P, Sejkora J
	European Journal of Mineralogy 15 (2003) 137-146
	Crystal structure, cation ordering, and polytypic character of diaphorite,
	Pb2Ag3Sb3S8, a PbS-based structure
	_database_code_amcsd 0006959
	17.8520 5.8870 15.8090 90 116.165 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)
	Pb1 .18973 -.31003 .54127 .02062 .0184 .0194 .0237 .00031 .00901 .00138
	AgM1 .06451 .19426 .34402 .516 .0274 .0241 .0305 .0302 -.0002 .0144 .0019
	PbM1 .06451 .19426 .34402 .484 .0274 .0241 .0305 .0302 -.0002 .0144 .0019
	AgM2 .30967 .28176 .22247 .596 .0302 .0282 .0349 .0190 -.0021 .0027 .0012
	PbM2 .30967 .28176 .22247 .404 .0302 .0282 .0349 .0190 -.0021 .0027 .0012
	Ag3 .43323 .7581 .14479 .0436 .0519 .0362 .0634 -.0028 .0443 .0001
	Ag4 .19471 .7117 .28096 .0488 .0519 .0411 .0298 -.0007 -.0035 .0039
	Sb1 .31616 .21030 .46489 .01691 .0150 .0146 .0200 -.0001 .0066 -.0011
	Sb2 .43998 .76228 .39980 .01630 .0159 .0147 .0180 .0007 .0072 -.0005
	Sb3 -.06306 -.28248 .39950 .01611 .0151 .0157 .0174 .0007 .0070 .0022
	S1 .21050 .1518 .5268 .0258 .0274 .0165 .0451 .0004 .0266 .0014
	S2 -.07340 .1276 .3823 .0248 .0317 .0181 .0264 .0037 .0145 .0010
	S3 .29638 .6251 .45152 .0171 .0167 .0148 .0202 .0000 .0085 .0002
	S4 .17373 .1536 .2598 .0291 .0204 .0308 .0246 .0034 -.0006 .0012
	S5 .44417 .3501 .3896 .0235 .0301 .0150 .0332 -.0001 .0210 -.0001
	S6 .05450 .6754 .35830 .0203 .0144 .0256 .0207 .0003 .0077 -.0015
	S7 .34461 .8159 .23088 .0223 .0183 .0277 .0162 .0028 .0031 .0014
	S8 .43137 .1945 .62829 .0189 .0129 .0228 .0187 -.0005 .0050 .0028
	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-171.crawl.commoncrawl.org'

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