         var list = [Int]()
         
         execute({ (db) in
-            let selectSql = "select reward_id from gacha_data a, gacha_available b where a.id = b.gacha_id and a.dicription not like '%限定%'"
+            let selectSql = "select reward_id from gacha_data a, gacha_available b where a.id = b.gacha_id and a.dicription not like '%限定%' UNION select card_id reward_id from gacha_data a, gacha_available_2 b where a.id = b.gacha_id and a.dicription not like '%限定%'"
             let set = try db.executeQuery(selectSql, values: nil)
             while set.next() {
                 let rewardId = set.int(forColumnIndex: 0)

    func getTimeLimitAvailableList(callback: @escaping FMDBCallBackClosure<[Int]>) {
        var list = [Int]()
        execute({ (db) in
            let selectSql = "select reward_id from gacha_data a, gacha_available b where a.id = b.gacha_id and a.dicription like '%期間限定%' and recommend_order > 0"
            let set = try db.executeQuery(selectSql, values: nil)
            while set.next() {
                let rewardId = set.int(forColumnIndex: 0)

        var dict = [Int: String]()
        execute({ (db) in
            let selectSql = """
            SELECT
                a.id,
                min(c.start_date) gacha_date,
                min(e.event_start) event_date
            FROM
                card_data a
                LEFT JOIN (
                    SELECT
                        reward_id,
                        gacha_id
                    FROM
                        gacha_available
                    UNION
                    SELECT
                        card_id reward_id,
                        gacha_id
                    FROM
                        gacha_available_2) b ON a.id = b.reward_id
                LEFT JOIN gacha_data c ON b.gacha_id = c.id
                LEFT JOIN event_available d ON a.id = d.reward_id
                LEFT JOIN event_data e ON d.event_id = e.id
            GROUP BY
                a.id
            """
            let set = try db.executeQuery(selectSql, values: nil)
            while set.next() {
