How to create such query to mysql?

Question

PHP

SELECT `id_post`, `time` FROM `posts` GROUP BY `id_post` WHERE `time` BETWEEN FROM_UNIXTIME($min) AND FROM_UNIXTIME($max_time); The problem is GROUP BY `id_post`, and I perfectly understand why, but I don’t have enough experience to form it correctly, how can the resulting value SELECT `id_post`, `time` FROM `posts` GROUP BY `id_post`, be used for WHERE ?

Answer 1

GROUP BY is written after WHERE

select tab.*
  from ( SELECT `id_post`, `time` 
               FROM `posts` 
              GROUP BY `id_post` ,  `time` 
           ) tab
 where tab. `time` BETWEEN FROM_UNIXTIME($min) AND FROM_UNIXTIME($max_time);

Answer 2

1) Given that 'time' is not grouped - in some DBMS such an entry will return an error. What time to display if id_post will be the same 15 and all with different times?
2) WHERE first, then GROUP BY

Answer 3

https://ru.wikipedia.org/wiki/Having_%28SQL%29
if I understand you correctly, you don't need where here.
Can you formulate in plain language what you want to receive as a result of the request?

Answer 4

If there are several posts with the same `id_post`, then at `time` the grouping will take the value from one of the posts, it is impossible to tell from which one.
Well, after GROUP BY, you can use HAVING, but not WHERE.