server {
listen 80;
server_name ИМЯ_СЕРВЕРА;
return 301 https://$server_name$request_uri;
}server {
listen 443 ssl;
server_name ИМЯ_СЕРВЕРА;
ssl_certificate /etc/letsencrypt/live/ИМЯ_СЕРВЕРА/fullchain.pem;
ssl_certificate_key /etc/letsencrypt/keys/0008_key-certbot.pem;
ssl_protocols TLSv1 TLSv1.1 TLSV1.2;
access_log /var/log/nginx/ИМЯ_СЕРВЕРА_proxy.log;
location / {
proxy_pass http://192.168.169.4;
}
}
declare @new_rec_id;
set @new_rec_id = select recordId from catalog_49_links
where recordId in (
select recordId from catalog_49_links
where catalogId = 36 and catalogRecordId = 352
order by createdAt desc
limit 1
)
and catalogId = 56 or (catalogId = 36 and catalogRecordId = 352)
order by createdAt desc
limit 1;