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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling 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 `tbl_eng_swa_detail`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id main_id ItemNo item_id Description org_qty Unit org_unit_cost org_amount Wt revised_qty revised_cont_amount revised_wt prev_acc prev_wt prev_amt accomplishment accomplishment_wt accomplishment_amount total_acc total_wt total_amt add_qty add_unitcost add_amnt ded_qty ded_unitcost ded_amnt extra_qty extra_unit extra_unitcost extra_amnt amount_ ts isBoldText swa_guid dupa_id
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 60
60 3 1 642 Mobilization/Demobilization 1.00 lot 513200.0000000000000000 513200.0000000000000000 37.5762553797124000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 18.7881276898562000 256600.0000000000000000 50.0000000000000000 18.7881276898562000 256600.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-04 15:11:02 0 7ad6daf0-5d53-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 61
61 3 2 654 Temporary Facilities 1.00 Lot 105700.0000000000000000 105700.0000000000000000 7.7393027935222100 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 40.0000000000000000 3.0957211174088800 42280.0000000000000000 40.0000000000000000 3.0957211174088800 42280.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-04 15:11:02 0 7ad6dfa2-5d53-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 62
62 3 3 776 Construction Safety and Health 1.00 Lot 40000.0000000000000000 40000.0000000000000000 2.9287806219573200 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 30.0000000000000000 0.8786341865871960 12000.0000000000000000 30.0000000000000000 0.8786341865871960 12000.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-04 15:11:02 0 7ad6e1cb-5d53-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 63
63 3 4 802 Painting 1.00 Lot 250620.0000000000000000 250620.0000000000000000 18.3502749868736000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 20.0000000000000000 3.6700549973747200 50124.0000000000000000 20.0000000000000000 3.6700549973747200 50124.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-04 15:11:02 0 7ad6e533-5d53-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 64
64 3 5 652 Stone Masonry 30.00 cu.meter 4472.6700000000000000 134180.1000000000000000 9.8246019183073800 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 10.0000000000000000 0.9824601918307380 13418.0100000000000000 10.0000000000000000 0.9824601918307380 13418.0100000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-04 15:11:02 0 7ad6e702-5d53-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 65
65 3 6 709 Grouted Riprap 96.00 cu.meter 3354.7500000000000000 322056.0000000000000000 23.5807842996271000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 10.0000000000000000 2.3580784299627100 32205.6000000000000000 10.0000000000000000 2.3580784299627100 32205.6000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-04 15:11:02 0 7ad6e8c1-5d53-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 66
66 4 1 642 Mobilization/Demobilization 1.00 lot 13524.0000000000000000 13524.0000000000000000 0.9995650820930310 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 67
67 4 2 776 Construction Safety and Health 1.00 Lot 24139.5000000000000000 24139.5000000000000000 1.7841615867483500 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 68
68 4 3 654 Temporary Facilities 9.00 square meter
4189.5000000000000000 37705.5000000000000000 2.7868309082267700 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 69
69 4 4 691 Concrete 0.63 cum 11583.3300000000000000 7297.4979000000000000 0.5393614379981680 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 70
70 4 0 GI Pipe Framing, Epoxy Painted Finish 1344.00 lm 469.6100000000000000 631155.8400000000000000 46.6490194486170000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 71
71 4 0 Greenhouse Net 1.00 lot 165479.7800000000000000 165479.7800000000000000 12.2306869181039000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 72
72 4 5 799 Excavation 17.71 cum 340.9000000000000000 6037.3390000000000000 0.4462225120643640 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 73
73 4 6 690 Backfill 10.50 cum 309.9900000000000000 3254.8950000000000000 0.2405707917686480 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 74
74 4 0 Reinforced Concrete (Pedestal and Footing) 82.00 unit 1239.4700000000000000 101636.5400000000000000 7.5120035824276600 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 75
75 4 0 Fence with Gate 162.70 lm 2229.6100000000000000 362757.5470000000000000 26.8115777319522000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 10:12:26 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 95
95 5 1 642 Mobilization/Demobilization 1.00 lot 7987.3500000000000000 7987.3500000000000000 0.7364679164632020 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 0.3682339582316010 3993.6750000000000000 50.0000000000000000 0.3682339582316010 3993.6750000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913730-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 96
96 5 2 654 Temporary Facilities 9.00 sq.m 4387.5420000000000000 39487.8780000000000000 3.6409516593379700 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 1.8204758296689800 19743.9390000000000000 50.0000000000000000 1.8204758296689800 19743.9390000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e9138f0-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 97
97 5 3 789 Const. Safety & health 1.00 Lot 23100.0000000000000000 23100.0000000000000000 2.1299190432746700 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 1.0649595216373400 11550.0000000000000000 50.0000000000000000 1.0649595216373400 11550.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913997-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 98
98 5 4 799 Excavation 122.69 cu.m 358.6722600000000000 44005.4995794000000000 4.0574957386571300 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 60.0000000000000000 2.4344974431942800 26403.2997476400000000 60.0000000000000000 2.4344974431942800 26403.2997476400000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913a1a-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 99
99 5 5 690 Backfill 49.00 cu.m 243.1608160000000000 11914.8799840000000000 1.0986030206170500 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 0.5493015103085250 5957.4399920000000000 50.0000000000000000 0.5493015103085250 5957.4399920000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913a96-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 100
100 5 6 640 Embankment 88.00 cu.m 259.2784000000000000 22816.4992000000000000 2.1037790539801400 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 1.0518895269900700 11408.2496000000000000 50.0000000000000000 1.0518895269900700 11408.2496000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913b16-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 101
101 5 7 788 Concret works 60.00 cu.m 7945.3500000000000000 476721.0000000000000000 43.9557201830712000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 55.0000000000000000 24.1756461006892000 262196.5500000000000000 55.0000000000000000 24.1756461006892000 262196.5500000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913b8f-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 102
102 5 8 700 Steel Reinforcements 3896.60 kgs 79.3704040000000000 309274.7162264000000000 28.5164548785273000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 60.0000000000000000 17.1098729271164000 185564.8297358400000000 60.0000000000000000 17.1098729271164000 185564.8297358400000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913c0f-5d7d-11ec-a19c-2cea7fee6f8c 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_eng_swa_detail WHERE `tbl_eng_swa_detail`.`id` = 103
103 5 0 Weepholes 1.00 lot 79179.1900000000000000 79179.1900000000000000 7.3006608057170400 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 50.0000000000000000 3.6503304028585200 39589.5950000000000000 50.0000000000000000 3.6503304028585200 39589.5950000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 0.0000000000000000 2021-11-16 11:28:23 0 7e913c89-5d7d-11ec-a19c-2cea7fee6f8c 0
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view