sql call error:SELECT `w-prod_id` , `translate`.`tr_content` AS `name_trans` , IFNULL(SUM(`W_stock`.`a-stock_pieces`),0) AS `SUMstock` FROM `W_products` LEFT JOIN `A_languages_translate` AS `translate` ON `W_products`.`a-prod_name` = `translate`.`tr_gen_id` LEFT JOIN `W_stock` ON `W_products`.`w-prod_id` = `W_stock`.`a-stock_product_id` WHERE 1 AND (`a-prod_ctg_id` REGEXP '(^|,)270(,|$)' OR `w-prod_ctg_parents` REGEXP '(^|,)270(,|$)') AND `tr_lang` = 'HUN' AND ( `a-prod_users` IS NULL OR `a-prod_users` LIKE '%--%' ) AND `a-prod_stage` = 'active' GROUP BY `w-prod_id`
ERROR: Unknown column 'a-prod_users' in 'where clause'

hiba: DB query error

Unknown column 'a-prod_users' in 'where clause'

SELECT `w-prod_id` , `translate`.`tr_content` AS `name_trans` , IFNULL(SUM(`W_stock`.`a-stock_pieces`),0) AS `SUMstock` FROM `W_products` LEFT JOIN `A_languages_translate` AS `translate` ON `W_products`.`a-prod_name` = `translate`.`tr_gen_id` LEFT JOIN `W_stock` ON `W_products`.`w-prod_id` = `W_stock`.`a-stock_product_id` WHERE 1 AND (`a-prod_ctg_id` REGEXP '(^|,)270(,|$)' OR `w-prod_ctg_parents` REGEXP '(^|,)270(,|$)') AND `tr_lang` = 'HUN' AND ( `a-prod_users` IS NULL OR `a-prod_users` LIKE '%--%' ) AND `a-prod_stage` = 'active' GROUP BY `w-prod_id`