Notice: Error: Unknown column 'ms.zone_id' in 'field list'Error No: 1054SELECT SQL_CALC_FOUND_ROWS CONCAT(c.firstname, ' ', c.lastname) as 'c.name', c.email as 'c.email', ms.seller_id as 'seller_id', ms.nickname as 'ms.nickname', ms.company as 'ms.company', ms.website as 'ms.website', ms.seller_status as 'ms.seller_status', ms.seller_approved as 'ms.seller_approved', ms.date_created as 'ms.date_created', ms.avatar as 'ms.avatar', ms.country_id as 'ms.country_id', ms.zone_id as 'ms.zone_id', ms.description as 'ms.description', ms.paypal as 'ms.paypal', IFNULL(SUM(mp.number_sold), 0) as 'total_sales' FROM `oc_customer` c INNER JOIN `oc_ms_seller` ms ON (c.customer_id = ms.seller_id) LEFT JOIN `oc_ms_product` mp ON (c.customer_id = mp.seller_id) WHERE 1 = 1 GROUP BY ms.seller_id HAVING 1 = 1 ORDER BY ms.nickname ASC in /home/v/progress/progresstyt.ru/public_html/system/database/mysql.php on line 50