Lines Matching full:as

34                        SUM(thread_participant.original_poster) AS original_poster_sum,
35                        SUM(thread_participant.coordinator) AS coordinator_sum,
36                        SUM(thread_participant.commentator) AS commentator_sum,
37                        SUM(thread_participant.task_assignee) AS task_assignee_sum
45                            SUM(original_poster) AS original_poster_sum,
46                            SUM(coordinator) AS coordinator_sum,
47                            SUM(commentator) AS commentator_sum,
48                            SUM(task_assignee) AS task_assignee_sum
63             $sql = "SELECT COUNT(*)*1.0/COUNT(DISTINCT thread_id) AS kpi
68             $sql = "SELECT COUNT(*)*1.0/COUNT(DISTINCT thread_id) AS kpi
112                            COUNT(CASE WHEN state = 'proposal' THEN 1 END) AS proposal,
113                            COUNT(CASE WHEN state = 'opened' THEN 1 END) AS opened,
114                            COUNT(CASE WHEN state = 'done' THEN 1 END) AS done,
115                            COUNT(CASE WHEN state = 'closed' THEN 1 END) AS closed,
116                            COUNT(CASE WHEN state = 'rejected' THEN 1 END) AS rejected,
117                            COUNT(*) AS count_all,
118                            SUM(task_sum_cost) AS sum_all,
119                            SUM(CASE WHEN state = 'closed' THEN task_sum_cost END) AS sum_closed,
122                             END) AS avg_closed
131                            COUNT(CASE WHEN state = 'proposal' THEN 1 END) AS proposal,
132                            COUNT(CASE WHEN state = 'opened' THEN 1 END) AS opened,
133                            COUNT(CASE WHEN state = 'done' THEN 1 END) AS done,
134                            COUNT(CASE WHEN state = 'closed' THEN 1 END) AS closed,
135                            COUNT(CASE WHEN state = 'rejected' THEN 1 END) AS rejected,
136                            COUNT(*) AS count_all,
137                            SUM(task_sum_cost) AS sum_all,
138                            SUM(CASE WHEN state = 'closed' THEN task_sum_cost END) AS sum_closed,
141                             END) AS avg_closed
158                            COUNT(CASE WHEN state = 'proposal' THEN 1 END) AS proposal,
159                            COUNT(CASE WHEN state = 'opened' THEN 1 END) AS opened,
160                            COUNT(CASE WHEN state = 'done' THEN 1 END) AS done,
161                            COUNT(CASE WHEN state = 'closed' THEN 1 END) AS closed,
162                            COUNT(CASE WHEN state = 'rejected' THEN 1 END) AS rejected,
163                            COUNT(*) AS count_all,
164                            SUM(task_sum_cost) AS sum_all,
165                            SUM(CASE WHEN state = 'closed' THEN task_sum_cost END) AS sum_closed,
168                             END) AS avg_closed
175                            COUNT(CASE WHEN state = 'proposal' THEN 1 END) AS proposal,
176                            COUNT(CASE WHEN state = 'opened' THEN 1 END) AS opened,
177                            COUNT(CASE WHEN state = 'done' THEN 1 END) AS done,
178                            COUNT(CASE WHEN state = 'closed' THEN 1 END) AS closed,
179                            COUNT(CASE WHEN state = 'rejected' THEN 1 END) AS rejected,
180                            COUNT(*) AS count_all,
181                            SUM(task_sum_cost) AS sum_all,
182                            SUM(CASE WHEN state = 'closed' THEN task_sum_cost END) AS sum_closed,
185                             END) AS avg_closed
204             foreach($label_ids as $label_id) {
266             foreach($labels_to_add as $label_id) {
270             foreach($labels_to_rem as $label_id) {