Can you do this with the Django ORM?

[rossm6]

Can the django ORM do something like this?

SELECT * FROM "products_maxbid" as m
JOIN "products_auction" as a on m.auction_id = a.uuid
WHERE m.uuid in (
    SELECT m.uuid FROM "products_maxbid" as m
    INNER JOIN (
        SELECT auction_id, Max(value) as value FROM "products_maxbid"
        WHERE user_id = '2'
        GROUP BY auction_id
) n
on m.auction_id = n.auction_id and m.value = n.value and m.user_id = '2'
)
ORDER BY a.square_id

SO question - https://stackoverflow.com/questions/60789513/django-query-for-max-value-for-column-which-includes-foreign-key-table-also-in-r

[johnf]

google "django send raw sql"

Johnf

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAJXS7_MePOU_LYhVWLKsG0gz4XyVdDS8w4LhpFyYCQpQVUGkOw%40mail.gmail.com.