SELECT l.contract,l.subs,p.period_name,SUM(nach)
FROM (SELECT contract,subs FROM allVp GROUP BY contract,subs) l
CROSS JOIN billing_period p
LEFT JOIN allVp v ON l.subs=v.subs AND l.contract=v.contract AND p.id=v.period
GROUP BY l.contr,l.subs,p.period_name;
map $host $newroot {
hostnames;
default /home/notfound/www/;
.mysite.ru /home/user1/mysite.ru/www/;
include user2_map.conf;
}
server {
listen 80 default;
server_name _:
root $newroot;
}
if ($host = 'www.$site_name') {
rewrite ^/(.*)$ http://$site_name/$1 permanent;
}
server {
server_name ~^www\.(?<newhost>.+)$;
return 301 $scheme://$newhost$uri$is_args$query_string;
}