SELECT term.id,term.slug,term.title,term.name,term.description,term.image,term.sort,term.active,taxonomy.id AS taxonomy_id FROM term JOIN taxonomy ON taxonomy.term_id = term.id JOIN vocabulary ON vocabulary.id = taxonomy.vocabulary_id WHERE term.active = 1 AND vocabulary.slug = 'category' ORDER BY term.sort, term.name, term.slug
Location: App\Controller\Component\Autorun->menuTaxonomy()