web.rceroorkee.in / 127.0.0.1 / rceroork_lms_rceroorkee / wh_lms_leads

There are no favourite tables.

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.	Not a non-negative number!

Customise 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

Customise 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 (49389 total, Query took 0.1318 seconds.) [dispatch_status: 0... - 0...]

SELECT * FROM `wh_lms_leads` ORDER BY `dispatch_status` DESC

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

Filter rows:

			id	company_name	name	description	email	phone	lead_source	address	city	state	pincode	contact_person	assigned	executive	lead_status	lead_type	is_repeat	q_type 1-buylead, 2- driectlead, 3-call	lead_date	region_id	divison	purpose	service	DL_number	GST_number	website_lnik	created_at	updated_at	company_id	ref_id	state_id	district_id	dead_reason_id	transfer_id	order_count	dispatch_status 1	dispatch_detials	customer_type	dealer_id	deleted_at	country_iso	additional_remark	course	branch	fee_deposited	dor	consultancy	sub_divison	lead_score	hold	dead	mature
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 256	256	NULL	Kshitij anand	NULL	NULL	9523502518	52	NULL	NULL	NULL	0	NULL	1	NULL	0	3	1	0	0000-00-00 00:00:00	NULL	NULL	9	NULL	NULL	NULL	NULL	0000-00-00 00:00:00	2025-05-22 15:36:15	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 512	512	NULL	Tushar Sharma	NULL	NULL	8266938562	52	NULL	NULL	NULL	0	NULL	1	NULL	0	13	0	0	2025-03-01 11:16:44	NULL	NULL	1	NULL	NULL	NULL	NULL	2025-03-01 11:16:44	2025-03-08 23:18:17	63	0	0	0	0	0	0	0	NULL	0	NULL	2025-03-08 23:18:17	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 768	768	NULL	shivani rawat	B.Tech. CE	shivirawat8494@gmail.com	7983674162	243	Dehradun	Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-03-07 18:45:52	NULL	["1"]	0	NULL	NULL	NULL	NULL	2025-03-07 18:45:52	2025-05-08 12:16:46	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 1024	1024	NULL	mohd anas	B.Tech. CE	mahdanas6599@gmail.com	9927682927	243	Udham singh nagar	Udham singh nagar	Uttarakhand	0	NULL	1	NULL	0	3	1	0	2025-03-11 18:29:11	NULL	["1"]	9	NULL	NULL	NULL	NULL	2025-03-11 18:29:11	2025-04-19 10:47:32	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 1280	1280	NULL	Avneet Kaur	NULL	avneetwarraich05@gmail.com	9729802844	250	NULL	Jind	Haryana	0	NULL	0	0	0	3	1	0	2025-03-15 14:26:56	0	NULL	9	NULL	NULL	NULL	NULL	2025-03-15 14:26:56	2025-05-06 11:51:39	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 1536	1536	NULL	Shabnam khurshid	NULL	Moonshabnam43@gmail.com	8630040984	250	NULL	Bareilly	Uttar Pradesh	0	NULL	0	0	0	3	1	0	2025-03-18 11:42:31	0	NULL	0	NULL	NULL	NULL	NULL	2025-03-18 11:42:31	2025-05-21 21:02:04	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 1792	1792	NULL	Bhumika Bhumika	NULL	devendrak189.dk@gmail.com	9999650334	250	NULL	Delhi	Delhi	0	NULL	0	0	0	3	0	0	2025-03-19 09:43:01	0	NULL	0	NULL	NULL	NULL	NULL	2025-03-19 09:43:01	2025-05-21 17:08:36	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 2048	2048		Shadab Shadab	B.Sc Nursing	shadabmr21@gmail.com	7818007344	201		Surat	Gujarat	0	NULL	1	NULL	0	12	0	0	2025-03-20 09:58:06	0	NULL	2	["2"]	NULL	NULL	NULL	2025-03-20 09:58:06	2025-03-20 13:23:21	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 2304	2304	NULL	DEEPAK PRASAD	MBA	prasaddeepak483@gmail.com	8938099074	243	Dehradun	Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-03-22 15:33:44	NULL	["1"]	2	NULL	NULL	NULL	NULL	2025-03-22 15:33:44	2025-05-06 17:52:37	63	0	0	0	181	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 2560	2560	NULL	NITISHA SINGH	MBA	nitishasingh19954@gmail.com	9897248151	243	Dehradun	Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-03-25 18:29:18	NULL	["1"]	1	["34"]	NULL	NULL	NULL	2025-03-25 18:29:18	2025-05-07 15:44:21	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 2816	2816	NULL	Kishore.g	B.Sc Nursing	kishorgopalakrishnan@gmail.com	9688480881	249		Erode	TAMIL NADU	0	NULL	1	NULL	0	3	0	0	2025-03-28 10:02:40	NULL	["1"]	9	["20"]	NULL	NULL	NULL	2025-03-28 10:02:40	2025-05-10 13:55:20	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 3072	3072		Smily Manish Babu	B.Sc Nursing	manish27022006@gmail.com	9142182387	201		Daudnagar	Bihar	0	NULL	1	NULL	0	3	0	0	2025-03-30 10:09:28	0	NULL	2	["2"]	NULL	NULL	NULL	2025-03-30 10:09:28	2025-05-06 15:23:20	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 3328	3328	NULL	DISHA CHAUHAN	MBA	disha20041106@gmail.com	7906018899	243	Dehradun	Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-04-01 21:41:36	NULL	["1"]	2	["34"]	NULL	NULL	NULL	2025-04-01 21:41:36	2025-04-03 10:29:08	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 3584	3584	NULL	Sahil lamba	BCA	2212jyotisingh@gmail.com	8527675008	243	Dehradun	Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	1	0	2025-04-03 20:37:10	NULL	["1"]	9	NULL	NULL	NULL	NULL	2025-04-03 20:37:10	2025-05-06 11:26:12	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 3840	3840	NULL	KHUSHI	MBA	khushisheor@gmail.com	8791360736	243	Dehradun	Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	1	0	2025-04-05 17:30:26	NULL	["1"]	9	NULL	NULL	NULL	NULL	2025-04-05 17:30:26	2025-05-20 10:16:27	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 4096	4096		Satyam Pal	bca_(data_science)	psundram924@gmail.com	+919918624026	201	Kannauj	Kannauj	Uttar Pradesh	0	NULL	1	NULL	0	3	0	0	2025-04-08 09:36:06	0	NULL	0	NULL	NULL	NULL	NULL	2025-04-08 09:36:06	2025-05-08 11:59:29	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 4352	4352	NULL	praveen dutt sharma	BCA (AI & ML)	sharma@345gmail.com	9411458600	53	NULL	Saharanpur	NULL	NULL	NULL	0	394	0	3	0	0	2025-04-09 12:43:24	NULL	NULL	2	["2"]	NULL	NULL	NULL	2025-04-09 12:43:24	2025-05-27 13:55:27	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 4608	4608		Utkarsh	B.Tech. Hons.(CSE)	uk2856333@gmail.com	7979897685	201		Muzaffarpur	Bihar	0	NULL	1	NULL	0	3	0	0	2025-04-11 09:42:11	0	NULL	0	NULL	NULL	NULL	NULL	2025-04-11 09:42:11	2025-05-08 12:01:06	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 4864	4864	NULL	Manish Kumar Gupta	B.Tech. Hons. (CSE)	manishgupta@gmail.com	9997449240	53	NULL	Rishikesh	NULL	NULL	NULL	0	402	0	3	0	0	2025-04-12 12:42:03	NULL	NULL	2	NULL	NULL	NULL	NULL	2025-04-12 12:42:03	2025-05-07 09:33:36	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 5120	5120	NULL	mohd shajahan	BCA	d34605400@gmail.com	7451095205	250		Dehradun	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-04-14 12:55:48	NULL	["1"]	9	NULL	NULL	NULL	NULL	2025-04-14 12:55:48	2025-05-06 17:56:39	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 5376	5376	NULL	arun	helloo	arun.2kumarsaini@gmail.com	7906619738	30	roorkeeeng		Lakshadweep	0	NULL	0	NULL	0	0	0	0	2025-04-16 10:18:31	NULL	["1"]	0	NULL	NULL	NULL	NULL	2025-04-16 10:18:31	2025-04-16 10:20:50	63	0	0	0	0	0	0	0	NULL	0	NULL	2025-04-16 10:20:50	IN	NULL	NULL	NULL	NULL	NULL	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 5632	5632	NULL	Rohit SR	D.Pharm	kingrohit75410@gmail.com	7310502394	58		Uttarakhand - Other	Uttarakhand	0	NULL	1	NULL	0	3	1	0	2025-04-18 13:50:40	NULL	[null]	2	NULL	NULL	NULL	NULL	2025-04-18 13:50:40	2025-06-19 12:48:25	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 5888	5888	NULL	Shashi Pratap Singh	B.Tech. Hons. (CSE)	wwwshashisingh45@gmail.com	9927180121	58		Haldwani	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-04-19 21:17:27	NULL	[null]	9	NULL	NULL	NULL	NULL	2025-04-19 21:17:27	2025-06-13 16:43:54	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	1	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 6144	6144	NULL	Anirudh jha	B.Tech. CE	anirudh46116@gmail.com	8797656440	243	Patna	Patna	Bihar	0	NULL	1	NULL	0	3	1	0	2025-04-21 13:39:05	NULL	["1"]	0	NULL	NULL	NULL	NULL	2025-04-21 13:39:05	2025-05-06 11:51:29	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	90	0	0	0
Edit	Copy	Delete DELETE FROM wh_lms_leads WHERE `wh_lms_leads`.`id` = 6400	6400	NULL	shubha sharma	MBA	shubhasharma440@gmail.com	7895731653	57		Roorkee	Uttarakhand	0	NULL	1	NULL	0	3	0	0	2025-04-21 18:18:05	NULL	["1"]	0	NULL	NULL	NULL	NULL	2025-04-21 18:18:05	2025-05-06 17:31:26	63	0	0	0	0	0	0	0	NULL	0	NULL	NULL	IN	NULL	0	0	0	0000-00-00	NULL	NULL	87	0	0	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view