{exp:query sql="SELECT blog_url, last_entry_date FROM exp_weblogs WHERE weblog_id IN(2,8,1) ORDER BY last_entry_date ASC"} decode_date($LOC->format['DATE_W3C'], $c_date); ?> {blog_url} {/exp:query} {homepage} {exp:query sql="SELECT url_added FROM exp_linklist_urls ORDER BY url_added DESC LIMIT 1"} decode_date($LOC->format['DATE_W3C'], $c_date); ?> http://media-cow.com/links/ {/exp:query} {exp:query sql="SELECT t.entry_id, t.weblog_id, t.title, t.url_title, t.entry_date, t.edit_date, t.recent_comment_date, w.blog_title, w.comment_url FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs AS w ON t.weblog_id = w.weblog_id WHERE t.status='open' AND t.weblog_id IN (1,2,8) ORDER BY t.sticky desc, t.entry_date desc"} timestamp_to_gmt('{edit_date}'); $updated = ($c_date > $e_date) ? $LOC->decode_date($LOC->format['DATE_W3C'], $c_date) : $LOC->decode_date($LOC->format['DATE_W3C'], $e_date); ?> {comment_url}{url_title} {/exp:query}