Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- запрос
- Rate.objects.select_related(depth=1).
- FILTER(begin_date__lte = datetime.now(), end_date__gte = datetime.now()).
- FILTER(Q(source__short_name__in = ['USD']) | Q(dest__short_name__in = ['UZS']))
- -- результат
- SELECT
- "rates_widget_rates"."id",
- "rates_widget_rates"."source_id",
- "rates_widget_rates"."dest_id",
- "rates_widget_rates"."rate",
- "rates_widget_rates"."begin_date",
- "rates_widget_rates"."end_date",
- "rates_widget_currencies"."id",
- "rates_widget_currencies"."name",
- "rates_widget_currencies"."short_name",
- T3."id",
- T3."name",
- T3."short_name"
- FROM
- "rates_widget_rates"
- INNER JOIN "rates_widget_currencies"
- ON ("rates_widget_rates"."source_id" = "rates_widget_currencies"."id")
- INNER JOIN "rates_widget_currencies" T3
- ON ("rates_widget_rates"."dest_id" = T3."id")
- WHERE
- ("rates_widget_rates"."begin_date" <= 2011-03-16 00:54:41.697667
- AND "rates_widget_rates"."end_date" >= 2011-03-16 00:54:41.697685
- AND ("rates_widget_currencies"."short_name" IN (USD) OR T3."short_name" IN (UZS)))
- LIMIT 21
Advertisement
Add Comment
Please, Sign In to add comment