検索結果一覧

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 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 GROUP BY core_video.id ORDER BY MAX(GREATEST(dvd_and_bd_release_date, single_item_hd_sales_start_datetime,single_item_3mb_sales_start_datetime,single_item_1_5mb_sales_start_datetime,single_item_photo_book_sales_start_datetime,flat_rate_item_vol1_sales_start_datetime,flat_rate_item_vol2_sales_start_datetime,flat_rate_item_vol3_sales_start_datetime,flat_rate_item_photo_book_sales_start_datetime)) DESC LIMIT 30 OFFSET 360
検索結果一覧