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