검색조건에 따른 서브쿼리 서브쿼리는 안쪽(괄호 안)부터 짜는게 쉽다.SELECT * FROM (SELECT * FROM 테이블명 WHERE 필드명='1' ORDER BY uid DESC LIMIT 10 ) as temp UNION ALL (SELECT * FROM 테이블명 WHERE 필드명=' ' ORDER BY uid DESC) LIMIT 4,4; Mysql 2013.04.04