gestaooficinas.ddns.net / 127.0.0.1 / plates_db / plate_info

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (229 total, Query took 0.0016 seconds.)

SELECT * FROM `plate_info`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	plate	brand	model	version	original_color	fuel_type	vin	power_cv	power_kw	engine_cc	traction	co2_emissions	origin_country	registration_date	iuc_2026	iuc_category	vehicle_category	segment	production_year	owner_type	owner_entity	raw_json	created_at	updated_at
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 1	1	61-47-XQ	RENAULT	MEGANE II Combi	1.5 dCi	Preto	GASÓLEO	NULL	101	74	1461	NULL	122	Nacional	6/2004	23.04€	A	Ligeiro Passageiros	Ligeiro Passageiros	2004 -	Proprietário	Particular	{"Marca":"RENAULT","Modelo":"MEGANE II Combi","Cor...	2026-04-09 16:22:10	2026-04-09 16:22:10
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 2	2	95-05-NP	PEUGEOT	206 Hatchback	1.1 i	NULL	GASOLINA	NULL	60	44	1124	NULL	154	Nacional	06/1999	39.95€	A	Ligeiro Passageiros	Ligeiro Passageiros	1998 -	Proprietário	Particular	{"Marca":"PEUGEOT","Modelo":"206 Hatchback","Combu...	2026-04-09 17:17:54	2026-04-09 17:17:54
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 3	3	76-FG-33	AUDI	A3 Sportback	1.9 TDI	Cinza	GASÓLEO	WAUZZZ8P18A117480	105	77	1896	Tração dianteira	135	Nacional	2/2008	256.35€	B	Ligeiro Passageiros	Hatchback	2004 -	Proprietário	Particular	{"Marca":"AUDI","Modelo":"A3 Sportback","Cor Origi...	2026-04-09 17:18:51	2026-04-09 17:18:51
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 4	4	EE-85-63	PEUGEOT	204 Break 1.1 Grand Luxe [05.1969 - 10.1977]	NULL	NULL	GASOLINA	J584431	NULL	NULL	1130	NULL	NULL	Nacional	01/1972	0.01€	X	Ligeiro Misto	NULL	NULL	Proprietário	Particular	{"Marca":"PEUGEOT","Modelo":"204 Break 1.1 Grand L...	2026-04-09 17:30:18	2026-04-09 17:30:18
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 5	5	91-98-OJ	FORD	PUMA	1.7 16V	NULL	GASOLINA	NULL	125	92	1679	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1997 -	NULL	NULL	{"Marca":"FORD","Modelo":"PUMA","Combustivel":"GAS...	2026-04-09 17:38:26	2026-04-09 17:38:26
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 6	6	77-25-MM	FORD	PUMA	1.4 16V	NULL	GASOLINA	NULL	90	66	1388	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1997 -	NULL	NULL	{"Marca":"FORD","Modelo":"PUMA","Combustivel":"GAS...	2026-04-09 17:44:43	2026-04-09 17:44:43
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 7	7	AA-87-EJ	TESLA	MODEL 3	EV Performance AWD	Preto	ELÉTRICO	5YJ3E7EC1LF681625	513	377	NULL	Tração integral	NULL	Nacional	3/2020	NULL	X	Ligeiro Passageiros	Saloon	2019 -	Proprietário	Particular	{"Marca":"TESLA","Modelo":"MODEL 3","Cor Original"...	2026-04-09 17:45:47	2026-04-09 17:45:47
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 8	8	AV-25-LU	FORD	TRANSIT V363 Caixa	2.0 EcoBlue RWD	Branco	GASÓLEO	WF0EXXTTRENR64309	170	125	1995	Tração traseira	247	Nacional	12/2022	58.21€	C	Ligeiro Mercadorias	Bus	2016 -	Proprietário	Empresa	{"Marca":"FORD","Modelo":"TRANSIT V363 Caixa","Cor...	2026-04-09 17:59:12	2026-04-09 17:59:12
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 9	9	AH-71-FT	DACIA	DUSTER	1.6 16V	NULL	GASOLINA	UU1HSDCM545292295	105	77	1598	Tração dianteira	165	Importado	05/2021	0.01€	X	Ligeiro Passageiros	SUV	2010 -	Proprietário	Empresa	{"Marca":"DACIA","Modelo":"DUSTER","Combustivel":"...	2026-04-09 18:02:02	2026-04-09 18:02:02
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 10	10	70-VR-12	BMW	3	330 e	Preto	GASOLINA/ELÉTRICO	WBA8E11030AG87980	252	185	1998	Tração traseira	45	Nacional	11/2018	221.37€	B	Ligeiro Passageiros	Saloon	2015 -	Proprietário	Particular	{"Marca":"BMW","Modelo":"3","Cor Original":"Preto"...	2026-04-10 00:08:28	2026-04-10 00:08:28
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 11	11	06-10-PD	RENAULT	MASTER II Caixa	2.5 D	Amarelo	GASÓLEO	VF1FDCEM521865301	80	59	2499	Tração dianteira	NULL	Nacional	3/2000	58.21€	C	Ligeiro Mercadorias	Van	1998 -	Proprietário	Particular	{"Marca":"RENAULT","Modelo":"MASTER II Caixa","Cor...	2026-04-10 03:28:18	2026-04-10 03:28:18
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 12	12	35-76-QF	HONDA	ACCORD VI	1.8 i	Cinza	GASOLINA	SHHCG8540YU101078	136	100	1850	Tração dianteira	201	Nacional	8/2000	158.31€	A	Ligeiro Passageiros	Saloon	1998 -	Proprietário	Particular	{"Marca":"HONDA","Modelo":"ACCORD VI","Cor Origina...	2026-04-10 13:01:56	2026-04-10 13:01:56
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 13	13	BB-45-DE	MERCEDES-BENZ	CLA Shooting Brake	CLA 180 d	Preto	GASÓLEO	WDD1179121N524223	109	80	1461	Tração dianteira	101	Importado	5/2023	158.29€	B	Ligeiro Passageiros	Estate	2015 -	Proprietário	Particular	{"Marca":"MERCEDES-BENZ","Modelo":"CLA Shooting Br...	2026-04-10 21:16:08	2026-04-10 21:16:08
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 14	14	38-DG-05	BMW	3 Touring	320 d	Azul	GASÓLEO	WBAAX71080PE49635	136	100	1951	Tração traseira	156	Importado	4/2007	46.26€	A	Ligeiro Passageiros	Estate	2000 -	Proprietário	Particular	{"Marca":"BMW","Modelo":"3 Touring","Cor Original"...	2026-04-10 22:03:55	2026-04-10 22:03:55
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 15	15	34-QE-44	MINI	MINI COUNTRYMAN	Cooper D	Cinza	GASÓLEO	WMWZD31020WS24327	112	82	1598	Tração dianteira	111	Nacional	7/2015	NULL	B	Ligeiro Passageiros	Estate	2010 -	Proprietário	Particular	{"Marca":"MINI","Modelo":"MINI COUNTRYMAN","Cor Or...	2026-04-11 03:40:28	2026-04-11 03:40:28
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 16	16	89-76-TS	SKODA	FABIA I (6Y2)	1.4	Cinza	GASOLINA	TMBPB46Y323506243	68	50	1397	Tração dianteira	173	Nacional	6/2002	62.40€	A	Ligeiro Passageiros	Hatchback	NULL	Proprietário	Particular	{"Marca":"SKODA","Modelo":"FABIA I (6Y2)","Cor Ori...	2026-04-12 12:39:03	2026-04-12 12:39:03
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 17	17	27-88-MF	BMW	5 (E39)	530 d	NULL	GASÓLEO	WBADL71040-GM76191	184	135	2926	Tração traseira	192	Nacional	11/1998	72.26€	A	Ligeiro Passageiros	Saloon	NULL	Proprietário	Particular	{"Marca":"BMW","Modelo":"5 (E39)","Combustivel":"G...	2026-04-12 12:43:46	2026-04-12 12:43:46
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 18	18	99-23-RJ	SEAT	IBIZA II	1.0 i	Cinza	GASOLINA	NULL	50	37	999	NULL	NULL	NULL	4/2001	NULL	NULL	NULL	NULL	1996 -	NULL	NULL	{"Marca":"SEAT","Modelo":"IBIZA II","Cor Original"...	2026-04-12 12:51:55	2026-04-12 12:51:55
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 19	19	63-49-QE	SEAT	IBIZA II	1.9 TDI	Preto	GASÓLEO	VSSZZZ6KZ1R055669	90	66	1896	Tração dianteira	NULL	Nacional	8/2000	35.15€	C	Ligeiro Mercadorias	Hatchback	1996 -	Proprietário	Particular	{"Marca":"SEAT","Modelo":"IBIZA II","Cor Original"...	2026-04-12 13:08:40	2026-04-12 13:08:40
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 20	20	02-58-IV	OPEL	COMBO Caixa/monovolume	1.7 D	NULL	GASÓLEO	W0L000071V3052617	60	44	1686	Tração dianteira	NULL	Nacional	08/1997	35.15€	C	Ligeiro Mercadorias	Coupe	1994 -	Proprietário	Particular	{"Marca":"OPEL","Modelo":"COMBO Caixa/monovolume",...	2026-04-12 13:37:59	2026-04-12 13:37:59
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 21	21	24-FF-45	OPEL	CORSA D	1.2	Cinza	GASOLINA	W0L0SDL6884229032	80	59	1229	Tração dianteira	146	Nacional	2/2008	135.87€	B	Ligeiro Passageiros	Hatchback	2006 -	Proprietário	Particular	{"Marca":"OPEL","Modelo":"CORSA D","Cor Original":...	2026-04-12 15:16:01	2026-04-12 15:16:01
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 22	22	47-69-VH	SKODA	FABIA I Combi	1.2	Cinza	GASOLINA	TMBJY46Y133823251	64	47	1198	Tração dianteira	144	Nacional	7/2003	39.95€	A	Ligeiro Passageiros	Estate	2003 -	Proprietário	Particular	{"Marca":"SKODA","Modelo":"FABIA I Combi","Cor Ori...	2026-04-12 15:18:07	2026-04-12 15:18:07
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 23	23	75-DS-08	OPEL	MOVANO A Caixa	2.5 DTI	Branco	GASÓLEO	VN1F9C1M637783199	115	84	2464	Tração dianteira	NULL	Nacional	6/2007	58.21€	C	Ligeiro Mercadorias	Van	2001 -	Proprietário	Empresa	{"Marca":"OPEL","Modelo":"MOVANO A Caixa","Cor Ori...	2026-04-12 15:21:31	2026-04-12 15:21:31
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 24	24	01-VS-92	NISSAN	MICRA V	0.9 IG-T	Cinza	GASOLINA	VNVK1400161992952	90	66	898	Tração dianteira	99	Nacional	11/2018	111.46€	B	Ligeiro Passageiros	Hatchback	2016 -	Proprietário	Particular	{"Marca":"NISSAN","Modelo":"MICRA V","Cor Original...	2026-04-12 21:18:00	2026-04-12 21:18:00
Edit	Copy	Delete DELETE FROM plate_info WHERE `plate_info`.`id` = 25	25	49-34-NH	RENAULT	SCÉNIC I Veículo multiuso	1.4 16V	NULL	GASOLINA	VF1JA0W0519923733	95	70	1390	NULL	168	Nacional	05/1999	62.40€	A	Ligeiro Passageiros	NULL	1999 -	Proprietário	Particular	{"Marca":"RENAULT","Modelo":"SCÉNIC I Veículo mult...	2026-04-12 22:08:26	2026-04-12 22:08:26

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view