Database error: Invalid SQL:
SELECT p.*, p_d.numsup, COUNT(a.absnum) AS articles_count
FROM pages p, pages_desc p_d
LEFT OUTER JOIN articles a ON a.parent_page = p.absnum AND a.langid = 2
WHERE p_d.absnum = p.absnum AND p_d.numsup >=0 AND p.langid = 2
GROUP BY p.absnum
ORDER BY p.absnum
MySQL Error: 1054 (Unknown column 'p.absnum' in 'on clause')
Session halted.