A fatal MySQL error occurred.

Query:
SELECT pmd_menu_links.*, IF(pmd_menu_links.page_id != 0, IF(1, CONCAT('http://www.discountweaver.com/listings/pages/',friendly_url,'.html'), CONCAT('http://www.discountweaver.com/listings/page.php?id=',pmd_pages.id) ), IF(INSTR(link,'://'), link, CONCAT('http://www.discountweaver.com/listings/',link) ) ) as url, target FROM pmd_menu_links LEFT JOIN pmd_pages ON pmd_menu_links.page_id=pmd_pages.id WHERE parent_id=0 AND active=1 AND logged_out=1 ORDER BY ordering

Error:
(1052) Column 'active' in where clause is ambiguous