-===
Working – Get Term Meta data of current user Brand Group
SELECT * FROM wp_jet_rel_114 as m1
INNER JOIN
wp_termmeta AS m2
ON
m2.term_id = m1.parent_object_id WHERE m1.child_object_id=%current_user_id%
-===
SELECT * FROM wp_jet_rel_114 as m1
INNER JOIN
wp_termmeta AS m2
ON
m2.term_id = m1.parent_object_id WHERE m1.child_object_id=%current_user_id% AND m2.meta_key=’_related_brand’
-===
Query to get Brand ID of current user Brand Group
SELECT m2.meta_value as brand_id FROM wp_jet_rel_114 as m1
INNER JOIN
wp_termmeta AS m2
ON
m2.term_id = m1.parent_object_id WHERE m1.child_object_id=%current_user_id% AND m2.meta_key=’_related_brand’
Get all Brands
-===
SELECT SUBSTRING_INDEX(meta_value,’;’,1) FROM wp_termmeta WHERE term_id=64 and meta_key=’_is-sub-group-of’
SELECT SUBSTRING_INDEX(meta_value,’:’,1) FROM wp_termmeta WHERE term_id=64 and meta_key=’_is-sub-group-of’
SELECT meta_value as parent FROM wp_termmeta WHERE term_id=64 and meta_key=’_is-sub-group-of’
=> a:1:{i:0;s:2:”65″;}
SUBSTRING_INDEX(meta_value,’:’,-1)
SUBSTRING_INDEX (meta_value,’;’,1)
===
Working – But it works only for single selection, if there are two parent Department, it doesn’t work
SELECT SUBSTRING_INDEX (SUBSTRING_INDEX(meta_value,’:’,-1),’;’,1) as parent FROM wp_termmeta WHERE term_id=64 and meta_key=’_is-sub-group-of’
-==
SELECT * FROM wp_jet_rel_114 WHERE child_object_id=4
Array
(
[0] => stdClass Object
(
[_ID] => 2
[created] => 2024-06-06 03:06:45
[rel_id] => 114
[parent_rel] => 0
[parent_object_id] => 65
[child_object_id] => 4
[sql_query_item_id] => 210-0
)
–==
SELECT * FROM wp_terms WHERE term_id=65
Array
(
[0] => stdClass Object
(
[term_id] => 65
[name] => Office A
[slug] => office-a
[term_group] => 0
[sql_query_item_id] => 210-0
)
)
-===
SELECT * FROM wp_termmeta WHERE term_id=65
Results Count: 5
SELECT * FROM wp_termmeta WHERE term_id=65
Array
(
[0] => stdClass Object
(
[meta_id] => 32
[term_id] => 65
[meta_key] => _related_brand
[meta_value] => 436
[sql_query_item_id] => 210-0
)
[1] => stdClass Object
(
[meta_id] => 33
[term_id] => 65
[meta_key] => _group-type
[meta_value] => 2
[sql_query_item_id] => 210-1
)
[2] => stdClass Object
(
[meta_id] => 35
[term_id] => 65
[meta_key] => _related-sub-groups
[meta_value] => a:2:{i:0;s:2:”64″;i:1;s:2:”71″;}
[sql_query_item_id] => 210-2
)
[3] => stdClass Object
(
[meta_id] => 36
[term_id] => 65
[meta_key] => _is-sub-group-of
[meta_value] =>
[sql_query_item_id] => 210-3
)
[4] => stdClass Object
(
[meta_id] => 70
[term_id] => 65
[meta_key] => _children-users
[meta_value] =>
[sql_query_item_id] => 210-4
)
)
-==
SELECT * FROM wp_termmeta WHERE term_id=64 and meta_key=’_is-sub-group-of’
Array
(
[0] => stdClass Object
(
[meta_id] => 34
[term_id] => 64
[meta_key] => _is-sub-group-of
[meta_value] => a:1:{i:0;s:2:”65″;}
[sql_query_item_id] => 210-0
)
)
-==
SELECT * from wp_term_relationships
SELECT * from wp_term_relationships
Array
(
[0] => stdClass Object
(
[object_id] => 1
[term_taxonomy_id] => 1
[term_order] => 0
[sql_query_item_id] => 210-0
)
-==
SELECT * from wp_term_taxonomy where taxonomy=’Brand Group’
INNER JOIN
wp_terms AS m2
ON
m2.term_id = m1.term_id
-==
SELECT * FROM wp_jet_rel_114
SELECT * FROM wp_jet_rel_114 WHERE child_object_id=%current_user_id%
SELECT * FROM wp_jet_rel_114 as m1
INNER JOIN
wp_jet_taxonomies AS m2
ON
m2.id = m1.parent_object_id WHERE m1.child_object_id=%current_user_id%
-===
SELECT id from wp_jet_taxonomies as brandgroup
inner join wp_users as m2 on m2.id = where slug=’brand-group’
SELECT * from wp_jet_taxonomies where slug=’brand-group’
select * from wp_jet_rel_114
INNER JOIN
wp_wsal_metadata AS wsal_metadata
ON
wsal_occurrences.id = wsal_metadata.occurrence_id
jet_rel_114
SELECT “Actions” as type , _ID, post_id as ppost_id, cct_created, user_agent, user_ip, user_initials, user_id as uuser_id, user_roles, cct_author_id, post_type as ppost_type, changes, post_status as ppost_status FROM wp_jet_cct_user_actions
WHERE user_id LIKE IF( ‘%jsf_filter_query|query_var|uuser_id||%’ > ”, ‘%jsf_filter_query|query_var|uuser_id||%’, ‘%’ )
UNION
SELECT “Views” as type, _ID, post_id as ppost_id, cct_created, user_agent, user_ip, user_initials,user_id as uuser_id, user_roles, cct_author_id, post_type as ppost_type , null, post_status as ppost_status FROM wp_jet_cct_client_page_views
WHERE post_id=’%current_id%’
AND user_id LIKE IF( ‘%jsf_filter_query|query_var|uuser_id||%’ > ”, ‘%jsf_filter_query|query_var|uuser_id||%’, ‘%’ )
ORDER BY cct_created DESC