rex_select: alle Kategorien und Article mit article_id hinter dem Namen

rex_select_snippet.php

<?php

// qry: get all cats & articles, label non-start-articles..
$qry = 'SELECT CONCAT (IF(`startpage`,`catname`, CONCAT(`name`, " :: Artikel ::")), " [", `id`, "]"), `id`, `id`, `re_id` 
        FROM `rex_article`
        WHERE `clang`=0
        ORDER BY `startpage` DESC, `catprior`, `prior`';

// rex_select ...
$select->addOption('none','');
$select->addSqlOptions($qry);