SELECT id, title, category, priority, status, created_at,
       CASE WHEN ai_implementation_plan IS NOT NULL THEN true ELSE false END AS has_plan
FROM feature_suggestions
WHERE status IN ('pending', 'in_progress')
ORDER BY
  CASE status WHEN 'in_progress' THEN 0 ELSE 1 END,
  priority ASC NULLS LAST, created_at ASC

### Työn alla
1. #[short_id] [title] ([category]) - prioriteetti [N] [has_plan ? "✓ suunnitelma" : ""]

### Odottavat
1. #[short_id] [title] ([category]) - prioriteetti [N]

Valitse ehdotukset työn alle:
[list of pending suggestions as options]

UPDATE feature_suggestions SET status = 'in_progress', updated_at = NOW() WHERE id IN (...)

SELECT id, title, description, context_type, context_key, suggestion,
       priority, admin_notes, category, source, ai_implementation_plan,
       ai_plan_generated_at, created_at, status, benefit
FROM feature_suggestions WHERE id = '[id]'

## Ehdotus #[id]: [title]

**Kuvaus:** [description]
**Kategoria:** [category] | **Prioriteetti:** [priority] | **Tila:** [status]
**AI-suunnitelma:** [ai_implementation_plan or "Ei generoitu"]

SELECT id, title, category, priority,
       CASE WHEN ai_implementation_plan IS NOT NULL THEN true ELSE false END AS has_plan
FROM feature_suggestions
WHERE status = 'in_progress'
ORDER BY priority ASC NULLS LAST, created_at ASC

### Työn alla
1. #[short_id] [title] ([category]) [has_plan ? "✓ suunnitelma" : "⏳ ei suunnitelmaa"]

`/ehdota suunnitelma` — Tee suunnitelma
`/ehdota toteuta` — Toteuta
`/ehdota list` — Valitse lisää työn alle

SELECT id, title, description, category, benefit
FROM feature_suggestions
WHERE status = 'in_progress' AND ai_implementation_plan IS NULL
ORDER BY priority ASC NULLS LAST

## Toteutussuunnitelma: [title]

### Yhteenveto
[1-2 lausetta]

### Vaiheet
1. [ ] **[action]** - `path/to/file.tsx`
2. [ ] **[action]** - `path/to/file.tsx`

### Tietokantamuutokset
[migraatio tai "Ei tarvita"]

### Arvioitu laajuus
- Tiedostoja: [N]
- Vaikeusaste: [helppo/keskitaso/vaativa]

UPDATE feature_suggestions
SET ai_implementation_plan = '[plan]',
    ai_plan_generated_at = NOW(),
    updated_at = NOW()
WHERE id = '[id]'

SELECT id, title, description, category, ai_implementation_plan
FROM feature_suggestions
WHERE status = 'in_progress' AND ai_implementation_plan IS NOT NULL
ORDER BY priority ASC NULLS LAST

Toteutetaanko ehdotus #[id]: [title]?
[plan summary]

UPDATE feature_suggestions
SET status = 'implemented', updated_at = NOW()
WHERE id = '[id]'