SELECT q.*, qt.*, u.username, u.user_id, u.user_colour
        FROM
            (SELECT * FROM azforum__quotescript_quotes
            WHERE quote_visible = 1
            ORDER BY quote_date DESC
            LIMIT 10) q
        LEFT JOIN
            azforum__users u
        ON
            q.quote_uid = u.user_id
        JOIN
            azforum__quotescript_quotetag qt
        ON
            q.quote_id = qt.quote_id