Denis Holub

SELECT SUM(bonus), nlevel(tree) - nlevel('2.383') AS level
FROM "user" 
INNER JOIN "bonus_item" 
ON user_from = "user".id 
AND user_to = 383
WHERE (tree ~ '2.383.*{0,5}') 
AND ("mounth" = '9:2017')
GROUP BY nlevel(tree) - nlevel('2.383')
order by nl;

INSERT INTO video_category(video_id, category_id) VALUES(:video_id, :cat)
INSERT INTO video_category(video_id, category_id) VALUES(:video_id, :cat2)

SELECT a.photo
FROM table AS a
WHERE EXISTS (SELECT 1 FROM table AS b WHERE ','||b.his||',' LIKE '%,'||a.id||'-_,%' AND b.id = <определенное id>);

SELECT Cases.id, count(BotItems.id) AS "allcount", 
sum(case when (BotItems.itemid = Items.itemid and IFNULL(Items.type, 0) = 1) then 1 else 0 end) as "typecount"
FROM Cases LEFT JOIN Items ON Items.caseid = Cases.id 
LEFT JOIN BotItems ON BotItems.itemid = Items.itemid GROUP BY Cases.id

UPDATE table
SET stolbec2 = CONCAT(stolbec2, stolbec1);

SELECT *
FROM `poll`
INNER JOIN poll_answer ON poll.id = poll_answer.poll_id
INNER JOIN poll_result ON poll_answer.id = poll_result.poll_answer_id
WHERE CURDATE() BETWEEN poll.date_begin AND poll.date_end
AND poll_result.vote_ip ="222"

SELECT * 
FROM `poll` as b
WHERE NOT EXISTS (SELECT poll.id 
FROM `poll`
INNER JOIN poll_answer ON poll.id = poll_answer.poll_id
INNER JOIN poll_result ON poll_answer.id = poll_result.poll_answer_id
WHERE CURDATE() BETWEEN poll.date_begin AND poll.date_end
AND poll_result.vote_ip ="222"
AND b.id = poll.id)

select distinct a.id, a.value, (case when a.id_pc is not null then b.value when a.id_monitor is not null then c.value when a.id_printer is not null then d.value else null end) inv_num
from task a left join pc b on (a.id_pc=b.id)
left join monitor c on (a.id_monitor=c.id)
left join printer d on (a.id_printer=d.id)

select a.name
from mesta as a join mes_oso as b on (a.id = b.id_mesta)
                join osobennosti as c on (b.id_os=c.id)
where c.name_os in ('wi_fi', 'coffee_to_go')
group by a.name
having count(*) = 2