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 ( ( contents LIKE '%_database_code_amcsd%') AND ( contents LIKE '%0014740%') )

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

	Muscovite-2M1
	Rothbauer R
	Neues Jahrbuch fur Mineralogie, Monatshefte 1971 (1971) 143-154
	Untersuchung eines 2M1-muskovits mit neutronenstrahlen
	Locality: Diamond mine, Black Hills, South Dakota, USA
	_database_code_amcsd 0014740
	5.19182 9.01535 20.04577 90 95.7353 90 C2/c
	atom x y z occ B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	K 0 .0980 .25 .0191 .0053 .00116 0 .0005 0
	Al .2502 .0835 .00008 .935 .0049 .0017 .00025 -.0001 .0003 .00012
	Fe .2502 .0835 .00008 .065 .0049 .0017 .00025 -.0001 .0003 .00012
	SiT1 .4646 .9291 .13553 .75 .0048 .0014 .00043 -.0002 .0000 -.00004
	AlT1 .4646 .9291 .13553 .25 .0048 .0014 .00043 -.0002 .0000 -.00004
	SiT2 .4516 .2581 .13559 .75 .0049 .0014 .00045 .0003 .0003 .00012
	AlT2 .4516 .2581 .13559 .25 .0049 .0014 .00045 .0003 .0003 .00012
	H .3727 .6499 .0599 .020 .0066 .0035 -.0012 .0036 -.0023
	O1 .4167 .0927 .16829 .0150 .0022 .00062 .0006 .0008 .00006
	O2 .2505 .8107 .15783 .0087 .0046 .00075 -.0017 .0001 .00043
	O3 .2502 .3703 .16869 .0094 .0039 .00055 .0019 .0002 -.00005
	O4 .4610 .9432 .05343 .0069 .0025 .00038 .0002 .0003 .00007
	O5 .3859 .2515 .05348 .0082 .0022 .00040 .0001 .0002 .00008
	O6 .4566 .5627 .05018 .0096 .0033 .00051 -.0009 .0004 -.00031
	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-85.crawl.commoncrawl.org'

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