JetEngine. SQL query to get appointments with service name and service category name. Replace product_cat with your actual taxonomy slug

jet-angine-appointments-query.sql

SELECT app.*, posts.post_title AS service_name, terms.name AS service_category
FROM {prefix}jet_appointments AS app
INNER JOIN {prefix}posts AS posts ON posts.ID = app.service
INNER JOIN {prefix}term_relationships AS terms_rel ON posts.ID = terms_rel.object_id
INNER JOIN {prefix}term_taxonomy AS term_tax ON terms_rel.term_taxonomy_id = term_tax.term_taxonomy_id
INNER JOIN {prefix}terms AS terms ON term_tax.term_id = terms.term_id
WHERE term_tax.taxonomy = 'product_cat'