0 Vote
0 Answer
82 Views
I'm trying to run raw SQL commands in my Django code but when it runs it says the 'No such column..' for any of my properties. I run the same sql command in DB Browser and it runs just fine. Am I ...
0 Vote
0 Answer
82 Views
0 Vote
0 Answer
0 Views
0 Vote
1 Answer
66 Views
Im using this query, which takes 3 secounds to run. The table announces has 255k rows and the table address has 30k rows. SELECT COUNT(DISTINCT ad.id) as total_address FROM ( ...
0 Vote
1 Answer
66 Views
0 Vote
1 Answer
69 Views
I have this query on the order lines table. Its a fairly large table. I am trying to get quantity shipped by item in the last 365 days. The query works, but is very slow to return results. Should ...
0 Vote
1 Answer
69 Views
0 Vote
1 Answer
66 Views
I've created a nested commenting system like so: id user_id comment comment_date parent_comment_id And I am trying to get a thread of comments by there parent ids. My query is as such: with ...
0 Vote
1 Answer
66 Views
0 Vote
0 Answer
0 Views