MySQL query for taxonomy-meta

Question

I am working directly with MySQL, using MySQL workbench. Can you help me write a SQL query that will pull all custom taxonomies and their term-meta fields?

I have a custom taxonomy called(slug) census-tract

and a few custom fields attached to each:

census-tract-income-level census-tract-population

How would I go about joining the following tables

wp_terms
wp_termmeta
wp_term_taxonomy

to find WHERE wp_termmeta.meta_key = 'census-tract-population' AND wp_termmeta.meta_key = 'census-tract-income-level' ?

Thanks!!

0
, , , italiansoda 4 years 2020-05-13T10:10:20-05:00 0 Answers 88 views 0

Leave an answer

Browse
Browse