SELECT t0_.id AS id0, t0_.rate AS rate1, t0_.revised_rate AS revised_rate2, t0_.title AS title3, t0_.points AS points4, t0_.due AS due5, t0_.created AS created6, t0_.projected_minutes AS projected_minutes7, i1_.id AS id8, i1_.title AS title9, c2_.id AS id10, c2_.customer_code AS customer_code11, t3_.id AS id12, t3_.title AS title13, p4_.id AS id14, (SELECT SUBSTR(f5_.firstname, 0, 4) || ' ' || SUBSTR(f5_.lastname, 0, 2) AS sclr16 FROM fos_user f5_ WHERE (f5_.id = t0_.user_id) AND (f5_.deleted IS NULL)) AS sclr15, (SELECT SUBSTR(f6_.firstname, 0, 4) || ' ' || SUBSTR(f6_.lastname, 0, 2) AS sclr18 FROM fos_user f6_ WHERE (f6_.id = i1_.user_id) AND (f6_.deleted IS NULL)) AS sclr17, (SELECT SUM(s7_.stop - s7_.start) AS dctrn__3 FROM slip s7_ WHERE (s7_.task_id = t0_.id) AND (s7_.deleted IS NULL)) AS sclr19, (SELECT MAX(s8_.stop) AS dctrn__4 FROM slip s8_ WHERE (s8_.task_id = t0_.id) AND (s8_.deleted IS NULL)) AS sclr20, (SELECT SUM(s9_.stop - s9_.start) AS dctrn__5 FROM task t10_ LEFT JOIN slip s9_ ON t10_.id = s9_.task_id AND (s9_.deleted IS NULL) WHERE (t10_.invoice_id = i1_.id) AND (t10_.deleted IS NULL)) AS sclr21, (SELECT SUM(t11_.projected_minutes) AS dctrn__6 FROM task t11_ WHERE (t11_.invoice_id = i1_.id) AND (t11_.deleted IS NULL)) AS sclr22, t0_.user_id AS sclr23, i1_.user_id AS sclr24, i12_.id AS id25, i12_.title AS title26, o13_.id AS id27, o13_.name AS name28 FROM task t0_ INNER JOIN invoice i1_ ON t0_.invoice_id = i1_.id AND (i1_.deleted IS NULL) INNER JOIN company c2_ ON i1_.company_id = c2_.id LEFT JOIN task_status t3_ ON t0_.status_id = t3_.id AND (t3_.deleted IS NULL) LEFT JOIN priority p4_ ON t0_.priority_id = p4_.id AND (p4_.deleted IS NULL) LEFT JOIN invoice_status i12_ ON i1_.status_id = i12_.id AND (i12_.deleted IS NULL) LEFT JOIN opportunity o13_ ON i1_.opportunity_id = o13_.id WHERE (t0_.deleted IS NULL) ORDER BY t0_.due ASC LIMIT 0 OFFSET 0