include $path.'/includes/404.php';
}

if(!isset($_GET['cat_id'])) {

if (! $this->diafan->_site->title_no_show)
{
if ($this->diafan->_site->titlemodule)
{
$name = $this->diafan->_site->titlemodule;
if ($this->diafan->_site->edit_meta)
{
$name = $this->diafan->_useradmin->get($name, 'name', $this->diafan->_site->edit_meta["id"], $this->diafan->_site->edit_meta["table"], _LANG);
}
}
else
{
$name = $this->diafan->_useradmin->get($this->diafan->_site->name, 'name', $this->diafan->_site->id, 'site', _LANG);
}
//echo $name;
} else {
$name = $this->diafan->_site->titlemodule;
}
$var = $this->diafan->_tpl->htmleditor('<insert name="show_dynamic" module="site" id="2">');
if ($var) {
$name = $var;
}

echo $name;
}

break;
case 3:
$order = 's.name'._LANG.' ASC';
break;
default:
$order = 's.sort DESC, s.id DESC';
}
if(! $this->diafan->configmodules('hide_missing_goods') && $this->diafan->configmodules('use_count_goods'))
{
$order = "isset_count_goods DESC,".$order;
}
$rows = DB::query_range_fetch_all(
"SELECT s.id, s.[name], s.timeedit, s.[anons], s.site_id, s.brand_id, s.no_buy, s.article, s.[measure_unit], s.is_file"
.(! $this->diafan->configmodules('hide_missing_goods') && $this->diafan->configmodules('use_count_goods') ? ", (prhc.good_id<>0) AS isset_count_goods" : "")
." FROM {shop} AS s"
.($this->diafan->_route->sort == 1 || $this->diafan->_route->sort == 2 ?
" LEFT JOIN {shop_price} AS pr ON pr.good_id=s.id AND pr.trash='0'"
." AND pr.date_start<=".time()." AND (pr.date_finish=0 OR pr.date_finish>=".time().")"
." AND pr.currency_id=0"
." AND pr.role_id".($this->diafan->_users->role_id ? " IN (0,".$this->diafan->_users->role_id.")" : "=0")
." AND (pr.person='0'".($this->person_discount_ids ? " OR pr.discount_id IN(".implode(",", $this->person_discount_ids).")" : "").")"
: '')
." INNER JOIN {shop_param_element} as e ON e.element_id=s.id"
.($this->diafan->configmodules('where_access_element') ? " LEFT JOIN {access} AS a ON a.element_id=s.id AND a.module_name='shop' AND a.element_type='element'" : "")
.($this->diafan->configmodules('hide_missing_goods') && $this->diafan->configmodules('use_count_goods') ? " INNER JOIN {shop_price} AS prh ON prh.good_id=s.id AND prh.count_goods>0" : "")
.(! $this->diafan->configmodules('hide_missing_goods') && $this->diafan->configmodules('use_count_goods') ? " LEFT JOIN {shop_price} AS prhc ON prhc.good_id=s.id AND prhc.count_goods>0" : "")
. ($this->sort_config['use_params_for_sort'] ? " LEFT JOIN {shop_param_element} AS sp ON sp.element_id=s.id AND sp.trash='0'"
." AND sp.param_id=".$this->sort_config['param_ids'][$this->diafan->_route->sort] : '')
." WHERE s.[act]='1' AND s.trash='0' AND e.param_id=%d AND e.value".$this->diafan->_languages->site."=%d"
.($this->diafan->configmodules('where_period_element') ? " AND s.date_start<=".$time." AND (s.date_finish=0 OR s.date_finish>=".$time.")" : '')
.($this->diafan->configmodules('where_access_element') ? " AND (s.access='0' OR s.access='1' AND a.role_id=".$this->diafan->_users->role_id.")" : '')
.($this->diafan->configmodules('hide_missing_goods') ? " AND s.no_buy='0'" : "")
." GROUP BY s.id"
." ORDER BY ".($this->diafan->_route->sort ? $this->sort_config['sort_directions'][$this->diafan->_route->sort].',' : '')
." s.no_buy ASC, ".$order,
$param_id, $this->diafan->_route->param,
$this->diafan->_paginator->polog, $this->diafan->_paginator->nastr);
return $rows;
}