* id account function

* id name bindac bexp password salt 2ndpassword salt2 loggedin lastlogin createdat birthday banned banreason gm email macs SessionIPS lastmac birthmac tempban greason Acash mPoints gender SessionIP birthIP points vpoints lastlogon facebook_id access_token password_otp expiration VIP talkban MP Monitored

* id json

* achievementid charid accountid

* id accid bossid lastattempt

* id name leaderid guild1 guild2 guild3 guild4 guild5 rank1 rank2 rank3 rank4 rank5 capacity notice

* uniqueid name skin hair face type gender

* id cid font

* id attackip

* id ownerid itemid count json biddingitem biddingstartcount biddingknife biddingnowcount starttime endtime winner

* id auctionid characterid itemid count json

* replyid threadid postercid timestamp content guildid

* threadid postercid name timestamp icon startpost guildid localthreadid

* id name isDaily isAccount limitTimes isActive json

* id account password username

* id from index time extralog

* id code usedby usedtime name

* id cid activeTime

* account blocktime unblocktime ip active

* bosslogid world characterid bossid lastattempt

* id characterid buddyid pending groupname

* SN Note Price Mark Gashonly Onsale Itemid Priority Package Period Gender Count Meso Unk_1 Unk_2 Unk_3 Class

* serial amount

* id cid name message cgmtime

* id accountid world name level exp str dex luk int hp mp maxhp maxmp meso hpApUsed job skincolor gender fame hair face ap map spawnpoint gm party buddyCapacity createdate guildid guildrank guildcontribution allianceRank monsterbookcover dojo_pts dojoRecord pets sp hsp subcategory dpm rank rankMove jobRank jobRankMove marriageId familyid seniorid junior1 junior2 currentrep totalrep charmessage expression constellation blood month day beans prefix gachexp vipmedal canTalk KillMobCount pee mountid HairAlbum FaceAlbum ExcludeItem fatigue

* id accid worldid characterid position

* id characterid level corelevel str dex int luk watk magic delay expiredate

* id accid worldid charslots

* id characterid offense count lastoffensetime param

* itemid count

* id json

* inventoryequipmentid inventoryitemid upgradeslots level str dex int luk hp mp watk matk wdef mdef acc avoid hands speed jump ViciousHammer itemEXP durability enhance potential1 potential2 potential3 incSkill hpR mpR

* inventoryitemid world characterid accountid packageid itemid inventorytype position quantity owner GM_Log uniqueid flag expiredate type sender

* id acc name

* daylogid accountid dayid lastattempt

* id content reply

* id username amount paymentMethod date

* id world dropperid itemid minimum_quantity maximum_quantity questid chance reborn expiration ignoredropbuff hourdrop

* id world continent dropType itemid minimum_quantity maximum_quantity questid chance comments reborn minlevel maxlevel expiration hourdrop

* id world continent dropType itemid minimum_quantity maximum_quantity questid chance comments

* inventoryequipmentid inventoryitemid upgradeslots level str dex int luk hp mp watk matk wdef mdef acc avoid hands speed jump ViciousHammer itemEXP durability enhance potential1 potential2 potential3 incSkill hpR mpR

* inventoryitemid world characterid accountid packageid itemid inventorytype position quantity owner GM_Log uniqueid flag expiredate type sender equipOnlyId

* PackageId RecieverId SenderName Mesos TimeStamp Checked Type message

* id AccountName Points LastAttempt

* id order_number merchant_name item_name item_price SubPayment payment_expiredate payment_No payment_status accountName

* event_count_id characterid eventname completedtimes

* id characterid itemId uniqueid

* famelogid characterid characterid_to when

* familyid leaderid notice

* id cid name historyscore gametimes

* itemid chance expiration showmsg name

* id name total_points playtime

* id AccountId SelectAns

* id npcId name

* gashaponsid itemid chance min max showmsg name

* id itemid count showmsg

* giftid recipient from message sn uniqueid cashshopid

* gmlogid cid command mapid name

* guildid leader GP logo logoColor name rank1title rank2title rank3title rank4title rank5title capacity logoBG logoBGColor notice signature alliance guildmeso guildpoints guildset

* id guildid skillid level timestamp purchaser

* id guildid mapid expiredate

* PackageId world characterid accountid Mesos time

* PackageId world characterid accountid Mesos time

* inventoryequipmentid inventoryitemid upgradeslots level str dex int luk hp mp watk matk wdef mdef acc avoid hands speed jump ViciousHammer itemEXP durability enhance potential1 potential2 potential3 incSkill hpR mpR

* inventoryitemid world characterid accountid packageid itemid inventorytype position quantity owner GM_Log uniqueid flag expiredate type sender equipOnlyId

* id channel leaderid status members

* trockid characterid mapid

* impid characterid itemid level state closeness fullness

* id player_id skill_id skill_level max_level rank locked

* inventoryequipmentid inventoryitemid upgradeslots level str dex int luk hp mp watk matk wdef mdef acc avoid hands speed jump ViciousHammer itemEXP durability enhance potential1 potential2 potential3 incSkill hpR mpR charmEXP pvpDamage

* inventoryitemid world characterid accountid packageid itemid inventorytype position quantity owner GM_Log uniqueid flag expiredate type sender equipOnlyId

* id inventoryitems_json_id json

* id accountid characterid function

* id characterid equip use setup etc cash

* id code user time ip active

* ipbanid ip

* vid accid ipaddress votetime votetype

* id characterid key type action

* id name userid

* account password logintype ip time active

* id cid name log logtime

* macbanid mac

* macfilterid filter

* id monsterid mapid changemap eventcount congratulation

* id charid cardid level

* id characterid monsterid monsterlevel monsterskill nowused playerkilled

* id monsterid itemid count allattacker damagepercent

* id characterid mountid

* id characterid Level Exp Fatigue

* inventoryequipmentid inventoryitemid upgradeslots level str dex int luk hp mp watk matk wdef mdef acc avoid hands speed jump ViciousHammer itemEXP durability enhance potential1 potential2 potential3 incSkill hpR mpR

* inventoryitemid world characterid accountid packageId itemid inventorytype position quantity owner GM_Log uniqueid flag expiredate type sender equipOnlyId

* inventoryitemid world characterid accountid packageid itemid inventorytype position quantity owner GM_Log uniqueid flag expiredate type sender

* inventoryequipmentid inventoryitemid upgradeslots level str dex int luk hp mp watk matk wdef mdef acc avoid hands speed jump ViciousHammer itemEXP durability enhance potential1 potential2 potential3 hpR mpR

* id characterid itemid

* id tab initprice price nowprice minaddprice bidtimes characterid seller bidder expiration note

* id name function

* id to from message timestamp gift

* id chinese english

* code valid user type item size time

* id accountid itemid count

* id characterid map channel time

* id characterid log

* id cid job time reward

* petid name level closeness fullness seconds flags excluded speed buffskillid canPickUp skillid

* id world name hair face skin x y map charid scriptid foothold dir gender pets

* id npcid equipid equippos charid

* id accid bossid

* id name winner

* questinfoid characterid quest customData

* questrequirementid questid status data

* queststatusid characterid quest status time forfeited customData

* queststatusmobid queststatusid mob count

* reactordropid world reactorid itemid chance questid

* newsid title message date

* trockid characterid mapid

* RewardType itemid chance MinNumber MaxNumber showmsg name

* ringid partnerRingId partnerChrId itemid partnername

* id characterid locationtype map

* serialbanid serial

* id function number

* id type dataid data

* shopitemid shopid itemid price pitch position reqitem reqitemq reqitem2 category reqitemq2 expiration friends friendpoints minlevel maxlevel

* id shopid rank name itemid

* shopid npcid

* id firstid secondid

* signlogid accountid times lasttime

* id characterid position skill1 skill2 skill3 name shout

* id skillid characterid skilllevel masterlevel expiration teachId

* id charid SkillID length StartTime

* id itemid owner exp drop meso skill skilllevel skillposition damage mobspawn vac ignorereflection ignoredebuff freeze slow seal dizzy dark message bossdebuff quickrespawn damagepercent

* id itemid owner exp drop meso watk matk wdef mdef acc avoid jump speed hprate mprate str dex int luk maxdamage damagepercent summondamage petvac

* id type leader timestring time members

* id characterid skillid chosen

* storageid world accountid slots meso

* storageid value world characterid slots meso

* trockid characterid mapid

* characterid sn

* id world dataid f hide fh type cy rx0 rx1 x y mobtime mid

* id itemid key value1 value2

* itemid name msg desc slotMax price wholePrice stateChange flags karma meso monsterBook itemMakeLevel questId scrollReqs consumeItem totalprob incSkill replaceid replacemsg create afterImage option1 option2 option3

* itemid newslotmax

* id itemid itemLevel key value

* id itemid item prob quantity period worldMsg effect

* mapid mapname streetName npcs mobs

* mobid name level maxhp maxmp exp

* id skillid level hp mpcon x y time prop limit spawneffect interval summons ltx lty rbx rby once

* id npc name

* questionset questionid question display answer

* id questid name type intStore applicableJobs uniqueid

* id itemid count period gender job jobEx prop uniqueid

* id quest state uniqueid

* id skillid skillLevel masterLevel uniqueid

* questid name autoStart autoPreComplete viewMedalItem selectedSkillID blocked autoAccept autoComplete

* id questid rank mode property value

* id questid name type stringStore intStoresFirst intStoresSecond

* id itemid

select table accountprizelog accounts acc_json achievements aclog alliances androids attackfonts attackip auction auction_item bbs_replies bbs_threads bear_code bear_code_admin bear_code_log bear_generated_code bear_liedetector blocklogin bosslog buddies cashshop_items cashshop_limit_sell cgmlogs characters character_cards character_coreauras character_slots cheatlog checkitem chr_json csequipment csitems dangerousacc daylog discord donate drop_data drop_data_global drop_data_global_hell dueyequipment dueyitems dueypackages ecpay_donatepoints ecpay_payment event_count extendedslots famelog families fishing_king fishing_rewards fishrankings game_poll_reply gashapons gashapon_items gashapon_items_special gifts gmlog guilds guildskills guildsmap hiredfishing hiredmerch hiredmerchequipment hiredmerchitems htsquads hyperrocklocations imps inner_ability_skills inventoryequipment inventoryitems inventoryitems_json inventoryitems_json_key inventoryslot invitecodedata ipbans ipvotelog keymap linebot loginlog logs macbans macfilters mapnotice monsterbook monsterpet monsterreward mountbank mountdata mtsequipment mtsitems mtstransfer mtstransferequipment mts_cart mts_items nameprizelog notes npctranslate nxcode offlineitem offlinelocations onetimelog parttime pets playernpcs playernpcs_equip prizelog pvprankings questinfo questrequirements queststatus queststatusmobs reactordrops recronews regrocklocations reward_items rings savedlocations serialbans server_set settingdata shopitems shopranks shops sidekicks signlog skillmacros skills skills_cooldowns special_equip special_item speedruns stolen storages storages_exceed trocklocations wishlist wz_customlife wz_itemadddata wz_itemdata wz_itemdata_modify_slotmax wz_itemequipdata wz_itemrewarddata wz_mapdata wz_mobdata wz_mobskilldata wz_npcnamedata wz_oxdata wz_questactdata wz_questactitemdata wz_questactquestdata wz_questactskilldata wz_questdata wz_questpartydata wz_questreqdata wz_rechargeitem . 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 accountprizelog accounts acc_json achievements aclog alliances androids attackfonts attackip auction auction_item bbs_replies bbs_threads bear_code bear_code_admin bear_code_log bear_generated_code bear_liedetector blocklogin bosslog buddies cashshop_items cashshop_limit_sell cgmlogs characters character_cards character_coreauras character_slots cheatlog checkitem chr_json csequipment csitems dangerousacc daylog discord donate drop_data drop_data_global drop_data_global_hell dueyequipment dueyitems dueypackages ecpay_donatepoints ecpay_payment event_count extendedslots famelog families fishing_king fishing_rewards fishrankings game_poll_reply gashapons gashapon_items gashapon_items_special gifts gmlog guilds guildskills guildsmap hiredfishing hiredmerch hiredmerchequipment hiredmerchitems htsquads hyperrocklocations imps inner_ability_skills inventoryequipment inventoryitems inventoryitems_json inventoryitems_json_key inventoryslot invitecodedata ipbans ipvotelog keymap linebot loginlog logs macbans macfilters mapnotice monsterbook monsterpet monsterreward mountbank mountdata mtsequipment mtsitems mtstransfer mtstransferequipment mts_cart mts_items nameprizelog notes npctranslate nxcode offlineitem offlinelocations onetimelog parttime pets playernpcs playernpcs_equip prizelog pvprankings questinfo questrequirements queststatus queststatusmobs reactordrops recronews regrocklocations reward_items rings savedlocations serialbans server_set settingdata shopitems shopranks shops sidekicks signlog skillmacros skills skills_cooldowns special_equip special_item speedruns stolen storages storages_exceed trocklocations wishlist wz_customlife wz_itemadddata wz_itemdata wz_itemdata_modify_slotmax wz_itemequipdata wz_itemrewarddata wz_mapdata wz_mobdata wz_mobskilldata wz_npcnamedata wz_oxdata wz_questactdata wz_questactitemdata wz_questactquestdata wz_questactskilldata wz_questdata wz_questpartydata wz_questreqdata wz_rechargeitem .	select column