code: public function getArticleAlias(Contao\DataContainer $dc)
  	{
  		$arrPids = array();
  		$arrAlias = array();
  
  		if (!$this->User->isAdmin)
  		{
  			foreach ($this->User->pagemounts as $id)
  			{
  				$arrPids[] = array($id);
  				$arrPids[] = $this->Database->getChildRecords($id, 'tl_page');
  			}
  
  			if (!empty($arrPids))
  			{
  				$arrPids = array_merge(...$arrPids);
  			}
  			else
  			{
  				return $arrAlias;
  			}
  
  			$objAlias = $this->Database->prepare("SELECT a.id, a.title, a.inColumn, p.title AS parent FROM tl_article a LEFT JOIN tl_page p ON p.id=a.pid WHERE a.pid IN(". implode(',', array_map('\intval', array_unique($arrPids))) .") ORDER BY parent, a.sorting")
  									   ->execute($dc->id);
  		}
  		else
  		{
  			$objAlias = $this->Database->prepare("SELECT a.id, a.title, a.inColumn, p.title AS parent FROM tl_article a LEFT JOIN tl_page p ON p.id=a.pid ORDER BY parent, a.sorting")
  									   ->execute($dc->id);
  		}
  
  		if ($objAlias->numRows)
  		{
  			Contao\System::loadLanguageFile('tl_article');
  
  			while ($objAlias->next())
  			{
  				$arrAlias[$objAlias->parent][$objAlias->id] = $objAlias->title . ' (' . ($GLOBALS['TL_LANG']['COLS'][$objAlias->inColumn] ?: $objAlias->inColumn) . ', ID ' . $objAlias->id . ')';
  			}
  		}
  
  		return $arrAlias;
  	}
docs: Get all articles and return them as array
  
  @param Contao\DataContainer $dc
  
  @return array