Сайт временно не работает q("select str_id from company where reg_code='".$Reg_code."' limit 1;"); if($biz_data = $res->fetch()) { $url = $RootPath."filtered_review/".$biz_data["str_id"]; header("HTTP/1.1 301 Moved Permanently"); header("Location: $url"); exit; } else { redirect($RootPath."404.php"); exit; } } $res = $db->q("select id, name, alter_name, address_1, reg_code, (select name from city where id=company.city_id) as city_name, (select count(*) from review where company_id=company.id and posted=1 and filtered=1) as review_count from company where str_id='".$str_id."' limit 1;"); if(!($biz_data = $res->fetch())) { redirect($RootPath."404.php"); exit; } $SQLSelect_pre = "select user.reg_code as user_reg_code, CONCAT(user.first_name,' ', left(user.last_name,1),'.') as first_name, company.name as company_name, user.headline, review.date_post, review.user_id, review.filtered, DATE_FORMAT(review.date_post, '%d.%m.%Y') as date_post, review.review_text, review.mark as mark, review.id as id, review.review_id, review.answer_exists, (select img from image where table_name='User' and rec_id=user.id and main=1 limit 1) as img_path, user.gender, user.friend_count, user.review_count, (select city.name from city, user_location where user_location.user_id = user.id and user_location.main=1 and user_location.city_id=city.id) as city_name "; $SQLSelect = "from review, user, company where review.company_id=".$biz_data["id"]." and review.posted=1 and review.filtered=1 and company.id=review.company_id and user.id=review.user_id "; $SQLSelect_order = "order by review.id desc limit ".$Pagestart.",10;"; //$SQLSelect_post = "limit $Pagestart,10;"; //Для заголовка страницы > $meta_title .= htmlspecialchars($biz_data["name"]).", ".$biz_data["city_name"]." - отфильтрованные отзывы"; $meta_description = $biz_data["review_count"]." отфильтрованных отзывов о ".htmlspecialchars($biz_data["name"]); $meta_keywords = ""; //Для заголовка страницы < $js_arr[0]["type"] = "file"; $js_arr[0]["data"] = $l->root."js/wi_dialog_new.js"; if($_SESSION["permission_id"] >= 5) { $js_arr[1]["type"] = "file"; $js_arr[1]["data"] = $l->root."js/admin_func.js"; } require($DocRoot."header_post3.php"); ?>