select dd.tovar_id, dd.sender_id
from dialogs dd
where not exists(select 1
from dialogs ds
where ds.tovar_id = dd.tovar_id
and ds.recipient_id = dd.dd.sender_id
and ds.id < dd.id)
group by dd.tovar_id, dd.sender_id
def find_key(dct, key):
try:
if dct.get(key):
return dct[key]
else:
for k in dct.values():
val = find_key(k, key)
if val:
return val
except:
return
Resp = dict()
Resp["abc"] = dict()
Resp["2"] = dict()
Resp["abc"]["find"] = 1
Resp["2"]["find_1"] = 2
print(find_key(Resp, "find_1"))
select prt.ball
from price_ratings prt
where prt.type_name = 'price_items'
union
select prt.ball
from price_ratings prt
left join price_items pr
on pr.price_id = prt.type_id
left join price_ratings pp
on pp.type_id = pr.id
and pp.type_name = 'price_items'
where prt.type_name = 'price'
and pp.ball is null
select isnull(prt.ball, pri.ball)
from price_items pi
left join price_ratings prt
on prt.type_id = pi.id
and prt.type_name = 'price_items'
left join price_ratings pri
on pri.type_id = pi.price_id
and pri.type_name = 'price'
SELECT product_status.*,
product.*,
pay.*,
((SELECT SUM(pay.summa)
FROM pay
WHERE pay.pay_id = product.paysystem_id)/product.price)*100 AS 'percent'
FROM product_status
JOIN product
ON product.status_id = product_status.id
JOIN pay
ON pay.pay_id = product.paysystem_id
SELECT u.event_id,
u.event_name,
u.start_date,
u.end_date,
u.serv_id,
d.name,
c.client_nm as cli
FROM tevents u
LEFT OUTER JOIN doctors d
ON d.id = u.type
LEFT OUTER JOIN clients c
ON c.id = u.combo_select
WHERE u.start_date between '2018.05.23 06:00:00' and '2018.05.23 21:50:00'