Все публикации Хабрахабр и Гиктаймс в одном месте
Выбран стиль: blue

Ошибка в запросе SELECT COUNT(*) as CountP FROM tblinkpost tp left join spuser u on u.UserID = tp.UserID left join tbhubpost h on h.LinkPostID = tp.LinkPostID left join sphub h0 on h.HubID in (select h2.HubID from sphub h2 where h2.HubName = (select h3.HubName from sphub h3 where h3.HubID = h0.HubID) ) WHERE 1=1 and tp.Ishide = 0 and tp.Title <> '' and h0.HubID = 2650 and tp.Dat >= DATE_SUB(CURDATE(),Interval 30 DAY) and DATE_ADD(CURDATE(),Interval 1 DAY)