Guest User

Untitled

a guest
Jun 22nd, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. protected function getListQuery() {
  2. $db = $this->getDbo();
  3. $type = $this->getState('page.type');
  4. $query = $db->getQuery(true);
  5. $query->select("*,a.pageid as pageid");
  6. $query->from("#__models_pages a");
  7. $query->where("type = ".$db->quote($type));
  8. $query->leftJoin("#__models_".$type." b ON a.pageid=b.pageid");
  9. $query->where("published = 1");
  10. return $query;
  11. }
Add Comment
Please, Sign In to add comment