SQL dotaz

[Kosťa MK]

Zdravím,

mám následující problém:

Nad databází mám vytvořen relativně složitý view:

CREATE VIEW meta3 AS SELECT id,
                             title,
                             (SELECT author_sort          FROM authors 
WHERE authors.id IN (SELECT author from books_authors_link WHERE 
book=books.id)) authors,
                             (SELECT name                 FROM series 
WHERE series.id IN (SELECT series FROM books_series_link WHERE 
book=books.id)) series,
                             series_index,
                             (SELECT group_concat(name)   FROM tags 
WHERE tags.id IN (SELECT tag from books_tags_link WHERE book=books.id)) 
tags,
                             (SELECT group_concat(value)   FROM 
custom_column_1 WHERE custom_column_1.id IN (SELECT value from 
books_custom_column_1_link WHERE book=books.id)) genre,

                             (SELECT group_concat(value)   FROM 
custom_column_2 WHERE custom_column_2.id IN (SELECT value from 
books_custom_column_2_link WHERE book=books.id)) type,
                             path,
                             (SELECT name                 FROM data 
WHERE data.book=books.id) file,
                             (SELECT group_concat(format) FROM data 
WHERE data.book=books.id) formats,
timestamp
                             FROM books

funguje perfektně, jenže je zoufale pomalý pokud se pokusí o ORDER nad 
libovolným sloupcem

Mohl by mě pridím někdo nakopnout jak to zrychlit?

S pozdravem
Kosta