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

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

	Phlogopite
	Schingaro E, Lacalamita M, Scordari F, Mesto E
	American Mineralogist 98 (2013) 709-717
	3T-phlogopite from Kasenyi kamafugite (SW Uganda): EPMA, XPS, FTIR, and SCXRD study
	Locality: Kasenyi kamafugite, southwest Uganda
	_database_code_amcsd 0019915
	5.3235 5.3235 30.188 90 90 120 P3_112
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	K .8894 .1106 .8333 .92 .036 .0358 .0358 .0362 .0183 .0037 -.0009
	Na .8894 .1106 .8333 .04 .036 .0358 .0358 .0362 .0183 .0037 -.0009
	MgM1 .9041 .4523 0 .365 .011 .0015 .0087 .0191 .0007 0 .0017
	FeM1 .9041 .4523 0 .08 .011 .0015 .0087 .0191 .0007 0 .0017
	AlM1 .9041 .4523 0 .055 .011 .0015 .0087 .0191 .0007 0 .0017
	MgM2 .2277 .1138 0 .775 .015 .0158 .0091 .0147 .0016 0 .0010
	FeM2 .2277 .1138 0 .06 .015 .0158 .0091 .0147 .0016 0 .0010
	TiM2 .2277 .1138 0 .135 .015 .0158 .0091 .0147 .0016 0 .0010
	CrM2 .2277 .1138 0 .025 .015 .0158 .0091 .0147 .0016 0 .0010
	NiM2 .2277 .1138 0 .005 .015 .0158 .0091 .0147 .0016 0 .0010
	MgM3 1.5772 .7886 0 .775 .010 .0054 .0107 .0114 .0027 0 .0007
	FeM3 1.5772 .7886 0 .06 .010 .0054 .0107 .0114 .0027 0 .0007
	TiM3 1.5772 .7886 0 .135 .010 .0054 .0107 .0114 .0027 0 .0007
	CrM3 1.5772 .7886 0 .025 .010 .0054 .0107 .0114 .0027 0 .0007
	NiM3 1.5772 .7886 0 .005 .010 .0054 .0107 .0114 .0027 0 .0007
	SiT1 .2326 .7870 .90887 .72 .010 .0066 .0095 .0111 .0016 .0012 .0006
	AlT1 .2326 .7870 .90887 .26 .010 .0066 .0095 .0111 .0016 .0012 .0006
	FeT1 .2326 .7870 .90887 .02 .010 .0066 .0095 .0111 .0016 .0012 .0006
	SiT2 .5689 .4405 .90877 .72 .010 .0084 .0109 .0152 .0087 .0005 .0010
	AlT2 .5689 .4405 .90877 .26 .010 .0084 .0109 .0152 .0087 .0005 .0010
	FeT2 .5689 .4405 .90877 .02 .010 .0084 .0109 .0152 .0087 .0005 .0010
	O1 .2361 .7845 .9640 .010 .008 .009 .012 .003 .0003 -.001
	O2 .5694 .4466 .9633 .012 .008 .015 .015 .0070 .0003 .0023
	O3 .3538 .113 .88946 .019 .023 .015 .016 .007 -.001 -.000
	O4 .896 .5776 .88983 .019 .013 .026 .015 .008 .000 -.003
	O5 .4315 .6516 .8894 .020 .026 .023 .018 .018 .004 .003
	OH6 .9017 .1165 .96606 .660 .011 .011 .008 .0131 .005 -.004 -.003
	O6 .9017 .1165 .96606 .325 .011 .011 .008 .0131 .005 -.004 -.003
	F6 .9017 .1165 .96606 .015 .011 .011 .008 .0131 .005 -.004 -.003
	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-175.crawl.commoncrawl.org'

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