Omschrijving

SELECT *
FROM d93d5_terms AS t
LEFT JOIN d93d5_term_taxonomy AS tt ON tt.term_id = t.term_id
WHERE tt.taxonomy = ‘nav_menu’;

SELECT tr.*
FROM d93d5_term_relationships AS tr
LEFT JOIN d93d5_posts AS p ON tr.object_id = p.ID
LEFT JOIN d93d5_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE p.post_type = ‘nav_menu_item’
AND tt.term_id = 6;

SELECT p.*
FROM d93d5_posts AS p
LEFT JOIN d93d5_term_relationships AS tr ON tr.object_id = p.ID
LEFT JOIN d93d5_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE p.post_type = ‘nav_menu_item’
AND tt.term_id = 6;

SELECT pm.*
FROM d93d5_postmeta AS pm
LEFT JOIN d93d5_posts AS p ON pm.post_id = p.ID
LEFT JOIN d93d5_term_relationships AS tr ON tr.object_id = p.ID
LEFT JOIN d93d5_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE p.post_type = ‘nav_menu_item’
AND tt.term_id = 6;

Snippet