SELECT itm.*, itmText.textBlock,
            itmUrl.url, rank.rank
            FROM itm, itmUrl, rank
            LEFT JOIN itmText on itm.ID = itmText.ID
            WHERE itm.type = 4
            AND itm.ID = itmUrl.ID
            ORDER BY itm.name<br />DB Error: no such field