get taxonomy term using sql query
-
I am having Multilingual site having English and a Hebrew site
I am retriving Taxonomy term using this query
SELECT DISTINCT wt.term_id , wt.name FROM wp_terms wt INNER JOIN wp_term_taxonomy wtt ON(wt.term_id = wtt.term_id) INNER JOIN wp_term_relationships pll_tr ON (pll_tr.term_taxonomy_id = wtt.term_taxonomy_id) where wtt.taxonomy=\’listing_category\’ AND (wt.name LIKE \’%’.$search_term.’%\’ OR wtt.description LIKE \’%’.$search_term.’%\’)’I am only getting English terms how to combine it with polylang to get Hebrew terms on Hebrew site .There is no entry in wp_termmeta. Pls help
-
I have followed the link and also used name But when i run this qry and code , it gives error .
$qry =’SELECT DISTINCT wt.term_id , wt.name FROM wp_terms wt INNER JOIN wp_term_taxonomy wtt ON(wt.term_id = wtt.term_id) INNER JOIN wp_term_relationships pll_tr ON (pll_tr.term_taxonomy_id = wtt.term_taxonomy_id) where wtt.taxonomy=\’listing_category\” ;
$txnterms_listing = $wpdb->get_results($qry, OBJECT);
foreach ($txnterms_listing as $t) {
if(pll_get_term_language($t->term_id) == pll_current_language()):
The topic ‘get taxonomy term using sql query’ is closed to new replies.
