public static function getComment($id)
{
return (array) BackendModel::getContainer()->get('database')->getRecord('SELECT i.*, UNIX_TIMESTAMP(i.created_on) AS created_on,
p.id AS post_id, p.title AS post_title, m.url AS post_url
FROM blog_comments AS i
INNER JOIN blog_posts AS p ON i.post_id = p.id AND i.language = p.language
INNER JOIN meta AS m ON p.meta_id = m.id
WHERE i.id = ? AND p.status = ?
LIMIT 1', array((int) $id, 'active'));
}