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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
cert_no varchar(100) latin1_swedish_ci
series_no varchar(50) latin1_swedish_ci
app_date date
payee_id varchar(50) latin1_swedish_ci
payee_type varchar(50) latin1_swedish_ci
excempt varchar(100) latin1_swedish_ci
prop_owner text latin1_swedish_ci
prop_name text latin1_swedish_ci
prop_address text latin1_swedish_ci
taxdec_id varchar(50) latin1_swedish_ci
taxdec_no varchar(100) latin1_swedish_ci
pin_number varchar(55) latin1_swedish_ci
prop_type varchar(50) latin1_swedish_ci
cert_id int(11)
income_account_code varchar(100) latin1_swedish_ci
res_purpose text latin1_swedish_ci
status varchar(30) latin1_swedish_ci
onlinerequestid int(11)
businessapplicant int(11)
businessname varchar(255) latin1_swedish_ci
businessapplicant_id int(11)
brgy_address int(11)
classification_type varchar(255) latin1_swedish_ci
cert_remarks varchar(255) latin1_swedish_ci
cert_type varchar(255) latin1_swedish_ci
rev_from date
rev_to date
classname varchar(255) latin1_swedish_ci
classid int(11)
savedate timestamp
rpt_ownership varchar(20) latin1_swedish_ci
rpt_ownership_others varchar(500) latin1_swedish_ci
encoded varchar(250) latin1_swedish_ci
cpy varchar(100) latin1_swedish_ci