select B.*
from (SELECT A.*,
@prev as before_prev,
@rn as before_rn,
IF(@prev <> A.chat_id, @rn:=1,@rn), @prev:= A.chat_id, @rn:=@rn+1 AS rn,
@prev as after_prev,
@rn as after_rn
from (
SELECT
`class_messages`.`id` as mess_id,
`class_messages`.`chat_message`,
`class_messages_chat`.`to_user_id`,
`class_messages_chat`.`from_user_id`,
`class_users`.`id`,
`class_users`.`user_status`,
`class_users`.`online`,
`class_messages_chat`.`chat_id`,
`class_messages_chat`.`ad_id`,
`class_ads`.user_id,
`class_ads`.title
FROM `class_messages_chat`
inner join `class_ads` on `class_messages_chat`.ad_id = `class_ads`.id
INNER JOIN `class_users` ON `class_users`.`id`=`class_ads`.`user_id`
inner join `class_messages` on `class_messages_chat`.`chat_id` = `class_messages`.`chat_id`
WHERE ( `class_messages`.`to_user_id` = 133337
or `class_messages`.`from_user_id` = 133337)
and class_messages_chat.chat_id
order by class_messages.id desc
) A,
(SELECT @rn:=1)rn,
(SELECT @prev:=-1)prev
) B#1064 - У вас ошибка в запросе. Изучите документацию по используемой версии MySQL на предмет корректного синтаксиса около '(partition by `class_messages_chat`.`chat_id` order by class_messages.id desc) r' на строке 13#1064 - У вас ошибка в запросе. Изучите документацию по используемой версии MySQL на предмет корректного синтаксиса около '(
SELECT
`class_messages_chat`.`to_user_id`,
`class_messages_cha' на строке 4(
SELECT
`class_messages_chat`.`to_user_id`,select * from `class_fields` LEFT JOIN `class_fields_lang` on `class_fields`.`id` = `class_fields_lang`.`id` where `lang_id` = 'ru' and `active` = 1 and `quick_search` = 1 and ( `fieldset` REGEXP '\\b103,105,107\\b' or `fieldset` = 0 ) order by `order_no`;# city subdomain
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) list.php?crt_city=%2 [NC,QSA]
# https://city.site.com/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^user/$ st.php?crt_dealer=%1 [L,QSA]if(isset($_GET['crt_city']) && $_GET['crt_city'] && !$city) {
global $config_live_site;
header("Location:"."https://".$crt_city.".site.com"."/user/"); exit(0);
}# city subdomain
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) list.php?crt_city=%2 [NC,QSA]# https://city.site.com/search/
#RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
#RewriteRule ^$ list.php?crt_city=%1 [L,QSA]# https://city.site.com/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^$ st.php?crt_dealer=%1 [L,QSA]# https://city.site.com/search/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^search/$ list.php?crt_city=%1 [L,QSA]# subdomain
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) st.php?crt_dealer=%2 [nc,qsa]
# subdomain 2
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) list.php?crt_city=%2 [NC,QSA]RewriteRule ^search/?$ list.php [nc,qsa]
RewriteRule ^search/([^/]+)(?:/?([^/]*)/?([^/]*)/?)? /list.php?category_slug=$1&oblast_slug=$2®ion_slug=$3 [L,QSA]
RewriteCond %{REQUEST_URI} ^(.*)(/list.html)(.*)$ [NC]
RewriteCond %{SCRIPT_FILENAME} !-f
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteRule (.*) ./list.php?$1 [QSA]# https://city.site.com/search/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^search/$ list.php?crt_city=%1 [L,QSA]
`class_messages_chat`.`to_user_id` =133337 или `class_messages_chat`.`from_user_id` = 133337, нашел эти chat_id в таблице class_messages и выдал последние записи, понятно, что там еще несколько таблиц участвует, но по ним группировок нет, сама суть именно в последних chat_id, но это видимо крайне сложно решить, хотя выглядит просто