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 `eceo_electronics_permit`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts permit_no permit_code application_no date_issued bldg_official_id bldg_official_name bldg_permit_no or_no or_date applicant_name bp_id bns_id issued_to bldg_name issued_by issued_id issued_by2 issued_id2 issued_position date_save project_id project_name form_type
If other permits kay "SPECIAL"
char_occupancy
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 1
1 33 0001-01-01 0 2021-01-04-00001-C NULL NULL NULL 30 9677 NULL NULL NULL NULL 0 2021-01-04 9 36.0M-4 LEGGED-SSTT-280 kmph (CELLSITE TOWER)
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 2
2 46 0001-01-01 0 2021-01-08-00002-C NULL NULL NULL 34 9484 NULL NULL NULL NULL 0 2021-01-08 10 36.0M-4 LEGGED-SSTT-280 kmph (CELLSITE TOWER)
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 4
4 67 0001-01-01 116 Florencia G. Mumar 2021-02-11-00007-C NULL NULL NULL 13 9677 NULL NULL NULL NULL 0 2021-02-11 15 36.0M-4 LEGGED-SSTT-280 kmph (CELLSITE TOWER)
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 6
6 EP0200002021 96 0001-01-01 116 Florencia G. Mumar 2021-02-11-00001-IND`L NULL NULL NULL 32 8181 NULL NULL NULL NULL 0 2021-02-22 37 PROPOSED 1 STOREY AUXILIARY BLDG.
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 7
7 429 0001-01-01 523 2021-03-11-00013-C NULL NULL NULL 134 1109 NULL NULL NULL NULL 523 CHIEF ENFORCEMENT 2021-03-19 257 30.0M-3 LEGGED-SSTT (CELLSITE TOWER)
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 8
8 436 0001-01-01 523 NULL NULL NULL 433 3107 NULL NULL NULL NULL 523 CHIEF ENFORCEMENT 2021-03-22 416 PROPOSED NEW FTK PROJECT OF SMART COMMUNICATIONS I...
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 9
9 504 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 166 0 NULL NULL NULL NULL 523 CHIEF ENFORCEMENT 2021-04-06 463 PROPOSED SELF-SUPPORTING TOWER OF DITO TELECOMMUNI...
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 10
10 509 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 168 1109 NULL NULL NULL NULL 523 CHIEF ENFORCEMENT 2021-04-07 465 PROPOSED 9.0M 3-LEGGED-MINI SSTT (CELLSITE TOWER) ...
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 18
18 983 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 269 10307 NULL NULL NULL NULL Galileo C. Orlanes 523 CHIEF ENFORCEMENT 2021-05-04 740 PROPOSED 40M-3LEGGED-SST-280KPH/C OF ABOITIZ AIRPO...
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 20
20 2021-05-07-0001-C 1052 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 1109 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2021-05-27 761 PROPOSED SIGNAL BOOSTER Special COMMERCIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 21
21 2021-05-19-0002-C 952 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 8944 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2021-05-27 720 PROPOSED CEBU RING 1 CCY001 (AERIAL FIBER OPTIC CA... Special COMMERCIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 22
22 2744 0001-01-01 116 Engr. Florencia G. Mumar NULL NULL NULL 742 0 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2021-06-22 1398 TEST SUBJECT JUNE 22
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 23
23 2745 0001-01-01 116 Engr. Florencia G. Mumar NULL NULL NULL 742 0 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2021-06-22 1398 TEST SUBJECT JUNE 22
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 24
24 2860 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 0 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2021-06-23 1398 TEST SUBJECT JUNE 22 Special RESIDENTIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 25
25 4794 0001-01-01 0 Engr. Florencia G. Mumar NULL NULL NULL 1986 3107 NULL NULL NULL NULL 0 CHIEF ENFORCEMENT 2021-07-30 2729 PROPOSED TOWER CONVERSION PROJECT
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 26
26 5751 0001-01-01 0 Engr. Florencia G. Mumar NULL NULL NULL 2435 10707 NULL NULL NULL NULL 0 CHIEF ENFORCEMENT 2021-08-25 3208 PROPOSED PH070022A 40M HIGH 3-LEGGED SST TUBULAR
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 27
27 6514 0001-01-01 0 Engr. Florencia G. Mumar NULL NULL NULL 2719 10707 NULL NULL NULL NULL 0 CHIEF ENFORCEMENT 2021-09-10 3410 PROPOSED 40-M HIGH 3-LEGGED SST(TUBULAR)
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 28
28 7734 0001-01-01 0 Engr. Florencia G. Mumar NULL NULL NULL 3208 1109 NULL NULL NULL NULL 0 CHIEF ENFORCEMENT 2021-11-12 4073 PROPOSED 30.0M 3-LEGGED CELL SITE TOWER
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 29
29 10702 0001-01-01 0 Engr. Florencia G. Mumar NULL NULL NULL 3573 11906 NULL NULL NULL NULL 0 CHIEF ENFORCEMENT 2022-09-22 5730 PROPOSED INTERIOR RENOVATION - MR DIY STORE FITOUT...
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 30
30 10767 0001-01-01 0 Engr. Florencia G. Mumar NULL NULL NULL 3578 11913 NULL NULL NULL NULL 0 CHIEF ENFORCEMENT 2022-09-27 5743 PROPOSED 40M 3-LEGGEDSELF SUPPORTING TOWER (280KPH...
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 31
31 11682 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 1109 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2022-12-12 6237 PROPOSED FIBER OPTIC CABLE LAYING Special RESIDENTIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 33
33 2023-03-06-0001-C 12932 2023-03-06 0 Florencia G. Mumar NULL NULL NULL 0 0 NULL NULL NULL NULL Galileo C. Orlanes 0 CHIEF ENFORCEMENT 2023-03-06 7034 FIBER OPTIC CABLE LAYING Special COMMERCIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 34
34 12933 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 0 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2023-03-06 7042 SIGNAL BOOSTER / GLOBE TELECOM INC. Special RESIDENTIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 35
35 12934 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 0 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2023-03-06 7043 AERIAL FIBER OPTIC CABLE / CONVERGE ICT SOLUTIONS ... Special COMMERCIAL
Edit Edit Copy Copy Delete Delete
DELETE FROM eceo_electronics_permit WHERE `eceo_electronics_permit`.`permit_no` = 38
38 13237 0001-01-01 116 Florencia G. Mumar NULL NULL NULL 0 0 NULL NULL NULL NULL Galileo C. Orlanes 118 CHIEF ENFORCEMENT 2023-03-29 7253 PROPOSED NEW MACRO SITE ACCESS FOC Special RESIDENTIAL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view