Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value 
SELECT * FROM `characters`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
Filter rows:
Sort by key:
Full texts identifier steamname charidentifier group money gold rol xp healthouter healthinner staminaouter staminainner hours LastLogin inventory slots job joblabel meta firstname lastname character_desc gender age nickname skinPlayer compPlayer compTints jobgrade coords status isdead skills walk gunsmith ammo discordid lastjoined afk_points multijobs
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:110000103013d88' AND `characters`.`charidentifier` = 56
 		steam:110000103013d88 Retnirp 56 user 6200.00 0.00 0.00 0 600 100 1065353216 100 0 2025-12-08 {} 40.0 unemployed Unemployed {} Peter Schwarz Wanderer from far away land. Male 29 Peter {"lipsticks_tx_id":0,"ageing_tx_id":3,"NoseDis":0.... {"Skirt":-1,"Gauntlets":-1,"EyeWear":633673784,"Ho... {"Belt":{"543415123":{"tint1":0,"tint0":0,"color":... 0 {"z":119.5106201171875,"heading":209.7637786865234... {"Hunger":954,"Thirst":910,"Metabolism":-140} 0 {"Hunting":{"Level":1,"NextLevel":100,"Exp":0,"Lab... noanim 0.00 {"AMMO_REVOLVER":25} 185308974239842304 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001088a36dd' AND `characters`.`charidentifier` = 55
 		steam:1100001088a36dd ToeyWk 55 user 6500.00 0.00 0.00 0 149 98 1065353216 100 0 2025-12-08 {} 40.0 unemployed Unemployed {} Toey Wk Fuck off Male 40 ToeyWk {"disc_tx_id":0,"NoseAng":0.0,"foundation_palette_... {"Cloak":-1,"Buckle":-1,"Skirt":-1,"Hat":-1,"CoatC... {"Boots":{"-218859683":{"palette":0,"tint0":0,"tin... 0 {"z":118.3648681640625,"heading":93.54330444335938... {"Hunger":980,"Metabolism":-176,"Thirst":878} 0 {"Hunting":{"Level":1,"NextLevel":100,"Exp":0,"Lab... noanim 0.00 {"AMMO_REVOLVER":25,"AMMO_22":69,"AMMO_RIFLE":10} 172398385230381067 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010b1e8beb' AND `characters`.`charidentifier` = 65
 		steam:11000010b1e8beb Jerry West 65 user 86503.00 0.00 0.00 0 500 100 500 100 0 2026-02-16 {} 35.0 unemployed Unemployed {} Tokio Rexxy Legendary Wizard Female 300 TRexs {"MouthD":0.0,"eyebrows_visibility":1,"moles_visib... {"Coat":-1,"Vest":-1,"Spurs":-1,"Skirt":-1,"Spats"... {"Boots":{"-571902733":{"palette":0,"tint2":0,"tin... 0 {"x":-282.4483642578125,"y":786.6065673828125,"z":... {"Thirst":898,"Metabolism":-102,"Hunger":949} 0 {"Fishing":{"NextLevel":100,"MaxLevel":5,"Level":1... noanim 0.00 {} 616650339344580618 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010bece2a9' AND `characters`.`charidentifier` = 6
 		steam:11000010bece2a9 AnuGreenChanWeedRah !! 6 admin 680.59 2280.00 0.00 253 600 100 1065353216 100 0 2026-03-11 {} 35.0 ValSheriff Sheriff {} Test Admin wdwad\
 Female 25 KenNy {"moles_tx_id":0,"blush_palette_id":0,"paintedmask... {"Buckle":0,"Teeth":959712255,"bow":0,"Spats":-727... {"Teeth":{"959712255":[]},"Belt":{"-2083066025":[]... 1 {"y":800.927490234375,"x":-265.8988952636719,"head... {"Metabolism":-10000,"Hunger":809,"Thirst":618} 0 {"Mining":{"NextLevel":100,"Label":"Beginner","Lev... noanim 0.00 {"AMMO_REVOLVER":3} 305456573017358357 [] 74 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010bece2a9' AND `characters`.`charidentifier` = 35
 		steam:11000010bece2a9 Corazon 35 admin 46712.00 0.00 0.00 0 600 100 1065353216 100 0 2026-02-01 {} 35.0 ValSheriff ValSheriff {} KenNy Ynr dWAd
 Male 25 KenNy {"LLiphW":0.0,"foundation_palette_color_primary":0... {"Belt":-1,"Gauntlets":-1,"Accessories":-1,"Teeth"... {"Pant":{"1939930032":{"tint2":0,"palette":0,"tint... 1 {"heading":96.37794494628906,"z":73.123046875,"y":... {"Thirst":862,"Hunger":931,"Metabolism":-1164} 0 {"Fishing":{"Label":"Beginner","Exp":0,"MaxLevel":... noanim 0.00 {} 305456573017358357 [] 74 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010bece2a9' AND `characters`.`charidentifier` = 62
 		steam:11000010bece2a9 AnuGreenChanWeedRah !! 62 user 49710.20 0.00 0.00 0 500 100 500 100 0 2026-02-14 {} 35.0 ValSheriff 1 {} raytier ynr 15151
 Female 25 TestNoTwo {"eyeliner_color_primary":0,"moles_visibility":0,"... {"Gunbelt":1511461630,"Belt":-1,"NeckWear":-1,"Bow... {"Boots":{"-571902733":{"tint2":0,"tint0":0,"palet... 0 {"x":1355.8154296875,"y":-1315.094482421875,"z":76... {"Hunger":664,"Metabolism":-672,"Thirst":334} 0 {"Mining":{"Exp":0,"Label":"Beginner","NextLevel":... noanim 0.00 {} 305456573017358357 [] 74 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010c5aa4d5' AND `characters`.`charidentifier` = 57
 		steam:11000010c5aa4d5 Lumpung 57 user 4100.00 0.00 0.00 0 600 100 1065353216 100 0 2025-12-08 {} 40.0 unemployed Unemployed {} Rook Vandal Butcher Male 58 RookButcher {"NeckW":-0.3,"MouthCLH":0.7,"beardstabble_visibil... {"NeckWear":-1,"CoatClosed":-1,"Glove":1584930588,... {"EyeWear":{"-606842995":{"tint1":117,"index":11,"... 0 {"z":117.6402587890625,"heading":51.02362442016601... {"Hunger":984,"Thirst":968,"Metabolism":-214} 0 {"Hunting":{"Level":1,"NextLevel":100,"Exp":0,"Lab... noanim 0.00 {"AMMO_22":20} 770674837944401962 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001182dd642' AND `characters`.`charidentifier` = 58
 		steam:1100001182dd642 Fang Yang 58 user 10009299.00 1.00 0.00 0 600 100 1065353216 100 0 2025-12-08 {} 40.0 doctor แพทย์ผู้เชี่ยวชาญ {} Fang Yang Fang Yang Male 37 Fang Yang {"eyebrows_visibility":1,"Waist":0,"lipsticks_pale... {"CoatClosed":-1,"GunbeltAccs":-1,"Bow":-1,"Pant":... {"Satchels":[],"Pant":{"1738549663":{"tint2":15,"c... 4 {"y":-569.5516357421875,"x":1243.96484375,"heading... {"Thirst":653,"Hunger":825,"Metabolism":-350} 0 {"Farming":{"Exp":0,"MaxLevel":5,"NextLevel":100,"... noanim 0.00 {"AMMO_REVOLVER":25,"AMMO_22":100} 232375258332659712 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000011d5dd217' AND `characters`.`charidentifier` = 63
 		steam:11000011d5dd217 Call me 911 63 user 200.00 0.00 0.00 0 500 100 500 100 0 2026-02-07 {} 35.0 unemployed Unemployed {} Soey nolol hi
 Female 44 Soey nolol {"EyeBrowW":0.0,"hair_color_primary":0,"JawD":0.0,... {"Badge":-1,"Pant":1803504493,"Gunbelt":1511461630... {"Boots":{"-571902733":{"tint1":0,"palette":0,"tin... 0 {"y":738.6857299804688,"x":-362.0703430175781,"hea... {"Thirst":958,"Hunger":979,"Metabolism":-42} 0 {"Fishing":{"NextLevel":100,"Label":"Beginner","Ex... noanim 0.00 {} 330111230280859649 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001317959c0' AND `characters`.`charidentifier` = 66
 		steam:1100001317959c0 soponwitsodamook11 66 user 100.00 0.00 0.00 0 500 100 500 100 0 2026-02-17 {} 35.0 unemployed Unemployed {} Aodso So Asasda Male 19 AodSo {"EyeLidH":0.0,"EyeBrowH":0.0,"EyeAng":0.0,"MouthC... {"Chap":-2055266779,"Shirt":-1665588256,"CoatClose... {"Chap":{"-2055266779":{"tint2":89,"tint1":0,"pale... 0 {"x":2294.03076171875,"y":-1142.0966796875,"z":42.... {"Metabolism":-270,"Hunger":888,"Thirst":779} 0 {"Fishing":{"Exp":0,"NextLevel":100,"MaxLevel":5,"... noanim 0.00 {} 1250399418817974323 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000013fc687f3' AND `characters`.`charidentifier` = 64
 		steam:11000013fc687f3 . 64 user 200.00 0.00 0.00 0 500 100 500 100 0 2026-02-12 {} 35.0 unemployed Unemployed {} Aroi mak คนพเนจร Male 27 Moo Yong {"foundation_opacity":0,"lipsticks_palette_color_p... {"Holster":-1,"Vest":-1,"GunbeltAccs":-1,"Satchels... {"Boots":{"-218859683":{"tint2":0,"palette":0,"tin... 0 {"z":113.19189453125,"y":255.09890747070313,"x":13... {"Hunger":965,"Thirst":930,"Metabolism":-70} 0 {"Crafting":{"MaxLevel":5,"NextLevel":100,"Level":... noanim 0.00 {} 540890485556903947 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000014901628c' AND `characters`.`charidentifier` = 60
 		steam:11000014901628c otooth1/ttv 60 user 200.00 0.00 0.00 0 500 100 500 100 0 2025-12-27 {} 35.0 unemployed Unemployed {} Maria Dilon none Female 45 Maria {"ChinW":0.0,"NeckD":0.0,"grime_opacity":0,"lipsti... {"Hat":-1,"Chap":-1,"Cloak":-1,"Boots":-571902733,... {"Shirt":{"-599669674":{"palette":0,"tint0":0,"tin... 0 {"y":620.1494750976563,"x":-172.5230712890625,"hea... {"Thirst":1000,"Metabolism":0,"Hunger":1000} 0 {"Fishing":{"Level":1,"Label":"Beginner","NextLeve... noanim 0.00 {} 523786497439301641 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:110000154a6c454' AND `characters`.`charidentifier` = 67
 		steam:110000154a6c454 Jon Hot Sauce 67 user 200.00 0.00 0.00 0 500 100 500 100 0 2026-02-18 {} 35.0 unemployed Unemployed {} Jon Hot Good Male 50 Jon Hot Sauce {"shadows_palette_color_primary":0,"NoseS":0.0,"To... {"Teeth":712446626,"NeckTies":-1,"Spats":567040413... {"Dress":[],"Bracelet":[],"Spats":{"567040413":{"p... 0 {"x":-4360.5361328125,"heading":0.0,"z":20.9560546... {"Hunger":962,"Thirst":930,"Metabolism":-76} 0 {"Crafting":{"MaxLevel":5,"Label":"Beginner","Leve... MP_Style_Veteran 0.00 {} 1356878317571276833 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000015ba23145' AND `characters`.`charidentifier` = 53
 		steam:11000015ba23145 Dreammy2001[TH] 53 user 18357.00 0.00 0.00 34 600 100 1065353216 100 0 2025-11-03 {} 35.0 unemployed Unemployed {} Saman Intarachote Saman Intarachote Male 25 Saman {"complex_opacity":0,"MouthCRD":0.0,"scars_tx_id":... {"Satchels":-1,"Gunbelt":-1435225965,"RingLh":-133... {"Loadouts":{"1723497063":{"index":12,"tint1":15,"... 0 {"z":116.6629638671875,"heading":107.7165374755859... {"Hunger":661,"Metabolism":4544,"Thirst":690} 0 {"Crafting":{"Label":"Beginner","Level":1,"Exp":0,... noanim 0.00 {"AMMO_ARROW":25} 1098465777646043166 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 42
 		steam:1100001673b2cf6 WIN 42 user 0.00 5.00 0.00 157 549 100 1065353215 80 0 2026-02-05 {} 35.0 headdoctor Head Doctor {} Tikket Hole Running Male 25 Tikket {"EyeD":0.0,"NoseH":0.5,"EyeBrowD":0.0,"ChinW":0.0... {"Glove":0,"Dress":0,"Bracelet":97914417,"Chap":0,... {"RingLh":{"538207337":[]},"Bracelet":{"97914417":... 1 {"x":489.0725402832031,"heading":51.02362442016601... {"Metabolism":-10000,"Hunger":922,"Thirst":844} 0 {"Fishing":{"MaxLevel":5,"Label":"Beginner","Exp":... MP_Style_EasyRider 0.00 {"AMMO_ARROW":0,"AMMO_RIFLE":100,"AMMO_REPEATER":1... 439320304569942017 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 51
 		steam:1100001673b2cf6 Tikket 51 user 5719.00 1.00 0.00 12 589 100 1045206927 0 0 2025-11-03 {} 35.0 police {} WILSON HOLE ผู้พิทักษ์เมือง Male 30 WILSON {"MouthCRD":0.0,"hair_color_primary":17129595,"Ear... {"Glove":-495336667,"Cloak":-1,"Poncho":-1,"Skirt"... {"Glove":{"-495336667":{"tint1":114,"index":3,"col... 1 {"z":51.7237548828125,"heading":226.77166748046876... {"Thirst":895,"Hunger":174,"Metabolism":-3058} 0 {"Crafting":{"Label":"Beginner","Level":1,"Exp":0,... noanim 0.00 {"AMMO_REVOLVER":12,"AMMO_ARROW":0} 439320304569942017 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 52
 		steam:1100001673b2cf6 Tikket 52 user 5286.00 0.00 0.00 0 500 100 500 100 0 2025-11-02 {} 35.0 unemployed Unemployed {} TEST ECONAMY TEST
 Female 22 TEST ECONAMY {"CheekBonesD":0.0,"EyeD":0.0,"CalvesS":0.0,"ChinW... {"Gauntlets":-1,"Cloak":-1,"Chap":-1,"Boots":-5719... {"Shirt":{"-599669674":{"tint2":0,"tint0":0,"palet... 0 {"y":785.88134765625,"z":118.4827880859375,"headin... {"Thirst":95,"Hunger":439,"Metabolism":-916} 0 {"Farming":{"MaxLevel":5,"Label":"Beginner","NextL... noanim 0.00 {} 439320304569942017 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 54
 		steam:1100001673b2cf6 Tikket 54 user 601728.00 1.00 0.00 0 556 100 987786404 0 0 2025-11-03 {} 40.0 unemployed Unemployed {} CASON HOLE RIN
 Male 25 CASON {"EyeDis":0.0,"lipsticks_palette_color_tertiary":0... {"Boots":-218859683,"NeckTies":-1,"Buckle":-1,"Tee... {"Boots":{"-218859683":{"tint1":0,"palette":0,"tin... 0 {"z":116.96630859375,"heading":308.97637939453127,... {"Metabolism":2120,"Thirst":768,"Hunger":260} 0 {"Crafting":{"Label":"Beginner","Level":1,"Exp":0,... noanim 0.00 {} 439320304569942017 [] 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000016abeb0c7' AND `characters`.`charidentifier` = 61
 		steam:11000016abeb0c7 asd 61 user 200.00 0.00 0.00 0 500 100 500 100 0 2025-12-28 {} 35.0 unemployed Unemployed {} Johnson Del none Male 18 none {"scars_opacity":0,"ArmsS":0.0,"Torso":-162963160,... {"Dress":-1,"Bracelet":-1,"Cloak":-1,"Mask":-1,"Ch... {"Shirt":{"-1665588256":{"palette":0,"tint0":0,"ti... 0 {"y":650.3868408203125,"x":-235.2131805419922,"hea... {"Metabolism":-42,"Thirst":958,"Hunger":979} 0 {"Fishing":{"Level":1,"Label":"Beginner","NextLeve... noanim 0.00 {} 1028685967999119411 [] 0 []
Edit Edit Copy Copy Delete Delete
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:110000172e4a9da' AND `characters`.`charidentifier` = 59
 		steam:110000172e4a9da Jefferyy 59 user 10300.00 1.00 0.00 0 600 100 1065353216 100 0 2025-12-14 {} 40.0 unemployed Unemployed {} Jeffery Bloodboyz none Male 20 Jeffery {"foundation_palette_color_tertiary":0,"Legs":1741... {"Boots":-676537530,"GunbeltAccs":-1,"Poncho":-1,"... {"Cloak":{"-1081614863":{"tint1":0,"palette":0,"ti... 0 {"x":-279.75823974609377,"heading":221.10237121582... {"Thirst":756,"Metabolism":-248,"Hunger":876} 0 {"Fishing":{"Level":1,"Exp":0,"Label":"Beginner","... noanim 0.00 {} 1348435623790514206 [] 0 NULL
With selected: With selected:
|
|
|
Filter rows:
Sort by key:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query