Which screenshot will be displayed first in the AppStore?

Question

MySQL

As you know, the first screenshot uploaded for your application in iTunes Connect is very important, it is displayed on the main page with the description of the application and when searching for it. But in the developer panel, when loading the first screenshot, it gets to the end of the list (to the right), hence the question is how to determine the first screenshot?

Based on my example, which screenshot will be displayed first - blue (1) or red (4)?

Answer 1

If the pairs (`id`, `f_id`) are unique, then you can do this:

SELECT `id`
  FROM `table`
  WHERE `f_id` IN (27, 47)
  GROUP BY `id`
  HAVING COUNT(`id`) = 2

Answer 2

Maybe something like this through joining the table to itself by f_id?

SELECT t1.id FROM table1 t1 INNER JOIN table1 t2 ON t1.f_id=t2.f_id AND t1.id<>t2.id

Answer 3

stackoverflow.com/questions/2300322/intersect-in-mysql

Answer 4

Red is first.