SELECT u.*, COUNT(c.has_child) as sum, SUM(c.has_child) as sum2 FROM users as u LEFT JOIN children as c ON (c.user_id = u.id) GROUP BY c.user_id HAVING (sum = 0 OR sum2 = 0)
<link rel="stylesheet" type="text/css" href="Style.css" media="screen" />
//объявляем переменные
$peremennaya1=2; //присвоили числовое значение
$peremennaya2=2; //присвоили числовое значение
if (isset($_GET['peremennayapolz'])){
$peremennayapolz = intval($_GET['peremennayapolz']);
switch ($peremennayapolz) {
case $peremennayapolz < $peremennaya1:
echo "Задуманное число не входит в числовой ряд";
break;
case $peremennaya1 == $peremennayapolz: // все работает
echo "Переменная пользователя равна переменной 1";
break;
case $peremennayapolz > $peremennaya1: // все работает
echo "Переменная пользователя больше";
break;
default:
echo "Задай переменную";
break;
}
}
server {
listen 80;
server_name domain.ru;
location / {
proxy_pass http://111.111.111.111:80;
proxy_connect_timeout 60;
proxy_send_timeout 60;
proxy_read_timeout 60;
proxy_redirect off;
proxy_buffer_size 4k;
proxy_buffers 4 32k;
proxy_busy_buffers_size 64k;
proxy_temp_file_write_size 10m;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
}
}
server {
listen 443;
ssl on;
server_name domain.ru;
ssl_certificate /etc/nginx/ssl/domain.ru.crt;
ssl_certificate_key /etc/nginx/ssl/domain.ru.key;
ssl_protocols SSLv3 TLSv1 TLSv1.1 TLSv1.2;
ssl_ciphers "RC4:HIGH:!aNULL:!MD5:!kEDH";
location / {
proxy_pass https://111.111.111:443;
proxy_connect_timeout 60;
proxy_send_timeout 60;
proxy_read_timeout 60;
proxy_redirect off;
proxy_buffer_size 4k;
proxy_buffers 4 32k;
proxy_busy_buffers_size 64k;
proxy_temp_file_write_size 10m;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
}
}