25.02.2015, 21:48
(
Последний раз редактировалось PowerPC603; 26.02.2015 в 07:55.
)
I found my required query after lots of trial and error using the mysql command console:
This query lists all my columns from the first table (vehicleinfo) and adds to each row the group_concat-ed components from the second table (vehicleinfocomponents), and inserts "NULL" where a vehiclemodel doesn't have any components.
This was the hardest part, as previous queries always listed the proper data, but skipped all results which didn't have components, so I was missing a few rows in my result.
This is actually the exact same result as using "select * from vehicleinfo" from my table before the column with multiple components was moved out of there to create a new table with all components on a separate row.
pawn Код:
select a.*, (select group_concat(b.component) from vehicleinfocomponents b where b.model = a.model) as components from vehicleinfo a;
This was the hardest part, as previous queries always listed the proper data, but skipped all results which didn't have components, so I was missing a few rows in my result.
Код:
+-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+ | ID | Name | Class | Model | Price | MaxFuel | Consumption | RefuelTime | RefuelLitersPerStep | MaxPassengers | MaxCargo | AccessLevels | Disabled | components | +-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+ | 0 | Landstalker | 7 | 400 | 50000 | 72 | 0.08 | 25 | 0.72 | 3 | 0 | 0 | 0 | 1008,1009,1010,1013,1018,1019,1020,1021,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 1 | Bravura | 11 | 401 | 50000 | 51 | 0.0566667 | 20 | 0.6375 | 1 | 0 | 0 | 0 | 1001,1003,1004,1005,1006,1007,1008,1009,1010,1013,1019,1020,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 2 | Buffalo | 12 | 402 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 3 | Linerunner | 5 | 403 | 50000 | 757 | 0.841111 | 25 | 7.57 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 4 | Perenniel | 13 | 404 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1000,1002,1007,1008,1009,1010,1013,1016,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 5 | Sentinel | 11 | 405 | 50000 | 90 | 0.1 | 20 | 1.125 | 3 | 0 | 0 | 0 | 1000,1001,1008,1009,1010,1014,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 6 | Dumper | 15 | 406 | 50000 | 480 | 0.533333 | 25 | 4.8 | 1 | 0 | 0 | 0 | NULL | | 7 | Firetruck | 9 | 407 | 50000 | 1893 | 2.10333 | 30 | 15.775 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 8 | Trashmaster | 5 | 408 | 50000 | 189 | 0.21 | 25 | 1.89 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 9 | Stretch | 15 | 409 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 10 | Manana | 11 | 410 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1013,1019,1020,1021,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 11 | Infernus | 12 | 411 | 50000 | 70 | 0.077778 | 20 | 0.875 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 12 | Voodoo | 6 | 412 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1076,1078,1086,1087,1097,1098 | | 13 | Pony | 5 | 413 | 50000 | 125 | 0.138889 | 25 | 1.25 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 14 | Mule | 5 | 414 | 50000 | 132 | 0.146667 | 25 | 1.32 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 15 | Cheetah | 12 | 415 | 50000 | 110 | 0.122222 | 20 | 1.375 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1018,1019,1023,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 16 | Ambulance | 9 | 416 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 17 | Leviathan | 4 | 417 | 50000 | 1074 | 1.19333 | 30 | 8.95 | 0 | 0 | 0 | 0 | NULL | | 18 | Moonbeam | 13 | 418 | 50000 | 102 | 0.113333 | 20 | 1.275 | 3 | 0 | 0 | 0 | 1002,1006,1008,1009,1010,1016,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 19 | Esperanto | 11 | 419 | 50000 | 102 | 0.113333 | 20 | 1.275 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 20 | Taxi | 9 | 420 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 3 | 0 | 0 | 0 | 1001,1003,1004,1005,1008,1009,1010,1019,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 21 | Washington | 11 | 421 | 50000 | 80 | 0.0888889 | 20 | 1 | 3 | 0 | 0 | 0 | 1000,1008,1009,1010,1014,1016,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 22 | Bobcat | 5 | 422 | 50000 | 65 | 0.0722222 | 25 | 0.65 | 1 | 0 | 0 | 0 | 1007,1008,1009,1010,1013,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 23 | Mr Whoopee | 15 | 423 | 50000 | 102 | 0.113333 | 25 | 1.02 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 24 | BF Injection | 7 | 424 | 50000 | 56 | 0.0622222 | 25 | 0.56 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 25 | Hunter | 4 | 425 | 50000 | 1421 | 1.57889 | 30 | 11.8417 | 0 | 0 | 0 | 0 | NULL | | 26 | Premier | 11 | 426 | 50000 | 87 | 0.0966667 | 20 | 1.0875 | 3 | 0 | 0 | 0 | 1001,1003,1004,1005,1006,1008,1009,1010,1019,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 27 | Enforcer | 9 | 427 | 50000 | 98 | 0.108889 | 25 | 0.98 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 28 | Securicar | 15 | 428 | 50000 | 98 | 0.108889 | 25 | 0.98 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 29 | Banshee | 12 | 429 | 50000 | 83 | 0.0922222 | 20 | 1.0375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 30 | Predator | 2 | 430 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 31 | Bus | 9 | 431 | 50000 | 545 | 0.605556 | 30 | 4.54167 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 32 | Rhino | 9 | 432 | 50000 | 1893 | 2.10333 | 30 | 15.775 | 0 | 0 | 0 | 0 | NULL | | 33 | Barracks | 9 | 433 | 50000 | 306 | 0.34 | 30 | 2.55 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 34 | Hotknife | 15 | 434 | 50000 | 41 | 0.0455556 | 25 | 0.41 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 35 | Cargo Trailer | 14 | 435 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 36 | Previon | 11 | 436 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1001,1003,1006,1007,1008,1009,1010,1013,1019,1020,1021,1022,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 37 | Coach | 9 | 437 | 50000 | 560 | 0.311111 | 30 | 4.66667 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 38 | Cabbie | 9 | 438 | 50000 | 67 | 0.0744444 | 25 | 0.67 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 39 | Stallion | 3 | 439 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1013,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 40 | Rumpo | 5 | 440 | 50000 | 100 | 0.11 | 25 | 1 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 41 | RC Bandit | 10 | 441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 42 | Romero | 15 | 442 | 50000 | 102 | 0.113333 | 25 | 1.02 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 43 | Packer | 5 | 443 | 50000 | 378 | 0.42 | 25 | 3.78 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 44 | Monster | 7 | 444 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | NULL | | 45 | Admiral | 11 | 445 | 50000 | 65 | 0.0722222 | 20 | 0.8125 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 46 | Squallo | 2 | 446 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 47 | Seasparrow | 4 | 447 | 50000 | 230 | 0.255556 | 30 | 1.91667 | 1 | 0 | 0 | 0 | NULL | | 48 | Pizzaboy | 1 | 448 | 10000 | 9 | 0.01 | 10 | 0.225 | 0 | 0 | 0 | 0 | NULL | | 49 | Tram | 16 | 449 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 50 | Ore Trailer | 14 | 450 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 51 | Turismo | 12 | 451 | 50000 | 120 | 0.133333 | 20 | 1.5 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 52 | Speeder | 2 | 452 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 53 | Reefer | 2 | 453 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 54 | Tropic | 2 | 454 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 55 | Flatbed | 5 | 455 | 50000 | 306 | 0.34 | 25 | 3.06 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 56 | Yankee | 5 | 456 | 50000 | 189 | 0.21 | 25 | 1.89 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 57 | Caddy | 15 | 457 | 50000 | 22 | 0.0244444 | 15 | 0.366667 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 58 | Solair | 13 | 458 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 59 | Berkley's RC Van | 5 | 459 | 50000 | 100 | 0.11 | 25 | 1 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 60 | Skimmer | 8 | 460 | 50000 | 151 | 0.167778 | 30 | 1.25833 | 1 | 0 | 0 | 0 | NULL | | 61 | PCJ-600 | 1 | 461 | 50000 | 20 | 0.0222222 | 10 | 0.5 | 1 | 0 | 0 | 0 | NULL | | 62 | Faggio | 1 | 462 | 10000 | 9 | 0.01 | 10 | 0.225 | 0 | 0 | 0 | 0 | NULL | | 63 | Freeway | 1 | 463 | 50000 | 23 | 0.0255556 | 10 | 0.575 | 0 | 0 | 0 | 0 | NULL | | 64 | RC Baron | 10 | 464 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 65 | RC Raider | 10 | 465 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 66 | Glendale | 11 | 466 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 67 | Oceanic | 11 | 467 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 68 | Sanchez | 1 | 468 | 50000 | 6 | 0.0075 | 10 | 0.15 | 0 | 0 | 0 | 0 | NULL | | 69 | Sparrow | 4 | 469 | 50000 | 230 | 0.255556 | 30 | 1.91667 | 1 | 0 | 0 | 0 | NULL | | 70 | Patriot | 7 | 470 | 50000 | 95 | 0.105556 | 25 | 0.95 | 3 | 0 | 0 | 0 | 1008,1009,1010 | | 71 | Quad | 1 | 471 | 50000 | 10 | 0.0111111 | 10 | 0.25 | 0 | 0 | 0 | 0 | NULL | | 72 | Coastguard | 2 | 472 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 73 | Dinghy | 2 | 473 | 50000 | 181 | 0.201111 | 15 | 3.01667 | 0 | 0 | 0 | 0 | NULL | | 74 | Hermes | 11 | 474 | 50000 | 61 | 0.0677778 | 20 | 0.7625 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 75 | Sabre | 12 | 475 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 76 | Rustler | 8 | 476 | 50000 | 507 | 0.563333 | 30 | 4.225 | 0 | 0 | 0 | 0 | NULL | | 77 | ZR-350 | 12 | 477 | 50000 | 77 | 0.0855556 | 20 | 0.9625 | 1 | 0 | 0 | 0 | 1006,1007,1008,1009,1010,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 78 | Walton | 5 | 478 | 50000 | 60 | 0.0666667 | 25 | 0.6 | 1 | 0 | 0 | 0 | 1004,1005,1008,1009,1010,1012,1013,1020,1021,1022,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 79 | Regina | 13 | 479 | 50000 | 95 | 0.105556 | 20 | 1.1875 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 80 | Comet | 3 | 480 | 50000 | 80 | 0.0888889 | 20 | 1 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 81 | BMX | 1 | 481 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 82 | Burrito | 5 | 482 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 83 | Camper | 15 | 483 | 50000 | 69 | 0.0766667 | 25 | 0.69 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 84 | Marquis | 2 | 484 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 85 | Baggage | 15 | 485 | 50000 | 50 | 0.0555556 | 25 | 0.5 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 86 | Dozer | 15 | 486 | 50000 | 793 | 0.881111 | 25 | 7.93 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 87 | Maverick | 4 | 487 | 50000 | 345 | 0.383333 | 30 | 2.875 | 3 | 0 | 0 | 0 | NULL | | 88 | SAN News Maverick | 4 | 488 | 50000 | 345 | 0.383333 | 30 | 2.875 | 3 | 0 | 0 | 0 | NULL | | 89 | Rancher 1 | 7 | 489 | 50000 | 94 | 0.104444 | 25 | 0.94 | 1 | 0 | 0 | 0 | 1000,1002,1004,1005,1006,1008,1009,1010,1013,1016,1018,1019,1020,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 90 | FBI Rancher | 9 | 490 | 50000 | 117 | 0.13 | 25 | 1.17 | 3 | 0 | 0 | 0 | 1008,1009,1010 | | 91 | Virgo | 11 | 491 | 50000 | 95 | 0.105556 | 20 | 1.1875 | 1 | 0 | 0 | 0 | 1003,1007,1008,1009,1010,1014,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 92 | Greenwood | 11 | 492 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 3 | 0 | 0 | 0 | 1000,1004,1005,1006,1008,1009,1010,1016,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 93 | Jetmax | 2 | 493 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 94 | Hotring Racer 1 | 12 | 494 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 95 | Sandking | 7 | 495 | 50000 | 118 | 0.131111 | 25 | 1.18 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 96 | Blista Compact | 12 | 496 | 50000 | 45 | 0.05 | 20 | 0.5625 | 1 | 0 | 0 | 0 | 1001,1002,1003,1006,1007,1008,1009,1010,1011,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143 | | 97 | Police Maverick | 4 | 497 | 50000 | 345 | 0.383333 | 30 | 2.875 | 3 | 0 | 0 | 0 | NULL | | 98 | Boxville 1 | 5 | 498 | 50000 | 102 | 0.113333 | 25 | 1.02 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 99 | Benson | 5 | 499 | 50000 | 68 | 0.0755556 | 25 | 0.68 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 100 | Mesa | 7 | 500 | 50000 | 72 | 0.08 | 25 | 0.72 | 1 | 0 | 0 | 0 | 1008,1009,1010,1013,1019,1020,1021,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 101 | RC Goblin | 10 | 501 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 102 | Hotring Racer 2 | 12 | 502 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 103 | Hotring Racer 3 | 12 | 503 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 104 | Bloodring Banger | 11 | 504 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 105 | Rancher 2 | 7 | 505 | 50000 | 94 | 0.104444 | 25 | 0.94 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 106 | Super GT | 12 | 506 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 107 | Elegant | 11 | 507 | 50000 | 87 | 0.0966667 | 20 | 1.0875 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 108 | Journey | 15 | 508 | 50000 | 117 | 0.13 | 25 | 1.17 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 109 | Bike | 1 | 509 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 110 | Mountain Bike | 1 | 510 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 111 | Beagle | 8 | 511 | 50000 | 480 | 0.533333 | 30 | 4 | 0 | 0 | 0 | 0 | NULL | | 112 | Cropduster | 8 | 512 | 50000 | 330 | 0.366667 | 30 | 2.75 | 0 | 0 | 0 | 0 | NULL | | 113 | Stuntplane | 8 | 513 | 50000 | 72 | 0.08 | 30 | 0.6 | 0 | 0 | 0 | 0 | NULL | | 114 | Tanker | 5 | 514 | 50000 | 250 | 0.277778 | 25 | 2.5 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 115 | Roadtrain | 5 | 515 | 50000 | 250 | 0.277778 | 25 | 2.5 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 116 | Nebula | 11 | 516 | 50000 | 70 | 0.0777778 | 20 | 0.875 | 3 | 0 | 0 | 0 | 1000,1002,1004,1007,1008,1009,1010,1015,1016,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 117 | Majestic | 11 | 517 | 50000 | 56 | 0.0622222 | 20 | 0.7 | 1 | 0 | 0 | 0 | 1002,1003,1007,1008,1009,1010,1016,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 118 | Buccaneer | 11 | 518 | 50000 | 72 | 0.08 | 20 | 0.9 | 1 | 0 | 0 | 0 | 1001,1003,1005,1006,1007,1008,1009,1010,1013,1018,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 119 | Shamal | 8 | 519 | 50000 | 2755 | 1.53056 | 45 | 15.3056 | 0 | 0 | 0 | 0 | NULL | | 120 | Hydra | 8 | 520 | 50000 | 4319 | 4.79889 | 45 | 23.9944 | 0 | 0 | 0 | 0 | NULL | | 121 | FCR-900 | 1 | 521 | 50000 | 18 | 0.02 | 10 | 0.45 | 0 | 0 | 0 | 0 | NULL | | 122 | NRG-500 | 1 | 522 | 50000 | 13 | 0.0144444 | 10 | 0.325 | 1 | 0 | 0 | 0 | NULL | | 123 | HPV1000 | 1 | 523 | 50000 | 17 | 0.0188889 | 10 | 0.425 | 0 | 0 | 0 | 0 | NULL | | 124 | Cement Truck | 5 | 524 | 50000 | 227 | 0.252222 | 25 | 2.27 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 125 | Towtruck | 15 | 525 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 126 | Fortune | 11 | 526 | 50000 | 72 | 0.08 | 20 | 0.9 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 127 | Cadrona | 11 | 527 | 50000 | 51 | 0.0566667 | 20 | 0.6375 | 1 | 0 | 0 | 0 | 1001,1007,1008,1009,1010,1014,1015,1018,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 128 | FBI Truck | 9 | 528 | 50000 | 121 | 0.134444 | 25 | 1.21 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 129 | Willard | 11 | 529 | 50000 | 61 | 0.0677778 | 20 | 0.7625 | 3 | 0 | 0 | 0 | 1001,1003,1006,1007,1008,1009,1010,1011,1012,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 130 | Forklift | 15 | 530 | 50000 | 53 | 0.0588889 | 25 | 0.53 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 131 | Tractor | 5 | 531 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 132 | Combine Harvester | 15 | 532 | 50000 | 1000 | 1.11111 | 25 | 10 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 133 | Feltzer | 3 | 533 | 50000 | 90 | 0.1 | 20 | 1.125 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 134 | Remington | 6 | 534 | 50000 | 91 | 0.101111 | 20 | 1.1375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1100,1106,1122,1123,1125,1126,1127,1178,1179,1180,1185 | | 135 | Slamvan | 6 | 535 | 50000 | 151 | 0.167778 | 20 | 1.8875 | 1 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1109,1110,1113,1114,1115,1116,1117,1118,1119 | | 136 | Blade | 6 | 536 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 1 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1097,1098,1103,1104,1105,1108,1128,1181,1182,1183,1184 | | 137 | Freight train | 16 | 537 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 138 | Brownstreak | 16 | 538 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 139 | Vortex | 15 | 539 | 50000 | 100 | 0.111111 | 25 | 1 | 0 | 0 | 0 | 0 | NULL | | 140 | Vincent | 11 | 540 | 50000 | 80 | 0.0888889 | 20 | 1 | 3 | 0 | 0 | 0 | 1001,1004,1006,1007,1008,1009,1010,1018,1019,1020,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 141 | Bullet | 12 | 541 | 50000 | 85 | 0.0944444 | 20 | 1.0625 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 142 | Clover | 11 | 542 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1014,1015,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1145 | | 143 | Sadler | 5 | 543 | 50000 | 72 | 0.08 | 25 | 0.72 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 144 | Firetruck LA | 9 | 544 | 50000 | 1893 | 2.10333 | 25 | 18.93 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 145 | Hustler | 15 | 545 | 50000 | 53 | 0.0588889 | 25 | 0.53 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 146 | Intruder | 11 | 546 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1001,1002,1004,1006,1007,1008,1009,1010,1018,1019,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 147 | Primo | 11 | 547 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1000,1003,1008,1009,1010,1016,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143 | | 148 | Cargobob | 4 | 548 | 50000 | 1400 | 1.55556 | 30 | 11.6667 | 0 | 0 | 0 | 0 | NULL | | 149 | Tampa | 11 | 549 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1011,1012,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 150 | Sunrise | 11 | 550 | 50000 | 64 | 0.0711111 | 20 | 0.8 | 3 | 0 | 0 | 0 | 1001,1003,1004,1005,1006,1008,1009,1010,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 151 | Merit | 11 | 551 | 50000 | 70 | 0.0777778 | 20 | 0.875 | 3 | 0 | 0 | 0 | 1002,1003,1005,1006,1008,1009,1010,1016,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 152 | Utility Van | 5 | 552 | 50000 | 94 | 0.104444 | 25 | 0.94 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 153 | Nevada | 8 | 553 | 50000 | 3112 | 1.72889 | 45 | 17.2889 | 0 | 0 | 0 | 0 | NULL | | 154 | Yosemite | 5 | 554 | 50000 | 151 | 0.167778 | 25 | 1.51 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 155 | Windsor | 3 | 555 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 156 | Monster A | 7 | 556 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | NULL | | 157 | Monster B | 7 | 557 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | NULL | | 158 | Uranus | 12 | 558 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1008,1009,1010,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1088,1089,1090,1091,1092,1093,1163,1164,1165,1166,1167,1168 | | 159 | Jester | 12 | 559 | 50000 | 70 | 0.0777778 | 20 | 0.875 | 1 | 0 | 0 | 0 | 1008,1009,1010,1065,1066,1067,1068,1069,1070,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1087,1158,1159,1160,1161,1162,1173 | | 160 | Sultan | 11 | 560 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 0 | 0 | 0 | 0 | 1008,1009,1010,1026,1028,1029,1031,1032,1033,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1138,1139,1140,1141,1169,1170 | | 161 | Stratum | 13 | 561 | 50000 | 64 | 0.0711111 | 20 | 0.8 | 0 | 0 | 0 | 0 | 1008,1009,1010,1055,1056,1057,1058,1059,1060,1061,1064,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1154,1155,1156,1157 | | 162 | Elegy | 11 | 562 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1008,1009,1010,1034,1035,1036,1037,1038,1039,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1146,1147,1148,1149,1171,1172 | | 163 | Raindance | 4 | 563 | 50000 | 1360 | 1.51111 | 30 | 11.3333 | 0 | 0 | 0 | 0 | NULL | | 164 | RC Tiger | 10 | 564 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 165 | Flash | 12 | 565 | 50000 | 50 | 0.0555556 | 20 | 0.625 | 0 | 0 | 0 | 0 | 1008,1009,1010,1045,1046,1047,1048,1049,1050,1053,1054,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1150,1151,1152,1153 | | 166 | Tahoma | 6 | 566 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 0 | 0 | 0 | 0 | 1008,1009,1010,1076,1078,1086,1087,1097,1098 | | 167 | Savanna | 6 | 567 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1129,1130,1131,1133,1186,1187,1188,1189 | | 168 | Bandito | 7 | 568 | 50000 | 80 | 0.0888889 | 25 | 0.8 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 169 | Freight flat trailer | 16 | 569 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 170 | Streak trailer | 16 | 570 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 171 | Kart | 15 | 571 | 50000 | 4 | 0.00444444 | 10 | 0.1 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 172 | Mower | 15 | 572 | 50000 | 5 | 0.00555556 | 10 | 0.125 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 173 | Dune | 7 | 573 | 50000 | 897 | 0.996667 | 25 | 8.97 | 0 | 0 | 0 | 0 | NULL | | 174 | Sweeper | 15 | 574 | 50000 | 189 | 0.21 | 25 | 1.89 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 175 | Broadway | 6 | 575 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1042,1043,1044,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1174,1175,1176,1177 | | 176 | Tornado | 6 | 576 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1134,1135,1136,1190,1191,1192,1193 | | 177 | AT400 | 8 | 577 | 50000 | 20104 | 7.44593 | 60 | 83.7667 | 0 | 0 | 0 | 0 | NULL | | 178 | DFT-30 | 5 | 578 | 50000 | 125 | 0.138889 | 25 | 1.25 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 179 | Huntley | 7 | 579 | 50000 | 82 | 0.0911111 | 25 | 0.82 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 180 | Stafford | 11 | 580 | 50000 | 109 | 0.121111 | 20 | 1.3625 | 0 | 0 | 0 | 0 | 1001,1006,1007,1008,1009,1010,1018,1020,1023,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 181 | BF-400 | 1 | 581 | 50000 | 15 | 0.0166667 | 10 | 0.375 | 0 | 0 | 0 | 0 | NULL | | 182 | Newsvan | 5 | 582 | 50000 | 91 | 0.101111 | 25 | 0.91 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 183 | Tug | 15 | 583 | 50000 | 151 | 0.167778 | 25 | 1.51 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 184 | Fluids Trailer | 14 | 584 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 185 | Emperor | 11 | 585 | 50000 | 85 | 0.0944444 | 20 | 1.0625 | 0 | 0 | 0 | 0 | 1001,1003,1006,1007,1008,1009,1010,1013,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 186 | Wayfarer | 1 | 586 | 50000 | 25 | 0.0277778 | 10 | 0.625 | 0 | 0 | 0 | 0 | NULL | | 187 | Euros | 12 | 587 | 50000 | 72 | 0.08 | 20 | 0.9 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 188 | Hotdog | 15 | 588 | 50000 | 79 | 0.0877778 | 25 | 0.79 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 189 | Club | 12 | 589 | 50000 | 55 | 0.0611111 | 20 | 0.6875 | 0 | 0 | 0 | 0 | 1000,1004,1005,1006,1007,1008,1009,1010,1013,1016,1018,1020,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1145 | | 190 | Freight box trailer | 16 | 590 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 191 | Article Trailer | 14 | 591 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 192 | Andromada | 8 | 592 | 50000 | 90849 | 33.6478 | 60 | 378.538 | 0 | 0 | 0 | 0 | NULL | | 193 | Dodo | 8 | 593 | 50000 | 85 | 0.0944444 | 30 | 0.708333 | 0 | 0 | 0 | 0 | NULL | | 194 | RC Cam | 10 | 594 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 195 | Launch | 2 | 595 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 196 | Police Car (LSPD) | 9 | 596 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 197 | Police Car (SFPD) | 9 | 597 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 198 | Police Car (LVPD) | 9 | 598 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 199 | Police Ranger | 9 | 599 | 50000 | 117 | 0.13 | 25 | 1.17 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 200 | Picador | 5 | 600 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 0 | 0 | 0 | 0 | 1004,1005,1006,1007,1008,1009,1010,1013,1018,1020,1022,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 201 | S.W.A.T. | 9 | 601 | 50000 | 378 | 0.42 | 30 | 3.15 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 202 | Alpha | 12 | 602 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 203 | Phoenix | 12 | 603 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 0 | 0 | 0 | 0 | 1001,1006,1007,1008,1009,1010,1018,1019,1020,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 204 | Glendale Shit | 11 | 604 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 205 | Sadler Shit | 5 | 605 | 50000 | 72 | 0.08 | 25 | 0.72 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 206 | Baggage Trailer A | 14 | 606 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 207 | Baggage Trailer B | 14 | 607 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 208 | Tug Stairs Trailer | 14 | 608 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 209 | Boxville 2 | 5 | 609 | 50000 | 102 | 0.113333 | 25 | 1.02 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 210 | Farm Trailer | 14 | 610 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 211 | Utility Trailer | 14 | 611 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | +-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+