Query for year list

gistfile1.txt

{exp:query sql="SELECT DISTINCT cf_statements_sort_date FROM exp_channel_data WHERE channel_id = 53 AND field_id_291 = '{user_language}' ORDER BY cf_statements_sort_date DESC"}

	<li><a href="{path='{segment_1}/{segment_2}/{cf_statements_order_date format="%Y"}'}">{cf_statements_order_date format="%Y"}</a></li>

{/exp:query}

Try this:

SELECT DISTINCT FROM_UNIXTIME(field_id_744, '%Y') as 'cf_statements_order_date' FROM exp_channel_data WHERE channel_id = 53 AND field_id_291 = '{user_language}' ORDER BY field_id_744

Hmm. No error, but my list looks like this:

{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}
{cf_statements_order_date format="%Y"}