Lines Matching full:as

39         foreach ($tasks as $task) {
54 …                      task_closing_comment.content_html AS task_comment_content_html, task.assignee
57                                 AS task_closing_comment ON task.id = task_closing_comment.task_id
70         foreach ($stmt as $task) {
83                        SUM(task_participant.original_poster) AS original_poster_sum,
84                        SUM(task_participant.assignee) AS assignee_sum,
85                        SUM(task_participant.commentator) AS commentator_sum
93                        SUM(original_poster) AS original_poster_sum,
94                        SUM(assignee) AS assignee_sum,
95                        SUM(commentator) AS commentator_sum
111                         COUNT(CASE WHEN state = 'opened' THEN 1 END) AS opened,
113                           AS closed_on_time,
115                           AS closed_after_the_dedline,
116                         SUM(cost) AS total_cost,
119                             END) AS cost_of_closed,
120                         COUNT(*) AS 'count_all'
128                         COUNT(CASE WHEN state = 'opened' THEN 1 END) AS opened,
130                           AS closed_on_time,
132                           AS closed_after_the_dedline,
133                         SUM(cost) AS total_cost,
136                             END) AS cost_of_closed,
137                         COUNT(*) AS 'count_all'