* account_id key index value

* account_id key index value

* char_id id count1 count2 count3 count4 count5 count6 count7 count8 count9 count10 completed rewarded

* auction_id seller_id seller_name buyer_id buyer_name price buynow hours timestamp nameid item_name type refine attribute card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 unique_id enchantgrade

* name index amount

* char_id script tick flag type icon

* id account_id char_id sex map x y title limit body_direction head_direction sit autotrade

* buyingstore_id index item_id amount price

* id char_id nameid amount equip identify refine attribute card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 expire_time bound unique_id enchantgrade

* char_id account_id char_num name class base_level job_level base_exp job_exp zeny str agi vit int dex luk pow sta wis spl con crt max_hp hp max_sp sp max_ap ap status_point skill_point trait_point option karma manner party_id guild_id pet_id homun_id elemental_id hair hair_color clothes_color body weapon shield head_top head_mid head_bottom robe last_map last_x last_y last_instanceid save_map save_x save_y partner_id online father mother child fame rename delete_date moves unban_time font uniqueitem_counter sex hotkey_rowshift hotkey_rowshift2 clan_id last_login title_id show_equip inventory_slots body_direction disable_call disable_partyinvite disable_showcostumes

* id time char_msg account_id char_num name str agi vit int dex luk hair hair_color

* char_id key index value

* char_id key index value

* clan_id name master mapname max_member

* clan_id opposition alliance_id name

* id account_id banned_by ban_type ban_until ban_date ban_reason

* id account_id char_id name value create_date

* id title body link author created modified

* id path title body modified

* name value

* id command issuer account_id done timestamp

* id account_id userid user_pass sex email reg_date reg_ip delete_date confirmed confirm_code confirm_expire

* account_id balance last_donation_date last_donation_amount

* id code account_id old_email new_email request_date request_ip change_date change_ip change_done

* id ip_address banned_by ban_type ban_until ban_date ban_reason

* itemid itemdesc

* id nameid category quantity cost info use_existing create_date

* id account_id username password ip login_date error_code

* id account_id name value create_date

* id users date

* id account_id old_password new_password change_date change_ip

* id nameid quantity cost account_id char_id redeemed redemption_date purchase_date credits_before credits_after

* id code account_id old_password new_password request_date request_ip reset_date reset_ip reset_done

* ticket_id account_id category status char_id timestamp sslink chatlink videolink subject text ip team curemail lastreply

* action_id ticket_id author text action timestamp ip isstaff

* cat_id name display

* account_id account_name prefered_name team emailalerts timestamp

* id account_id email create_date delete_date

* id account_id server_name credits receiver_email item_name item_number quantity payment_status pending_reason payment_date mc_gross mc_fee tax mc_currency parent_txn_id txn_id txn_type first_name last_name address_street address_city address_state address_zip address_country address_status payer_email payer_status payment_type notify_version verify_sign referrer_id process_date hold_until

* id from_account_id target_account_id target_char_id amount for_free transfer_date

* index level item_id amount flag

* ele_id char_id class mode hp sp max_hp max_sp atk1 atk2 matk aspd def mdef flee hit life_time

* char_id friend_id

* account_id key index value

* account_id key index value

* guild_id name char_id master guild_lv connect_member max_member average_lv exp next_exp skill_point mes1 mes2 emblem_len emblem_id emblem_data last_master_change

* guild_id opposition alliance_id name

* castle_id guild_id economy defense triggerE triggerD nextTime payTime createTime visibleC visibleG0 visibleG1 visibleG2 visibleG3 visibleG4 visibleG5 visibleG6 visibleG7

* guild_id account_id name mes char_id

* guild_id char_id exp position

* guild_id position name mode exp_mode

* guild_id id lv

* id guild_id nameid amount equip identify refine attribute card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 expire_time bound unique_id enchantgrade

* id guild_id time char_id name nameid amount identify refine attribute card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 expire_time unique_id bound enchantgrade

* homun_id char_id class prev_class name level exp intimacy hunger str agi vit int dex luk hp max_hp sp max_sp skill_point alive rename_flag vaporize autofeed

* char_id hotkey type itemskill_id skill_lvl

* id time log

* id char_id nameid amount equip identify refine attribute card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 expire_time favorite bound unique_id equip_switch enchantgrade

* list btime rtime reason

* id name_aegis name_english type subtype price_buy price_sell weight attack defense range slots job_all job_acolyte job_alchemist job_archer job_assassin job_barddancer job_blacksmith job_crusader job_gunslinger job_hunter job_knight job_mage job_merchant job_monk job_ninja job_novice job_priest job_rogue job_sage job_soullinker job_stargladiator job_supernovice job_swordman job_taekwon job_thief job_wizard class_all class_normal class_upper class_baby gender location_head_top location_head_mid location_head_low location_armor location_right_hand location_left_hand location_garment location_shoes location_right_accessory location_left_accessory location_costume_head_top location_costume_head_mid location_costume_head_low location_costume_garment location_ammo location_shadow_armor location_shadow_weapon location_shadow_shield location_shadow_shoes location_shadow_right_accessory location_shadow_left_accessory weapon_level armor_level equip_level_min equip_level_max refineable view alias_name flag_buyingstore flag_deadbranch flag_container flag_uniqueid flag_bindonequip flag_dropannounce flag_noconsume flag_dropeffect delay_duration delay_status stack_amount stack_inventory stack_cart stack_storage stack_guildstorage nouse_override nouse_sitting trade_override trade_nodrop trade_notrade trade_tradepartner trade_nosell trade_nocart trade_nostorage trade_noguildstorage trade_nomail trade_noauction script equip_script unequip_script

* id name_aegis name_english type subtype price_buy price_sell weight attack defense range slots job_all job_acolyte job_alchemist job_archer job_assassin job_barddancer job_blacksmith job_crusader job_gunslinger job_hunter job_knight job_mage job_merchant job_monk job_ninja job_novice job_priest job_rogue job_sage job_soullinker job_stargladiator job_supernovice job_swordman job_taekwon job_thief job_wizard class_all class_normal class_upper class_baby gender location_head_top location_head_mid location_head_low location_armor location_right_hand location_left_hand location_garment location_shoes location_right_accessory location_left_accessory location_costume_head_top location_costume_head_mid location_costume_head_low location_costume_garment location_ammo location_shadow_armor location_shadow_weapon location_shadow_shield location_shadow_shoes location_shadow_right_accessory location_shadow_left_accessory weapon_level armor_level equip_level_min equip_level_max refineable view alias_name flag_buyingstore flag_deadbranch flag_container flag_uniqueid flag_bindonequip flag_dropannounce flag_noconsume flag_dropeffect delay_duration delay_status stack_amount stack_inventory stack_cart stack_storage stack_guildstorage nouse_override nouse_sitting trade_override trade_nodrop trade_notrade trade_tradepartner trade_nosell trade_nocart trade_nostorage trade_noguildstorage trade_nomail trade_noauction script equip_script unequip_script

* id name_aegis name_english type subtype price_buy price_sell weight attack magic_attack defense range slots job_all job_acolyte job_alchemist job_archer job_assassin job_barddancer job_blacksmith job_crusader job_gunslinger job_hunter job_kagerouoboro job_knight job_mage job_merchant job_monk job_ninja job_novice job_priest job_rebellion job_rogue job_sage job_soullinker job_spirit_handler job_stargladiator job_summoner job_supernovice job_swordman job_taekwon job_thief job_wizard class_all class_normal class_upper class_baby class_third class_third_upper class_third_baby class_fourth gender location_head_top location_head_mid location_head_low location_armor location_right_hand location_left_hand location_garment location_shoes location_right_accessory location_left_accessory location_costume_head_top location_costume_head_mid location_costume_head_low location_costume_garment location_ammo location_shadow_armor location_shadow_weapon location_shadow_shield location_shadow_shoes location_shadow_right_accessory location_shadow_left_accessory weapon_level armor_level equip_level_min equip_level_max refineable gradable view alias_name flag_buyingstore flag_deadbranch flag_container flag_uniqueid flag_bindonequip flag_dropannounce flag_noconsume flag_dropeffect delay_duration delay_status stack_amount stack_inventory stack_cart stack_storage stack_guildstorage nouse_override nouse_sitting trade_override trade_nodrop trade_notrade trade_tradepartner trade_nosell trade_nocart trade_nostorage trade_noguildstorage trade_nomail trade_noauction script equip_script unequip_script

* id name_aegis name_english type subtype price_buy price_sell weight attack magic_attack defense range slots job_all job_acolyte job_alchemist job_archer job_assassin job_barddancer job_blacksmith job_crusader job_gunslinger job_hunter job_kagerouoboro job_knight job_mage job_merchant job_monk job_ninja job_novice job_priest job_rebellion job_rogue job_sage job_soullinker job_spirit_handler job_stargladiator job_summoner job_supernovice job_swordman job_taekwon job_thief job_wizard class_all class_normal class_upper class_baby class_third class_third_upper class_third_baby class_fourth gender location_head_top location_head_mid location_head_low location_armor location_right_hand location_left_hand location_garment location_shoes location_right_accessory location_left_accessory location_costume_head_top location_costume_head_mid location_costume_head_low location_costume_garment location_ammo location_shadow_armor location_shadow_weapon location_shadow_shield location_shadow_shoes location_shadow_right_accessory location_shadow_left_accessory weapon_level armor_level equip_level_min equip_level_max refineable gradable view alias_name flag_buyingstore flag_deadbranch flag_container flag_uniqueid flag_bindonequip flag_dropannounce flag_noconsume flag_dropeffect delay_duration delay_status stack_amount stack_inventory stack_cart stack_storage stack_guildstorage nouse_override nouse_sitting trade_override trade_nodrop trade_notrade trade_tradepartner trade_nosell trade_nocart trade_nostorage trade_noguildstorage trade_nomail trade_noauction script equip_script unequip_script

* account_id userid user_pass sex email group_id state unban_time expiration_time logincount lastlogin last_ip birthdate character_slots pincode pincode_change vip_time old_group web_auth_token web_auth_token_enabled

* id send_name send_id dest_name dest_id title message time status zeny type

* id index nameid amount refine attribute identify card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 unique_id bound enchantgrade

* varname index value

* name nameid price amount flag

* memo_id char_id map x y

* mer_id char_id class hp sp kill_counter life_time

* char_id merc_id arch_calls arch_faith spear_calls spear_faith sword_calls sword_faith

* id name_aegis name_english name_japanese level hp sp base_exp job_exp mvp_exp attack attack2 defense magic_defense resistance magic_resistance str agi vit int dex luk attack_range skill_range chase_range size race racegroup_goblin racegroup_kobold racegroup_orc racegroup_golem racegroup_guardian racegroup_ninja racegroup_gvg racegroup_battlefield racegroup_treasure racegroup_biolab racegroup_manuk racegroup_splendide racegroup_scaraba racegroup_ogh_atk_def racegroup_ogh_hidden racegroup_bio5_swordman_thief racegroup_bio5_acolyte_merchant racegroup_bio5_mage_archer racegroup_bio5_mvp racegroup_clocktower racegroup_thanatos racegroup_faceworm racegroup_hearthunter racegroup_rockridge racegroup_werner_lab racegroup_temple_demon racegroup_illusion_vampire racegroup_malangdo racegroup_ep172alpha racegroup_ep172beta racegroup_ep172bath racegroup_illusion_turtle racegroup_rachel_sanctuary racegroup_illusion_luanda racegroup_illusion_frozen racegroup_illusion_moonlight racegroup_ep16_def racegroup_edda_arunafeltz racegroup_lasagna racegroup_glast_heim_abyss racegroup_destroyed_valkyrie_realm racegroup_encroached_gephenia element element_level walk_speed attack_delay attack_motion damage_motion damage_taken groupid title ai class mode_canmove mode_looter mode_aggressive mode_assist mode_castsensoridle mode_norandomwalk mode_nocast mode_canattack mode_castsensorchase mode_changechase mode_angry mode_changetargetmelee mode_changetargetchase mode_targetweak mode_randomtarget mode_ignoremelee mode_ignoremagic mode_ignoreranged mode_mvp mode_ignoremisc mode_knockbackimmune mode_teleportblock mode_fixeditemdrop mode_detector mode_statusimmune mode_skillimmune mvpdrop1_item mvpdrop1_rate mvpdrop1_option mvpdrop1_index mvpdrop2_item mvpdrop2_rate mvpdrop2_option mvpdrop2_index mvpdrop3_item mvpdrop3_rate mvpdrop3_option mvpdrop3_index drop1_item drop1_rate drop1_nosteal drop1_option drop1_index drop2_item drop2_rate drop2_nosteal drop2_option drop2_index drop3_item drop3_rate drop3_nosteal drop3_option drop3_index drop4_item drop4_rate drop4_nosteal drop4_option drop4_index drop5_item drop5_rate drop5_nosteal drop5_option drop5_index drop6_item drop6_rate drop6_nosteal drop6_option drop6_index drop7_item drop7_rate drop7_nosteal drop7_option drop7_index drop8_item drop8_rate drop8_nosteal drop8_option drop8_index drop9_item drop9_rate drop9_nosteal drop9_option drop9_index drop10_item drop10_rate drop10_nosteal drop10_option drop10_index

* id name_aegis name_english name_japanese level hp sp base_exp job_exp mvp_exp attack attack2 defense magic_defense resistance magic_resistance str agi vit int dex luk attack_range skill_range chase_range size race racegroup_goblin racegroup_kobold racegroup_orc racegroup_golem racegroup_guardian racegroup_ninja racegroup_gvg racegroup_battlefield racegroup_treasure racegroup_biolab racegroup_manuk racegroup_splendide racegroup_scaraba racegroup_ogh_atk_def racegroup_ogh_hidden racegroup_bio5_swordman_thief racegroup_bio5_acolyte_merchant racegroup_bio5_mage_archer racegroup_bio5_mvp racegroup_clocktower racegroup_thanatos racegroup_faceworm racegroup_hearthunter racegroup_rockridge racegroup_werner_lab racegroup_temple_demon racegroup_illusion_vampire racegroup_malangdo racegroup_ep172alpha racegroup_ep172beta racegroup_ep172bath racegroup_illusion_turtle racegroup_rachel_sanctuary racegroup_illusion_luanda racegroup_illusion_frozen racegroup_illusion_moonlight racegroup_ep16_def racegroup_edda_arunafeltz racegroup_lasagna racegroup_glast_heim_abyss racegroup_destroyed_valkyrie_realm racegroup_encroached_gephenia element element_level walk_speed attack_delay attack_motion damage_motion damage_taken groupid title ai class mode_canmove mode_looter mode_aggressive mode_assist mode_castsensoridle mode_norandomwalk mode_nocast mode_canattack mode_castsensorchase mode_changechase mode_angry mode_changetargetmelee mode_changetargetchase mode_targetweak mode_randomtarget mode_ignoremelee mode_ignoremagic mode_ignoreranged mode_mvp mode_ignoremisc mode_knockbackimmune mode_teleportblock mode_fixeditemdrop mode_detector mode_statusimmune mode_skillimmune mvpdrop1_item mvpdrop1_rate mvpdrop1_option mvpdrop1_index mvpdrop2_item mvpdrop2_rate mvpdrop2_option mvpdrop2_index mvpdrop3_item mvpdrop3_rate mvpdrop3_option mvpdrop3_index drop1_item drop1_rate drop1_nosteal drop1_option drop1_index drop2_item drop2_rate drop2_nosteal drop2_option drop2_index drop3_item drop3_rate drop3_nosteal drop3_option drop3_index drop4_item drop4_rate drop4_nosteal drop4_option drop4_index drop5_item drop5_rate drop5_nosteal drop5_option drop5_index drop6_item drop6_rate drop6_nosteal drop6_option drop6_index drop7_item drop7_rate drop7_nosteal drop7_option drop7_index drop8_item drop8_rate drop8_nosteal drop8_option drop8_index drop9_item drop9_rate drop9_nosteal drop9_option drop9_index drop10_item drop10_rate drop10_nosteal drop10_option drop10_index

* party_id name exp item leader_id leader_char

* world_name account_id char_id char_name purpose assist damagedealer healer tanker minimum_level maximum_level comment created

* pet_id class name account_id char_id level egg_id equip intimate hungry rename_flag incubate autofeed

* char_id quest_id state time count1 count2 count3

* nameid start end amount

* account_id char_id type tick val1 val2 val3 val4

* char_id id lv flag

* account_id char_id skill tick

* homun_id skill tick

* mer_id skill tick

* homun_id id lv

* id account_id nameid amount equip identify refine attribute card0 card1 card2 card3 option_id0 option_val0 option_parm0 option_id1 option_val1 option_parm1 option_id2 option_val2 option_parm2 option_id3 option_val3 option_parm3 option_id4 option_val4 option_parm4 expire_time bound unique_id enchantgrade

* id account_id char_id sex map x y title body_direction head_direction sit autotrade

* vending_id index cartinventory_id amount price

select table acc_reg_num acc_reg_str achievement auction barter bonus_script buyingstores buyingstore_items cart_inventory char charlog char_reg_num char_reg_str clan clan_alliance cp_banlog cp_charprefs cp_cmsnews cp_cmspages cp_cmssettings cp_commands cp_createlog cp_credits cp_emailchange cp_ipbanlog cp_itemdesc cp_itemshop cp_loginlog cp_loginprefs cp_onlinepeak cp_pwchange cp_redeemlog cp_resetpass cp_servicedesk cp_servicedeska cp_servicedeskcat cp_servicedesksettings cp_trusted cp_txnlog cp_xferlog db_roulette elemental friends global_acc_reg_num global_acc_reg_str guild guild_alliance guild_castle guild_expulsion guild_member guild_position guild_skill guild_storage guild_storage_log homunculus hotkey interlog inventory ipbanlist item_db item_db2 item_db2_re item_db_re login mail mail_attachments mapreg market memo mercenary mercenary_owner mob_db2_re mob_db_re party party_bookings pet quest sales sc_data skill skillcooldown skillcooldown_homunculus skillcooldown_mercenary skill_homunculus storage vendings vending_items . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table acc_reg_num acc_reg_str achievement auction barter bonus_script buyingstores buyingstore_items cart_inventory char charlog char_reg_num char_reg_str clan clan_alliance cp_banlog cp_charprefs cp_cmsnews cp_cmspages cp_cmssettings cp_commands cp_createlog cp_credits cp_emailchange cp_ipbanlog cp_itemdesc cp_itemshop cp_loginlog cp_loginprefs cp_onlinepeak cp_pwchange cp_redeemlog cp_resetpass cp_servicedesk cp_servicedeska cp_servicedeskcat cp_servicedesksettings cp_trusted cp_txnlog cp_xferlog db_roulette elemental friends global_acc_reg_num global_acc_reg_str guild guild_alliance guild_castle guild_expulsion guild_member guild_position guild_skill guild_storage guild_storage_log homunculus hotkey interlog inventory ipbanlist item_db item_db2 item_db2_re item_db_re login mail mail_attachments mapreg market memo mercenary mercenary_owner mob_db2_re mob_db_re party party_bookings pet quest sales sc_data skill skillcooldown skillcooldown_homunculus skillcooldown_mercenary skill_homunculus storage vendings vending_items .	select column