WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN
wp_links ON link_category = cat_id
WHERE
link_visible = 'Y' at line 5]
SELECT
cat_id, cat_name, COUNT( link_id ) as num_links
FROM
INNER JOIN
wp_links ON link_category = cat_id
WHERE
link_visible = 'Y'
GROUP BY
cat_id
HAVING
num_links > 0
ORDER BY
cat_name
Comments