SQL: SELECT distinct t.name, tt.term_id FROM kas_wp_terms AS t INNER JOIN kas_wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kas_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN kas_wp_posts p ON tr.object_id=p.id AND p.post_status='publish' WHERE `tt`.taxonomy='category' AND tt.parent =0

SQL: SELECT distinct t.name, tt.term_id FROM kas_wp_terms AS t INNER JOIN kas_wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kas_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN kas_wp_posts p ON tr.object_id=p.id AND p.post_status='publish' WHERE `tt`.taxonomy='post_tag' AND tt.parent =0