SELECT DISTINCT f.*
FROM figure f
INNER JOIN figure_tag ft ON f.figure_id = ft.figure_id
INNER JOIN tag t ON ft.tag_id = t.tag_id
WHERE 1
AND f.figure_status = '掲載'
AND f.figure_regist_date <= NOW()
AND f.figure_adult = '0'
AND t.tag_type = 'character'
AND t.tag_slug = '近藤妙子'
ORDER BY f.figure_update_date DESC, f.figure_id DESC LIMIT 0, 48
SELECT DISTINCT f.*
FROM figure f
WHERE 1
AND f.figure_status = '掲載'
AND f.figure_regist_date <= NOW()
AND f.figure_adult = '0' AND f.figure_regist_date > DATE_ADD(DATE(NOW()), INTERVAL -180 DAY)
ORDER BY f.figure_view_count DESC, f.figure_id DESC LIMIT 0, 10
SELECT DISTINCT f.*
FROM figure f
WHERE 1
AND f.figure_status = '掲載'
AND f.figure_regist_date <= NOW()
AND f.figure_adult = '0' AND DATE_FORMAT(f.figure_date_reserve, '%Y-%m') = '0000-00'
ORDER BY f.figure_date_reserve DESC, f.figure_id DESC LIMIT 0, 10
SELECT DISTINCT f.*
FROM figure f
WHERE 1
AND f.figure_status = '掲載'
AND f.figure_regist_date <= NOW()
AND f.figure_adult = '0'
AND f.figure_date_reserve > DATE_ADD(DATE(NOW()), INTERVAL -90 DAY)
AND f.figure_comment_count >= '1'
ORDER BY f.figure_comment_count DESC LIMIT 0, 10
近藤妙子 フィギュア一覧｜新作・予約・発売日情報｜Figgy
