Iniciar sesión
Crear cuenta
Crear cuentaCrear cuenta
SELECT "public"."user_credit"."user_id" AS "id","user_user__via__user_id"."first_name" AS "first_name", "user_user__via__user_id"."last_name" AS "last_name", sum("public"."user_credit"."amount") AS "date_1",
(SELECT sum("public"."user_credit"."amount") AS "date_2" FROM "public"."user_credit" WHERE "public"."user_credit"."start_date" < {{created_at2}} AND "public"."user_credit"."status" = 200 )
FROM "public"."user_credit"
LEFT JOIN "public"."user_user" "user_user__via__user_id" ON "public"."user_credit"."user_id" = "user_user__via__user_id"."id"
WHERE "public"."user_credit"."status" = 200 AND "public"."user_credit"."start_date" < {{created_at}}
GROUP BY "public"."user_credit"."user_id","user_user__via__user_id"."first_name", "user_user__via__user_id"."last_name"
ORDER BY "public"."user_credit"."user_id" ASC,"user_user__via__user_id"."first_name" ASC, "user_user__via__user_id"."last_name" ASC
LIMIT 2000
