|
[user_trade_query.go:1185] [UserTradeQuery] data sql source=clickhouse tables=weapon_4,weapon_5,weapon_6,weapon_7,weapon_8,weapon_9,weapon_10,weapon_11,weapon_12,weapon_13,weapon_14,weapon_15,weapon_52,weapon_53,weapon_54,weapon_72,weapon_73,weapon_74,weapon_83,weapon_91 sql="SELECT * FROM (SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_4' AS weapon_type, '枪' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_4 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND damage >= ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_5' AS weapon_type, '斧' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_5 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_6' AS weapon_type, '剑' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_6 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND magic >= ? AND damage >= ? AND stamina >= ? AND level >= ? AND level <= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_7' AS weapon_type, '双剑' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_7 WHERE status IN (?,?,?) AND special_skill = ? AND gem_type = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_8' AS weapon_type, '飘带' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_8 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_9' AS weapon_type, '爪刺' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_9 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_10' AS weapon_type, '扇' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_10 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND damage >= ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_11' AS weapon_type, '魔棒' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_11 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_12' AS weapon_type, '鞭子' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_12 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_13' AS weapon_type, '双环' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_13 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_14' AS weapon_type, '刀' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_14 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_15' AS weapon_type, '锤' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_15 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_52' AS weapon_type, '宝珠' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_52 WHERE status IN (?,?,?) AND special_skill = ? AND gem_type = ? AND damage >= ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_53' AS weapon_type, '弓弩' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_53 WHERE status IN (?,?,?) AND special_skill = ? AND gem_type = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_54' AS weapon_type, '法杖' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_54 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_72' AS weapon_type, '灯笼' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_72 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND stamina >= ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_73' AS weapon_type, '巨剑' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_73 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_74' AS weapon_type, '伞' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_74 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_83' AS weapon_type, '双斧' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_83 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ? UNION ALL SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_91' AS weapon_type, '' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_91 WHERE status IN (?,?,?) AND gem_type = ? AND special_skill = ? AND level >= ? AND level <= ? AND magic >= ? AND damage >= ? AND stamina >= ?) ORDER BY price ASC LIMIT 20 OFFSET 0" args=[4 5 6 太阳石 光辉之甲 580 20 140 140 32 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 32 580 20 140 140 4 5 6 光辉之甲 太阳石 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 580 20 140 140 32 4 5 6 太阳石 光辉之甲 20 140 140 32 580 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 20 140 140 32 580 4 5 6 太阳石 光辉之甲 20 140 140 32 580 4 5 6 光辉之甲 太阳石 580 20 140 140 32 4 5 6 光辉之甲 太阳石 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 20 140 140 32 580 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20 4 5 6 太阳石 光辉之甲 140 140 32 580 20]
›
|