ERROR: column p.name does not exist LINE 1: ..., p.area_home ASC, p.number_bath ASC, p.cost ASC, p.name DES... ^
AOW - POSTGRESQL query : SELECT p.pid, p.rating, p.cost FROM shop.products_tb AS p WHERE p.deleted=0 AND p.sale=0 AND p.hide=0 AND p.cid=2 AND 1=1 AND 1=1 ORDER BY p.pid ASC, p.rating DESC, p.area_home ASC, p.number_bath ASC, p.cost ASC, p.name DESC, p.number_bed ASC OFFSET 0 LIMIT 10