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

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

	Taranakite
	Dick S, Gossner U, Weiss A, Robl C, Grossman G, Ohms G, Zeiske T
	Inorganica Chimica Acta 269 (1998) 47-57
	Taranakite - the mineral with the longest crystallographic axis
	Locality: synthetic
	_database_code_amcsd 0012725
	8.7025 8.7025 95.05 90 90 120 R-3c
	atom x y z Uiso
	K .5768 0 .25 .028
	Al1 0 0 .25 .010
	Al2 2/3 1/3 .2845 .015
	Al3 0 0 .2973 .011
	P1 .2813 .0456 .2731 .011
	P2 0 0 .6350 .012
	O1 .2058 .0991 .2612 .013
	O2 .2025 .0484 .2873 .016
	Oh3 .2482 .8545 .2697 .019
	O4 .4814 .1689 .2736 .016
	O5 0 0 .6186 .016
	O6 .1557 .5120 .3067 .017
	Ow7 .5045 .3577 .2971 .021
	Ow8 .8010 -.0630 .3094 .018
	Ow9 .5358 .5666 .3333 .029
	H1 .5162 .7207 .2762 .076
	H2 .5095 .4492 .2996 .052
	H3 .4024 .2944 .2964 .052
	H4 .8122 -.0105 .3165 .040
	H5 .7024 .8401 .3088 .040
	H6 .5201 .5998 .3254 .029
	H7 .7997 .6553 .3331 .029
	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='216.73.216.165'

Line 943: Update statistic set count=count + '1' where hostname='216.73.216.165'