Do you want to make this exact query in Django?
Then use Your_model.objects.raw("the query here except the last semi colon")On Tue, Jul 30, 2019, 4:56 PM Jonathan Spicer <joh...@spicersolutions.co.uk> wrote: > Hello, > > I have an sql query that I would like to recreate using the ORM. Would it > be possible for someone to give me some pointers. > > select count(*) as total, > > concat(loading_code,code1_code,code2_code,code3_code,code4_code) as seq, > > concat(loading_id,',',code1_id,',',code2_id,',',code3_id,',',code4_id) as > ids > from FullMatches where job_id = %s group by seq, ids order > by total desc > > Thanks in advance. > > Johnny > > -- > 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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/d91ae3ab-f111-4081-8a6e-26fad5a2f782%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/d91ae3ab-f111-4081-8a6e-26fad5a2f782%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAC26BE0cEq4c_UWcO9BKMThazgMEHOpLp3dXiU%2Bb_SNmPgU%2BSg%40mail.gmail.com.
