Organizing photos and scans on a computer?

Question

Automation

What is worth a try?

Requirements:
Ability to catalog files: photos and pdf-files (scans of documents)
Face recognition and sorting by faces.
Reading and editing photo meta tags.
Scanning photo archive for duplicates.
Reading geolocation and the ability to display photos on a world map.

Answer 1

A long time ago, in 2002, Google made a fucking application for this purpose - Picasa https://picasa.google.ru/ .
Closed it five years ago.
I have never seen such programs again.
On an old machine with Windows 7, where one of the old versions of the program is installed, everything still works flawlessly. I often use it

Answer 2

Adobe Lightroom Classic can do it all, and it costs less than 600 rubles a month for a subscription .

Answer 3

Nested SELECT queries are not a good idea, they will be called on every row of the main table.

SELECT `t`.`id_project`, `p`.`title`, `t`.`task_count`, 
       `t`.`task_lose`, `t`.`task_active`
  FROM (
    SELECT `id_project`, COUNT(*) AS `task_count`, 
           SUM(`status` = '1' AND `deadlines` < :TIME) AS `task_lose`,
           SUM(`status` = '1') AS `task_active`
      FROM `tasks`
      GROUP BY `id_project`
  ) AS `t`
  RIGHT JOIN `projects` AS `p` ON `p`.`id` = `t`.`id_project`
  ORDER BY `t`.`task_lose` DESC, `t`.`task_active` DESC, 
           `t`.`task_count` DESC