SELECT e."entryId", e."title", e."preview", CHAR(MONTH(e."publicationDate")) || '/' || CHAR(DAY(e."publicationDate")) || '/' || CHAR(YEAR(e."publicationDate")) as "publicationDate", e."publicationDate" as "publicationDateTime", e."views", c."categoryId", c."name" as "categoryName", u."firstName", u."lastName", e."disableComments", count(DISTINCT m."commentId") as "commentCount", CASE WHEN e."timesRated" = 0 THEN 0 ELSE ROUND(e."totalRating"/e."timesRated", 0) END as averageRating FROM "NULLID"."Entry" as e LEFT JOIN "NULLID"."EntryCategory" as ec ON e."entryId" = ec."entryId" LEFT JOIN "NULLID"."Category" as c ON ec."categoryId" = c."categoryId" JOIN "NULLID"."User" as u ON e."postedByUserId" = u."userId" LEFT JOIN "NULLID"."Comment" as m ON e."entryId" = m."entryId" WHERE e."publicationDate" <= current timestamp AND c."categoryId" = AND MONTH(e."publicationDate") = AND YEAR(e."publicationDate") = AND timestampdiff(16, char(e."publicationDate" - current timestamp)) <= GROUP BY e."entryId", e."title", e."preview", CHAR(MONTH(e."publicationDate")) || '/' || CHAR(DAY(e."publicationDate")) || '/' || CHAR(YEAR(e."publicationDate")), e."publicationDate", e."views", c."categoryId", c."name", u."firstName", u."lastName", e."disableComments", CASE WHEN e."timesRated" = 0 THEN 0 ELSE ROUND(e."totalRating"/e."timesRated", 0) END ORDER BY e."publicationDate" DESC SELECT e."entryId", e."title", CASE WHEN e."timesRated" = 0 THEN 0 ELSE ROUND(e."totalRating"/e."timesRated", 0) END as averageRating FROM "NULLID"."Entry" as e ORDER BY CASE WHEN e."timesRated" = 0 THEN 0 ELSE ROUND(e."totalRating"/e."timesRated", 0) END DESC FETCH FIRST #limit# ROWS ONLY OPTIMIZE FOR #limit# ROWS SELECT e."entryId", e."title", e."views" FROM "NULLID"."Entry" as e ORDER BY e."views" DESC FETCH FIRST #limit# ROWS ONLY OPTIMIZE FOR #limit# ROWS SELECT e."entryId", e."title", count(c."commentId") as "comments" FROM "NULLID"."Entry" as e JOIN "NULLID"."Comment" as c ON e."entryId" = c."entryId" GROUP BY e."entryId", e."title" ORDER BY count(c."commentId") DESC FETCH FIRST #limit# ROWS ONLY OPTIMIZE FOR #limit# ROWS SELECT MONTH("publicationDate") as month, YEAR("publicationDate") as year, count("entryId") as "entryCount" FROM "NULLID"."Entry" GROUP BY MONTH("publicationDate"), YEAR("publicationDate") ORDER BY YEAR("publicationDate") desc, MONTH("publicationDate") desc