====== Unterschiede ====== Hier werden die Unterschiede zwischen zwei Versionen gezeigt.
| — |
select_mit_joins [2020/01/27 10:37] (aktuell) jonas angelegt |
||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| + | ====== Select mit Joins und Alias ====== | ||
| + | <code php> | ||
| + | $info_new = InfoContents::find() | ||
| + | ->alias('content') | ||
| + | ->joinwith('category cat') | ||
| + | ->where(['cat.project_id' => $this->project_id]) | ||
| + | ->orderBy(['content.created_at' => SORT_DESC]) | ||
| + | ->limit(5) | ||
| + | ->all(); | ||
| + | </code> | ||