Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected function getListQuery() {
- $db = $this->getDbo();
- $type = $this->getState('page.type');
- $query = $db->getQuery(true);
- $query->select("*,a.pageid as pageid");
- $query->from("#__models_pages a");
- $query->where("type = ".$db->quote($type));
- $query->leftJoin("#__models_".$type." b ON a.pageid=b.pageid");
- $query->where("published = 1");
- return $query;
- }
Add Comment
Please, Sign In to add comment