SELECT m.Type, m.Visits, m.Id, r.Title, u.Uid, IF(u.ShowProfile = 0, 'Anonymous', IF(u.Name != "", u.Name, u.Login)) as Name FROM MONTHLYVISITORS as m RIGHT JOIN RECIPES as r ON m.Id = r.Rid LEFT JOIN USER as u ON r.Uid = u.Uid WHERE 1 AND m.Type = 4 AND m.Month = 518 AND m.Site_id = 56 AND u.Author = 0 AND r.Data_from LIKE '2018-05%' ORDER BY m.Visits DESC LIMIT 0, 40
Top viewed user recipes for May 2018
There is no data for this month