create sql view

This code works in the phpmyAdmin locally and in my webserver too. But while trying to create a custom sql view in phpr v10.8 latest build, It fails with below error.
Any help is highly appreciated.

Full mysql code is:

SELECT customer_id, c.customer_name, SUM(previous_dues.due_amt) AS TotDue, c.customer_type, c.delivery_type,

CASE
WHEN (previous_dues.d1 > 0 AND previous_dues.d2 > 0) || (previous_dues.d2 > 0 AND previous_dues.d3 > 0) || (previous_dues.d3 > 0 AND previous_dues.d1 > 0)
THEN 'HOT-DUE'

WHEN c.customer_type!= 1 AND (previous_dues.d1 > 0 || previous_dues.d2 > 0 || previous_dues.d3 > 0)
THEN 'HOT-DUE'

ELSE '-'
END AS STATUS,

previous_dues.d1, previous_dues.d2, previous_dues.d3, a.area_name, b.branch_name

FROM
(SELECT customer_id, due_amt, FIRST_VALUE(due_amt) over w AS d1, nth_value(due_amt, 2) over w AS d2, nth_value(due_amt, 3) over w AS d3
FROM customer_account ca
window w as (partition by customer_id order by date DESC range between unbounded preceding and UNBOUNDED FOLLOWING)) previous_dues

INNER JOIN customers c ON c.id = previous_dues.customer_id
INNER JOIN areas a ON a.area_id = c.area_id
INNER JOIN branches b ON b.id = a.branch_id

GROUP BY customer_id, previous_dues.d1, previous_dues.d2, previous_dues.d3
HAVING TotDue > 0