SELECT core_video.id FROM core_video LEFT JOIN core_video_tag_series ON core_video_tag_series.video_id=core_video.id WHERE (deleted_at < '1990-01-01 00:00:00' OR deleted_at IS NULL) AND is_public>0 AND tag_label_id=79 GROUP BY core_video.id ORDER BY created_at ASC LIMIT 999999 OFFSET 0
SELECT core_video.* FROM core_video LEFT JOIN core_video_tag_series ON core_video_tag_series.video_id=core_video.id WHERE (deleted_at < '1990-01-01 00:00:00' OR deleted_at IS NULL) AND is_public>0 AND tag_label_id=79 GROUP BY core_video.id ORDER BY dvd_and_bd_release_date DESC,old_id DESC LIMIT 30 OFFSET 0
検索結果一覧