SELECT
  DISTINCT c.id as cid,
  c.title,
  c.description,
  t.value as tags
FROM
  connect_tag_com ctc
  JOIN tags t on t.id = ctc.tag_id
  JOIN components c on c.id = ctc.component_id
WHERE
  ctc.tag_id IN ('9', '10', '1')
ORDER BY
  FIELD (ctc.tag_id, "9", "10", "1") ASC