Incorrect usage of UNION and LIMIT<br>
        SELECT COUNT(*) as total FROM (
            SELECT id FROM ***_ecms_news WHERE title LIKE BINARY '%833直播足球%' LIMIT 1000
            UNION ALL
            SELECT id FROM ***_ecms_lx WHERE title LIKE BINARY '%833直播足球%' LIMIT 1000
            UNION ALL
            SELECT id FROM ***_ecms_jj WHERE title LIKE BINARY '%833直播足球%' LIMIT 1000
        ) as t