2011-03-17 05:08:30 |
Robert Collins |
description |
4 SELECT $INT FROM (SELECT Specification.approver, Specification.assignee, Specification.completer, ... tion_status = $INT AND Specification.definition_status = $INT) ) LIMIT $INT) AS "_tmp" LIMIT $INT:
GET: 4 Robots: 4 Local: 0
2 https://blueprints.launchpad.net/%7Elocoteams/+specworkload (Person:+specworkload)
OOPS-1900H932, OOPS-1900K59
1 https://blueprints.launchpad.net/%7Elaunchpad-beta-testers/+specworkload (Person:+specworkload)
OOPS-1900J432
1 https://blueprints.launchpad.net/%7Eloco-philippine-team/+specworkload (Person:+specworkload)
OOPS-1900B479 |
4 SELECT $INT FROM (SELECT Specification.approver, Specification.assignee, Specification.completer, ... tion_status = $INT AND Specification.definition_status = $INT) ) LIMIT $INT) AS "_tmp" LIMIT $INT:
GET: 4 Robots: 4 Local: 0
2 https://blueprints.launchpad.net/%7Elocoteams/+specworkload (Person:+specworkload)
OOPS-1900H932, OOPS-1900K59
1 https://blueprints.launchpad.net/%7Elaunchpad-beta-testers/+specworkload (Person:+specworkload)
OOPS-1900J432
1 https://blueprints.launchpad.net/%7Eloco-philippine-team/+specworkload (Person:+specworkload)
OOPS-1900B479
death by sql
1 94 9389 99 9290 SQL-launchpad-main-slave
SELECT $INT
FROM
(SELECT Specification.approver, Specification.assignee, Specification.completer, Specification.date_completed, Specification.date_goal_decided, Specification.date_goal_proposed, Specification.date_started, Specification.datecreated, Specification.definition_status, Specification.direction_approved, Specification.distribution, Specification.distroseries, Specification.drafter, Specification.goal_decider, Specification.goal_proposer, Specification.goalstatus, Specification.id, Specification.implementation_status, Specification.man_days, Specification.milestone, Specification.name, Specification.OWNER, Specification.priority, Specification.private, Specification.product, Specification.productseries, Specification.specurl, Specification.starter, Specification.summary, Specification.superseded_by, Specification.title, Specification.whiteboard
FROM Specification
WHERE ($INT=$INT
OR Specification.OWNER = $INT
OR Specification.assignee = $INT
OR Specification.drafter = $INT
OR Specification.approver = $INT
OR Specification.id IN
(SELECT specification
FROM SpecificationSubscription
WHERE person = $INT)
OR Specification.id IN
(SELECT specification
FROM SpecificationFeedback
WHERE reviewer = $INT))
AND (Specification.product IS NULL
OR Specification.product NOT IN
(SELECT Product.id
FROM Product
WHERE Product.active IS FALSE))
AND NOT (Specification.implementation_status = $INT
OR Specification.definition_status IN ($INT, $INT)
OR (Specification.implementation_status = $INT
AND Specification.definition_status = $INT))LIMIT $INT) AS "_tmp" LIMIT $INT |
|