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 = 'USD', dest__short_name = 'UZS') | Q(source__short_name = 'USD', dest__short_name = 'RUB'))
- 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",
- T3."id",
- T3."name",
- T3."short_name",
- "rates_widget_currencies"."id",
- "rates_widget_currencies"."name",
- "rates_widget_currencies"."short_name"
- FROM
- "rates_widget_rates"
- INNER JOIN "rates_widget_currencies"
- ON ("rates_widget_rates"."dest_id" = "rates_widget_currencies"."id")
- INNER JOIN "rates_widget_currencies" T3
- ON ("rates_widget_rates"."source_id" = T3."id")
- WHERE
- ("rates_widget_rates"."begin_date" <= 2011-03-16 12:34:43.320052
- AND "rates_widget_rates"."end_date" >= 2011-03-16 12:34:43.320071
- AND (("rates_widget_currencies"."short_name" = UZS AND T3."short_name" = USD )
- OR ("rates_widget_currencies"."short_name" = RUB AND T3."short_name" = USD )))
- LIMIT 21
Advertisement
Add Comment
Please, Sign In to add comment