Nikolaymac

SELECT `v`.`id_user`, `v`.`count`, ...
  FROM (
    SELECT `id_user`, COUNT(DISTINCT FROM_UNIXTIME(time_vizit, '%Y%m%d')) AS `count`
      FROM `vizits`
      WHERE `time_vizit` BETWEEN UNIX_TIMESTAMP(:startTime) AND UNIX_TIMESTAMP(:endTime)
        AND `id_client` = :clientId
      GROUP BY `id_user`
      HAVING COUNT(*) > 2
  ) AS `v`
  LEFT JOIN `users_hotspot` AS `uh` ON `uh`.`id_user` = `v`.`id_user`

SELECT * FROM pages WHERE id NOT IN (SELECT id_page FROM menu_pages WHERE id_menu = 1)