Sorting by table

Here is a query I want to use. It works fine. I was rather surprised that it worked the first time I tried it.

Quote:

---

(select ID, title from anime WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%term%' ))
UNION
(select ID, title from misc WHERE (lcase( concat(cast(ID as char), summary)) LIKE '%term%' ))
UNION
(select ID, title from manga WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%term%' ))
order by ID asc limit 10

---

As you can see I am sorting by ID here, but how can I sort this by table then by ID or even just by table?

Silly me. Here is how the query would look if I want to sort by table and then by ID:

Quote:

---

(select ID, title from anime_review WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%term%' ) order by ID)
UNION
(select ID, title from misc WHERE (lcase( concat(cast(ID as char), summary)) LIKE '%term%' ) order by ID)
UNION
(select ID, title from manga_review WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%term%' ) order by ID)
limit 10

---