Invalid query: Unknown column 'w' in 'where clause'
Whole query: SELECT *, (SELECT COUNT(comments_id) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_num, (SELECT SUM(comments_rate) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_rate_sum, (SELECT AVG(comments_rate) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_rate_avg, (SELECT SUM(comments_like) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_like_sum FROM product AS p INNER JOIN to_user AS p2u ON p.product_id=p2u.ref_id AND p2u.ref_table="product" INNER JOIN to_view AS p2v ON p.product_id=p2v.ref_id AND p2v.ref_table="product" INNER JOIN product_to_menu AS p2m ON p.product_id = p2m.product_id INNER JOIN product_menu AS pm ON pm.product_menu_id = p2m.product_menu_id LEFT JOIN wbm_user AS u ON p2u.wbm_id=u.wbm_id WHERE p2m.product_menu_id = w AND p.product_languages_id = 2 AND pm.product_menu_languages_id = 2 AND p.product_status = "1" ORDER BY product_order ASC