Сортировка товаров в категории

$base_link = ', e.'.($this->diafan->variable_multilang($this->diafan->text_for_base_link["variable"]) ? '['.$this->diafan->text_for_base_link["variable"].']' : $this->diafan->text_for_base_link["variable"]);
}
$config_other_row = '';
if($this->diafan->config_other_row)
{
foreach($this->diafan->config_other_row as $r => $type)
{
// не добавляем в список полей переменные, выбираемые всегда
if(in_array($r, array('id')))
continue;
$config_other_row .= ', e.'.($this->diafan->variable_multilang($r) ? '['.$r.']' : $r);
}
}
if($this->diafan->fast_edit_rows)
{
foreach($this->diafan->fast_edit_rows as $r => $type)
{
if($type != 'function')
{
$config_other_row .= ', e.'.($this->diafan->variable_multilang($r) ? '['.$r.']' : $r);
}
}
}

return DB::query("SELECT e.id"
.$base_link
.$config_other_row
.($this->diafan->config("act") ? ', e.act'.$this->lang_act.' AS act' : '' )
.($this->diafan->config("parent") ? ', e.parent_id, e.count_children' : '' )
.($this->diafan->is_variable("date_start") ? ', e.date_start' : '' )
.($this->diafan->is_variable("date_finish") ? ', e.date_finish' : '' )
.($this->diafan->config("date") || $this->diafan->config("datetime") ? ', e.created' : '' )
.($this->diafan->config("view") ? ', e.module_name, e.block' : '' )
.($this->diafan->config("element_site") ? ', e.site_id' : '' )
.($this->diafan->config("element_multiple") ? ', e.cat_id' : '' )
.($this->diafan->config("order") ? ', e.sort' : '' )." FROM {".$this->diafan->table."} as e"
.($this->diafan->config("element_multiple") && $this->diafan->cat ?
" INNER JOIN {".$this->diafan->table."_category_rel} AS c ON e.id=c.element_id" .
" AND e.id=c.element_id AND c.cat_id='".$this->diafan->cat."'" : '' )
. " WHERE 1=1"
.($this->diafan->config("parent") ? " AND e.parent_id='".$id."'" : '' )
.($this->diafan->config("element") && !$this->diafan->config("element_multiple") && $this->diafan->cat ?
" AND e.cat_id='".$this->diafan->cat."'" : '' )
.($this->diafan->config("element_site") && $this->diafan->site ?
" AND e.site_id='".$this->diafan->site."'" : '' ).( $this->diafan->where ? " ".$this->diafan->where : '' )
.($this->diafan->config("trash") ? " AND e.trash='0'" : '' )
.($this->diafan->config("element_multiple") && $this->diafan->cat ? " GROUP BY e.id" : '' )
." ORDER BY "
.($this->diafan->config("prior") ? 'e.prior DESC, ' : '' )
.($this->diafan->config("date") || $this->diafan->config("datetime") ? 'e.created DESC, ' : '' )
.($this->diafan->config("act") ? 'e.act'.$this->lang_act.' DESC, ' : '' )
.($this->diafan->table == 'site' ? " e.is_menu DESC, e.block ASC, " : '' )
.($this->diafan->config("order") ? 'e.sort ASC, e.id ASC' : 'e.id DESC' )
.' LIMIT '.$this->polog.', '.$this->diafan->nastr);
}