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
business_dtl int(11)
business_no int(11)
tax_year int(11)
capitalization decimal(12,2)
new_capitalization decimal(12,2)
gross_sales decimal(12,2)
new_gross_sales decimal(12,2)
lessor_name varchar(150) utf8_general_ci
business_add_blk varchar(150) utf8_general_ci
business_add_lot varchar(150) utf8_general_ci
business_add_bldg varchar(150) utf8_general_ci
business_add_street varchar(150) utf8_general_ci
business_add_purok_name varchar(150) utf8_general_ci
buss_purok varchar(150) utf8_general_ci
business_add_brgy varchar(150) utf8_general_ci
business_add_brgy_name varchar(150) utf8_general_ci
business_add_subd varchar(150) utf8_general_ci
business_add_city varchar(150) utf8_general_ci
business_add_prov varchar(150) utf8_general_ci
business_add_telno varchar(150) utf8_general_ci
business_add_email varchar(150) utf8_general_ci
owner_add_blk varchar(150) utf8_general_ci
owner_add_lot varchar(150) utf8_general_ci
owner_add_bldg varchar(150) utf8_general_ci
owner_add_street varchar(150) utf8_general_ci
owner_purok varchar(150) utf8_general_ci
owner_add_brgy varchar(150) utf8_general_ci
owner_add_subd varchar(150) utf8_general_ci
owner_add_city varchar(150) utf8_general_ci
owner_add_prov varchar(150) utf8_general_ci
owner_add_telno varchar(150) utf8_general_ci
owner_add_email varchar(150) utf8_general_ci
lessor_add_blk varchar(150) utf8_general_ci
lessor_add_lot varchar(150) utf8_general_ci
lessor_add_bldg varchar(150) utf8_general_ci
lessor_add_street varchar(150) utf8_general_ci
lessor_add_brgy varchar(150) utf8_general_ci
lessor_add_subd varchar(150) utf8_general_ci
lessor_add_city varchar(150) utf8_general_ci
lessor_add_prov varchar(150) utf8_general_ci
lessor_add_telno varchar(150) utf8_general_ci
lessor_add_email varchar(150) utf8_general_ci
SSS varchar(150) utf8_general_ci
in_case_telno varchar(150) utf8_general_ci
in_case_mobile varchar(150) utf8_general_ci
in_case_email varchar(150) utf8_general_ci