SELECT DISTINCT
  target_special.target_id AS TID
FROM
  target_special
  LEFT JOIN lesson_target ON target_special.target_id = lesson_target.target_id
WHERE
  target_special.special_id = '1000039' AND lesson_target.lesson_id = '1000286' ORDER BY  target.ord





SELECT
  TID, Title, ord
FROM
  target
WHERE
  LID = '1000286' AND CID = '1000167'
ORDER BY
  ord
