Django placing of WHERE in raw SQL query

Question

The order of the WHERE in this query was wrong, but it is correct now.

postModel = list(PostModel.objects.raw(
SELECT max(pub_date), 
   count(topic_id) AS freq, 
   count(DISTINCT author) AS contributors 
   FROM crudapp_postmodel 
   WHERE author = "art" 
   GROUP BY topic_id 
   ORDER BY pub_date DESC
))

Thanks

You should really read the documentation on creating SQL queries before asking for help, but this should work: `SELECT max(pub_date), count(topic_id) AS freq, count(DISTINCT author) AS contributors FROM crudapp_postmodel WHERE author = "art" GROUP BY topic_id ORDER BY pub_date DESC` — solarissmoke, Jun 17 '16 at 13:43

score 2 · Accepted Answer · edited Jun 20 '16 at 12:20

2

Simple:

SELECT max(pub_date), 
       count(topic_id) AS freq, 
       count(DISTINCT author) AS contributors 
       FROM crudapp_postmodel 
       WHERE author = "art" 
       GROUP BY topic_id 
       ORDER BY pub_date DESC

edited Jun 20 '16 at 12:20

Shane G

3,129
10
43
85

answered Jun 20 '16 at 10:59

Hamed Rostami

1,670
14
16

@solarissmoke actually answered it also. Thanks – Shane G Jun 20 '16 at 11:18

Django placing of WHERE in raw SQL query

1 Answers1