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

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 ('05896.amc', '14641.amc', '19162.amc') order by fileno

	Lindgrenite
	Calvert L D, Barnes W H
	The Canadian Mineralogist 6 (1957) 31-51
	The structure of lindgrenite
	_database_code_amcsd 0005073
	5.61 14.03 5.40 90 98.38 90 P2_1/n
	atom x y z Biso
	Cu1 0 0 0 .53
	Cu2 .4885 .0942 .8642 .53
	Mo .8769 .1544 .4552 .53
	O1 .432 .221 .977 1.0
	O2 .096 .094 .642 1.0
	O3 .600 .130 .554 1.0
	O4 .866 .112 .149 1.0
	OH .341 .031 .123 1.0
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Lindgrenite
	Bao R L, Kong Z P, Cu M, Yue B, Weng L H, He H Y
	Chemical Research in Chinese Universities 22 (2006) 679-683
	Hydrothermal synthesis and thermal stability of natural mineral lindgrenite
	Locality: synthetic
	Note: atomic coordinates transformed to standard setting
	_database_code_amcsd 0018341
	5.3867 14.001 5.6010 90 98.535 90 P2_1/n
	atom x y z Uiso
	Mo .04373 .65456 .62285 .0088
	Cu1 .5 .5 .5 .0100
	Cu2 .13614 .90608 .51287 .0108
	O1 .3548 .6130 .6254 .0129
	O2 .0213 .7767 .5630 .0196
	O3 .1509 .4079 .5998 .0168
	O4 .0524 .3701 .0998 .0151
	OH5 .1316 .0306 .3600 .0113
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Lindgrenite
	Hawthorne F C, Eby R K
	Neues Jahrbuch fur Mineralogie, Monatshefte 1985 (1985) 234-240
	Refinement of the crystal structure of lindgrenite
	Locality: Chuquicamata, Chile
	_database_code_amcsd 0014795
	5.394 14.023 5.608 90 98.50 90 P2_1/n
	atom x y z Biso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Cu1 0 0 0 .99 .0118 .0089 .0090 -.0020 .0018 .0014
	Cu2 .8638 .09393 .4870 1.05 .0117 .0075 .0132 .0016 .0048 .0012
	Mo .45592 .15456 .87716 .86 .0092 .0065 .0103 .0000 .0020 -.0008
	O1 .9801 .2234 .4358 1.9 .0221 .0074 .0280 .0009 .0055 .0037
	O2 .6505 .0918 .1009 1.8 .0200 .0178 .0157 .0053 -.0017 -.0014
	O3 .5532 .1299 .5938 1.5 .0128 .0180 .0145 .0012 .0065 -.0002
	O4 .1448 .1130 .8730 1.4 .0128 .0141 .0150 -.0037 .0030 .0014
	O5 .1321 .0306 .3405 1.0 .0131 .0071 .0113 -.0004 .0030 .0001
	H5 .27 .048 .35 1.0
	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-168.crawl.commoncrawl.org'

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