1054 - Unknown column 'p.equity_affiliated_group_price' in 'having clause'

select distinct p.products_id, pd.products_name, p.products_image, p.products_price_backup, p.timer_sale_flag, p.timer_sale_calendar_check, sum(op.products_quantity) as rank , p.access_status from products_view p, orders o, orders_products op, products_description_view pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '517' in (c.categories_id, c.parent_id) and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '30' group by p.products_id having p.access_status = '0' and (p.access_status != '11' or p.equity_affiliated_group_price > 0) order by rank desc, o.date_purchased desc limit 10

[TEP STOP]