SQL：控制返回多少记录

您去了（未体验）：

SELECt movie.id, movie.title, star.name, star.name_url, dir.name,        dir.name_url, genre.name, genre.name_url FROM         (SELECt * FROM movie WHERe movie.id > 0 ORDER BY movie.id LIMIT 10) movie        LEFT JOIN actor   ON (movie.id = actor.movie_id)         LEFT JOIN person AS star   ON (actor.person_id = star.id)         LEFT JOIN director   ON (movie.id = director.movie_id)         LEFT JOIN person AS dir   ON (director.person_id = dir.id)         LEFT JOIN genre_classification   ON (movie.id = genre_classification.movie_id)         LEFT JOIN genre   ON (genre_classification.genre_id = genre.id)

编辑：通过将所有条件放入子选择中，您无法控制源表中的哪些数据

movie