История изменений
Исправление Anoxemian, (текущая версия) :
Вот тебе крутая задача: шизофазия на марше прямо в коде лора, исправь на нормальное использование sql
SELECT * FROM (SELECT DISTINCT ON(id) * FROM (SELECT t.userid as author, t.id, lastmod, t.stat1 AS stat1, g.id AS gid, g.title AS gtitle, t.title AS title, comments.id as cid, comments.userid AS last_comment_by, t.resolved as resolved,section,urlname,comments.postdate as comment_postdate, sections.moderate as smod, t.moderate,
И протащи в апстрим. 10к за запрос.
Исходная версия Anoxemian, :
Вот тебе крутая задача: шизофазия на марше прямо в коде лора, исправь на нормальное использование sql
SELECT * FROM (SELECT DISTINCT ON(id) * FROM (SELECT t.userid as author, t.id, lastmod, t.stat1 AS stat1, g.id AS gid, g.title AS gtitle, t.title AS title, comments.id as cid, comments.userid AS last_comment_by, t.resolved as resolved,section,urlname,comments.postdate as comment_postdate, sections.moderate as smod, t.moderate,
И ппотащи в апстрим. 10к за запрос.