Hi Kevin, getting Parse error: syntax error, unexpected T_STRING in /data/sites/web/www/system/expressionengine/libraries/Functions.php(680) : eval()‘d code on line 242. Caused by {if "{recent_comment_date format='%Y %m %d'}” == “{current_time format='%Y %m %d'}”} {recent_comment_date format='%g:%i %A'} {/if}
{exp:query limit="200" paginate="bottom" sql="SELECT title, url_title, comment_total, view_count_one, recent_comment_date, allow_comments, name, exp_channel_titles.channel_id FROM exp_channel_titles LEFT JOIN exp_comments ON exp_comments.comment_date = exp_channel_titles.recent_comment_date WHERE exp_channel_titles.channel_id = '{pre_channel_id}' AND exp_comments.channel_id = '{pre_channel_id}' AND comment_total > '0' AND sticky = 'n' AND exp_channel_titles.status = 'open' ORDER BY recent_comment_date DESC"}
{if count == 1}
<div class="entry">
<strong>Updated</strong>
<table class="table">
<tbody>
{/if}
<tr>
<td><a href="http://{path=title={title}">{title} ({comment_total})</a> {if allow_comments == "n"}<span class="text-success"><small>Answered</small></span>{/if}</td>
<td>{comment_total} {if count == "1"}replies{/if}</td>
<td>{view_count_one} {if count == "1"}views{/if}</td>
<td>{name}</td>
<td>
{if "{recent_comment_date format='%Y %m %d'}" == "{current_time format='%Y %m %d'}"} {recent_comment_date format='%g:%i %A'} {/if}
</td>
</tr>
{if count == total_results}
</tbody>
</table>
</div>
{/if}
{paginate}
<div class="navigation">
{if next_page}<a href="http://{auto_path}class=next">Next Page</a>{/if}
</div>
{/paginate}
{/exp:query}FIY, {if "{recent_comment_date format='%Y %m %d'}” == “{current_time format='%Y %m %d'}”} {recent_comment_date format='%g:%i %A'} {/if} works in exp:channel:entries. If I remove it from the exp:query above the query executes OK.