SELECT shopstat.*, 
  SUM(shopstat.map) AS map, SUM(shopstat.fav) AS fav, SUM(shopstat.page) AS page, SUM(shopstat.phone) AS phone, 
  SUM(shopstat.site) AS site, SUM(shopstat.vk) AS vk, SUM(shopstat.fb) AS fb, SUM(shopstat.insta) AS insta,
  SUM(shopstat.yt) AS yt, shop.name, city.name AS city
FROM shopstat
  LEFT JOIN shop ON shopstat.shop = shop.id
  LEFT JOIN city ON shop.city = city.id 
GROUP BY FROM_UNIXTIME(shopstat.date, "%d%m%Y"), shopstat.shop
ORDER BY shopstat.id DESC
LIMIT 0, 50

SELECT COUNT(shop.id) as count
FROM shopstat
  LEFT JOIN shop ON shopstat.shop = shop.id
  LEFT JOIN city ON shop.city = city.id
GROUP BY FROM_UNIXTIME(shopstat.date, "%d%m%Y"), shopstat.shop