server {
listen 80;
listen 443 ssl;
server_name www.test.ru test.ru;
# Load configuration files for the default server block.
# include /etc/nginx/default.d/*.conf;
ssl_certificate /etc/letsencrypt/live/test.ru/fullchain.pem;
ssl_certificate_key /etc/letsencrypt/live/test.ru/privkey.pem;
ssl_trusted_certificate /etc/letsencrypt/live/test.ru/fullchain.pem;
location / {
proxy_pass http://localhost:3333;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection 'upgrade';
proxy_set_header Host $host;
proxy_cache_bypass $http_upgrade;
}
error_page 404 /404.html;
location = /40x.html {
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
}
}$query = $db->getQuery(true);
$query->select('a.virtuemart_product_id, a.product_name, a.product_desc, a.slug as sluggy, p.product_price, c.virtuemart_category_id, cn.slug, m.virtuemart_media_id, ms.file_url')
->from('#__virtuemart_products_ru_ru as a');
$query->join('LEFT', '#__virtuemart_product_prices AS p ON p.virtuemart_product_id = a.virtuemart_product_id');
$query->join('LEFT', '#__virtuemart_product_categories AS c ON c.virtuemart_product_id = a.virtuemart_product_id');
$query->join('LEFT', '#__virtuemart_categories_ru_ru AS cn ON cn.virtuemart_category_id = c.virtuemart_category_id');
$query->join('LEFT', '#__virtuemart_product_medias AS m ON m.virtuemart_product_id = a.virtuemart_product_id');
$query->join('LEFT', '#__virtuemart_medias AS ms ON ms.virtuemart_media_id = m.virtuemart_media_id');
$query->setLimit('1');
$db->setQuery($query);
хз походу дело не в бабине