Devart Forum

Код: Выделить всё

UPDATE users
SET
  prepayment_premier = :prepayment_premier
WHERE
  id = :user_id

Код: Выделить всё

SELECT sum(t1.sum1)
FROM
  (SELECT v.id
        , (v.price * sum(a.pn + a.vt + a.sr + a.ch + a.pt + a.sb)) AS sum1
   FROM
     vid v
   LEFT JOIN ads a
   ON (v.id = a.vid AND a.deleted <=> 0 AND a.max_date >= :max_date AND a.gdn <=> 0 AND a.paid <=> 0)
   WHERE
     id_user_ekr = :id_user_ekr
     

   GROUP BY
     1) AS t1

Код: Выделить всё

SELECT u.plus_sum_premier
FROM
  kvartal_ekr.users u
WHERE
  u.id = :id_user
  AND U.plus_sum_premier > 0
  AND u.is_blocked = 0
  AND u.is_deleted = 0