=== ref ARTICLE_CAT ===
  NEWS            Berita                News                  sort=1   parent=NULL
  ANNOUNCEMENT    Pengumuman            Announcement          sort=2   parent=NULL
  ARTICLE         Artikel               Article               sort=3   parent=NULL
  BLOG            Blog                  Blog                  sort=4   parent=NULL
  PRESS           Siaran Akhbar         Press Release         sort=5   parent=NULL
  FAQ             Soalan Lazim          FAQ                   sort=6   parent=NULL

=== ref ARTICLE_SUBCAT ===
  GENERAL         Umum                  General               sort=1   parent=NEWS
  SPORTS          Sukan                 Sports                sort=2   parent=NEWS
  TECHNOLOGY      Teknologi             Technology            sort=3   parent=NEWS
  BUSINESS        Perniagaan            Business              sort=4   parent=NEWS
  OPINION         Pendapat              Opinion               sort=5   parent=ARTICLE
  FEATURE         Ciri                  Feature               sort=6   parent=ARTICLE
  NOTICE          Notis                 Notice                sort=7   parent=ANNOUNCEMENT
  CIRCULAR        Pekeliling            Circular              sort=8   parent=ANNOUNCEMENT
  TRAVEL          Travel                Travel                sort=9   parent=BLOG
  LIFESTYLE       Gaya Hidup            Lifestyle             sort=10  parent=BLOG
  CORPORATE       Korporat              Corporate             sort=11  parent=PRESS
  EVENT           Acara                 Event                 sort=12  parent=PRESS
  FAQ             Soalan Lazim          FAQ                   sort=90  parent=FAQ

=== artikel FAQ dalam DB ===
  #7   faq-bidang-kuasa      cat=FAQ         subcat=FAQ       status=ACTIVE
  #9   faq-lokasi            cat=FAQ         subcat=FAQ       status=ACTIVE
  #10  faq-aduan             cat=FAQ         subcat=FAQ       status=ACTIVE
  #11  faq-direktori         cat=FAQ         subcat=FAQ       status=ACTIVE
  #12  faq-penerbitan        cat=FAQ         subcat=FAQ       status=ACTIVE
  #13  faq-tender            cat=FAQ         subcat=FAQ       status=ACTIVE
  #14  faq-media             cat=FAQ         subcat=FAQ       status=ACTIVE

=== kiraan kategori artikel keseluruhan ===
  ARTICLE       (null)        1
  FAQ           (null)        1
  FAQ           FAQ           7
  NEWS          Alam Sekitar  1
  NEWS          Biodiversiti  1
  NEWS          GENERAL       3
  NEWS          Geospatial    1
  NEWS          Perhutanan    1
  NEWS          Umum          1

=== tapisan dalam page #36 (article) — query hub ===
  13   Sumber data: content_article + content_article_translation
  51   $artGroups = [
  55   $artGroupLabel = function ($subCode, $catCode) use ($artGroups, $artSubLabel, $artCatLabel, $artLang) {
  59   if (isset($artGroups[$subCode])) {
  60   return $artGroups[$subCode][$artLang];
  65   return $artGroups['CORPORATE'][$artLang];
  125  DB::table('content_article')
  128  ->where('article_category', '!=', 'FAQ')
  132  $artTrRows = DB::table('content_article_translation')
  149  DB::table('content_article')->whereIn('article_status', ['ACTIVE', 'PUBLISHED'])
  150  ->where('article_category', '!=', 'FAQ')
  160  ? DB::table('content_article_translation')
  182  'cat'     => (string) ($artRow->article_category ?? ''),
  183  'sub'     => (string) ($artRow->article_subcategory ?? ''),
  184  'group'   => $artGroupLabel($artRow->article_subcategory, $artRow->article_category),
  191  $artGroupCode  = $artFound ? (string) $artArticle->article_subcategory : '';
  199  $artHubItems = array_values(array_filter($artItems, fn ($i) => $i['sub'] === 'CORPORATE'));
  201  if (! $artHubItems) {
  202  $artHubItems = $artItems;
  211  $artGroupLabelText = $artFound ? $artGroupLabel($artArticle->article_subcategory, $artArticle->article_category) : '';
  212  $artSubLabelText   = $artFound ? ($artSubLabel[(string) $artArticle->article_subcategory] ?? '') : '';
  213  $artCatLabelText   = $artFound ? ($artCatLabel[(string) $artArticle->article_category] ?? '') : '';
  412  @if (count($artHubItems) > 0)
  414  @foreach ($artHubItems as $artItem)

=== tapisan dalam page #39 (faq) ===
  6    Sumber data: `content_article` (article_subcategory = FAQ, status ACTIVE)
  7    + `content_article_translation` (BM/EN)
  19   $faqRows = DB::table('content_article as a')
  20   ->join('content_article_translation as t', 't.article_translation_parent_id', '=', 'a.article_id')
  22   $q->where('a.article_subcategory', 'FAQ')->orWhere('a.article_category', 'FAQ');