MESA

1 - 50 of 69

MESA CONSTRUCTION ,INC.

#

EQUIPMENT WORK

MANHATTAN

MESA CONSTRUCTION INC

#0003308

EQUIPMENT WORK

MANHATTAN

MESA CONST,

#

ALTERATION

MANHATTAN

MESA CONST,

#

EQUIPMENT

MANHATTAN

MESA CONSTRUCTION ,INC.

#

EQUIPMENT WORK

MANHATTAN

MESA REALTY LLC

#

INCORRECT LICENSE

JORGE MESA

#

FOOD VENDOR LICENSE

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA HERMENEGILDO

#

INCORRECT LICENSE

MESA DE ESPANA REST INC

#

FOOD SERVICE EST.

MANHATTAN

MESA, JORGE

#

FOOD SERVICE ESTAB

QUEENS

MESA, MODESTO

#

FOOD SERVICE EST.

MANHATTAN

MESA-EXO CAFE,INC.

#

FOOD SERVICE EST.

QUEENS

MESA, JORGE

#

FOOD VENDOR LICENSE

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA, MODESTO

#

FOOD SERVICE EST.

MANHATTAN

MESA REALTY LLC

#

INCORRECT LICENSE

SALVADOR MESA

#

INCORRECT LICENSE

MAPLE MESA LLC PWB MGMT CORP

#

INCORRECT LICENSE

MESA MEXICANA REST. INC.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

BROOKLYN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

BROOKLYN

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

BROOKLYN

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

BROOKLYN

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MANHATTAN

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA AZTECA CORP

#

RETAIL FOOD PROCESS

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

MESA SEAVIEW CORP.

#

FOOD SERVICE EST.

(default) 2 queries took 24 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+MESA)' IN BOOLEAN MODE) LIMIT 50		50	50	18
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+MESA)' IN BOOLEAN MODE)		1	1	6