Database error: [MySQL server has gone away]
SELECT cat_ID, cat_name, category_nicename, category_description, category_parent
FROM jobs_categories
WHERE cat_ID > 0
ORDER BY cat_ID asc
Database error: [MySQL server has gone away]
SELECT cat_ID,
COUNT(jobs_post2cat.post_id) AS cat_count
FROM jobs_categories
INNER JOIN jobs_post2cat ON (cat_ID = category_id)
INNER JOIN jobs_posts ON (ID = post_id)
WHERE post_status = 'publish'
GROUP BY category_id