Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 148054
1
vote
1answer
In this query attributes a JSONB column: select COUNT(order_items.attributes) as sayi, order_items.attributes from order_items INNER JOIN products ON order_items.product_id = products.product_i …
asked Apr 6 '18 by SNaRe
0
votes
2answers
I can get a list of each day of last 30 days row by row with this query and it works.. But I don't think that it is the best one since the "WHERE" part is messed up. I draw a graph and I just want to …
asked Apr 5 '18 by SNaRe
0
votes
1answer
I know the title is a bit mysterious. I just would like to ask how I can optimize this query to work better I have orders and order_items. Every order_items has order_id from "orders" table so that s …
asked Apr 4 '18 by SNaRe
0
votes
1answer
I compare the some total numbers between today and 1 months ago. I created a query like this. Below you will see "commented" Where statements since I cannot get both results in same query SELECT C …
asked Apr 4 '18 by SNaRe
1
vote
2answers
I have a query. I would like to delete all selected rows in these 3 different tables Since I have a lot of INNER joins, I couldn't figure it out. My goal is to delete everything for these seller_ids. …
asked Apr 8 '18 by SNaRe
1
vote
1answer
I have a query. I just would like to get the number of orders for each distinct customer. But the results give me very high numbers, most probably somehow summing up all ids. What am I missing? SELEC …
asked Apr 15 '18 by SNaRe