Notice: Error: Unknown column 'p.image' in 'field list'
Error No: 1054
SELECT
p.post_id,
p.image,
p.date_created as date,
pd.name,
pd.description,
a.username,
a.firstname,
a.lastname,
(
SELECT count(*)
FROM `oc_journal2_blog_comments` bc
WHERE bc.post_id = p.post_id AND bc.status = 1 AND bc.parent_id = 0
) as comments
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE pd.language_id = 2
AND p.status = 1 GROUP BY p.post_id ORDER BY p.date_created DESC LIMIT 0,8 in /home/ftfhk/domains/ftf.hk/public_html/system/database/mysql.php on line 50