public function __construct()
{
parent::__construct();
$this->pinups_table = 'pinups as p';
$this->groups_table = 'pinups_groups as g';
$this->fields = array('pinups' => array('id' => 'p.id as pinup_id', 'title' => 'p.title', 'filename' => 'p.filename', 'size' => 'p.size', 'created_on' => 'p.created_on as pinup_creation', 'modified_on' => 'p.modified_on as pinup_modified', 'storage_type' => 'p.storage_type', 'path_to_file' => 'p.path_to_file', 'original_name' => 'p.original_name', 'mime_type' => 'p.mime_type', 'ext' => 'p.ext as file_ext', 'file_size' => 'p.file_size', 'original_width' => 'p.original_width', 'original_height' => 'p.original_height', 'image_type' => 'p.image_type', 'group_id' => 'p.group_id pinup_group_id', 'thumbnail' => 'p.thumbnail'), 'pinups_groups' => array('id' => 'g.id as group_id', 'group' => 'g.group', 'parent' => 'g.parent as group_parent', 'stub' => 'g.stub as group_stub', 'created_on' => 'g.created_on as group_creation', 'modified_on' => 'g.modified_on as group_modified'));
$this->order_by = array('fields' => 'p.created_on', 'direction' => 'desc');
}
public function __construct()
{
parent::__construct();
}