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 :
Browse mode
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 `optimiseddata_leg1_siqdpnv7odgzlf` ORDER BY `distance` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
scenario from from_state from_id from_name from_district from_lat from_long to to_state to_id to_name to_district to_lat to_long commodity quantity distance Ascending Descending 1 approve_admin approve_district new_id_admin new_id_district new_name_admin new_name_district reason_admin reason_district new_distance_admin new_distance_district district_change_approve status
Optimized Depot Punjab 319011 Abch Hyderabad 30.52189 75.57805 FPS Punjab 1049000000110 Pqrs Adilabad 30.3581304 75.5585061 Wheat 82.85 19.768 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 319011 Abch Hyderabad 30.52189 75.57805 FPS Punjab 1049000000111 Pqrs Hyderabad 30.3673606 75.5413749 Wheat 137.25 20.779 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000101 Pqrs Adilabad 31.7567825 74.8265603 Wheat 38.2 22.728 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 319011 Abch Hyderabad 30.52189 75.57805 FPS Punjab 1049000000108 Pqrs Hyderabad 30.3655719 75.5380489 Wheat 81.9 23.805 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 319011 Abch Hyderabad 30.52189 75.57805 FPS Punjab 1049000000109 Pqrs Hyderabad 30.3263299 75.5029403 Wheat 0.45 28.833 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000105 Pqrs Adilabad 31.8534041 74.822632 Wheat 43.0 28.884 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000100 Pqrs Adilabad 31.8782287 74.8815764 Wheat 31.25 35.417 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000102 Pqrs Adilabad 31.9513897 74.8857828 Wheat 41.6 39.94 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 319011 Abch Hyderabad 30.52189 75.57805 FPS Punjab 1049000000107 Pqrs Hyderabad 30.222075 75.411028 Wheat 35.0 43.596 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000103 Pqrs Adilabad 31.98423 74.9160067 Wheat 25.05 46.529 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000106 Pqrs Adilabad 31.9545716 74.9397843 Wheat 16.25 47.077 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Optimized Depot Punjab 302039 Abch Adilabad 31.7019 74.68967 FPS Punjab 1049000000104 Pqrs Adilabad 32.01216 74.9311183 Wheat 33.85 53.604 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
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