Error: Unknown column 'c.avatar' in 'field list'
Error No: 1054
SELECT DISTINCT(bc.blog_comment_id), bc.blog_comment_id as blog_comment_id, bc.blog_id as blog_id, bc.product_id as product_id, bc.parent_blog_comment_id as parent_blog_comment_id, bc.customer_id as customer_id, bc.name as author, bc.email as email, bc.comment as comment, bc.date_added as date_added, bc.status as status, bc.approved as approved, bc.rating as rating, bd.title as blog_title, pd.name as product_title, TRIM(CONCAT(c.firstname, " ", c.lastname)) as customer_name, c.email as customer_email, c.avatar as avatar, c._import_id as _import_id FROM oc_blog_comment bc LEFT JOIN oc_customer c ON (bc.customer_id = c.customer_id) LEFT JOIN oc_blog_description bd ON (bd.blog_id = bc.blog_id) LEFT JOIN oc_blog_to_store b2s ON (b2s.blog_id = bc.blog_id) LEFT JOIN oc_product_description pd ON (pd.product_id = bc.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id = bc.product_id) WHERE (bd.language_id="1" OR bd.language_id IS NULL) AND (pd.language_id="1" OR pd.language_id IS NULL) AND bc.status = "1" AND bc.approved = "1" AND (p2s.store_id = 0 OR b2s.store_id = 0) AND bc.product_id = "36879" ORDER BY bc.date_added ASC