COLD SPG HBR

1 - 50 of 77

COLD SPOT

#

EQUIPMENT WORK

MANHATTAN

COLD SPOT SERVICE CORP

#

ALTERATION

BROOKLYN

COLD SPOT SERVICE CORP

#

NEW BUILDING

COLD SPOT SERVICE CORP

#

ALTERATION

COLD SPOT SERVICE CORP

#

EQUIPMENT WORK

A.A. COLD AIR

#

ALTERATION

BRONX

A.G.M. GROCERY CORP D/B/A/ COLD

#0022756

EQUIPMENT WORK

BRONX

A.G.M. GROCERY CORP D/B/A/ COLD

#0022756

EQUIPMENT WORK

BRONX

COLD FREEZE TECHNOLOGY IN

#0610187

EQUIPMENT WORK

QUEENS

COLD SPOT SERVICE CORP

#0000792

PLUMBING

BROOKLYN

COLD SPOT SERVICE CORP

#

EQUIPMENT WORK

BROOKLYN

COLD SPOT SERVICE CORP

#

EQUIPMENT WORK

BROOKLYN

COLD SPOT SERVICE CORP.

#

ALTERATION

BROOKLYN

COLD STONE CREAMERY RESTAURANT LLC

#

TEMP FOOD SERV ESTAB

MANHATTAN

COLD STONE CREAMERY RESTAURANT, LLC

#

RETAIL FOOD PROCESS

ST.COLD STORAGE HALL

#

WELL WATER

ST.COLD STORAGE HALL

#

WELL WATER

STATEN ISLAND

T & J HOT & COLD HEROS INC.

#

FOOD SERVICE EST.

ST.COLD STORAGE HALL

#

WELL WATER

COLD STONE CREAMERY RESTAURANT, LLC

#

RETAIL FOOD PROCESS

COLD STONE CREAMERY

#

TEMP FOOD SERV ESTAB

QUEENS

HALL ST COLD STORAGE WAREHOUSES INC

#

WATER POTABILITY

HALL ST COLD STORAGE WAREHOUSES INC

#

WATER POTABILITY

CUT CITY CORP COLD

#

FOOD SERVICE EST.

COLD STONE CREAMERY RESTAURANT, LLC

#

RETAIL FOOD PROCESS

HALL ST COLD STORAGE WAREHOUSES INC

#

WATER POTABILITY

COLD STONE CREAMERY RESTAURANT LLC

#

RETAIL FOOD PROCESS

COLD STONE CREAMERY RESTAURANT LLC

#

RETAIL FOOD PROCESS

L.L.C. COLD STONE CREAMERY RESTAURANTS

#

RETAIL FOOD PROCESS

COLD STONE CREAMERY

#

TEMP FOOD SERV ESTAB

QUEENS

HOT & COLD EXPRESS INC

#

RETAIL FOOD PROCESS

QUEENS

COLD STUFF INC

#

RETAIL FOOD PROCESS

MANHATTAN

HALL ST.COLD STORAGE

#

WELL WATER

HOT & COLD EXPRESS INC

#

RETAIL FOOD PROCESS

QUEENS

ICE COLD ENTERPRISES, INC

#

FOOD SERVICE EST.

HALL ST.COLD STORAGE

#

WELL WATER

COLD STONE CREAMERY

#

TEMP FOOD SERV ESTAB

MANHATTAN

EURO. HOT/COLD HOUSEWIFE

#

FOOD SERVICE EST.

QUEENS

COLD STONE CREAMERY RESTAURANT, LLC

#

RETAIL FOOD PROCESS

SANDRA E. COLD

#

N/A

MANHATTAN

J & M COLD CUT CITY INC.

#

FOOD SERVICE EST.

ICE COLD ENTERPRISES, INC

#

FOOD SERVICE EST.

COLD STONE CREAMERY RESTAURANTS LLC

#

TEMP FOOD SERV ESTAB

ST.COLD STORAGE HALL

#

WELL WATER

COLD STUFF INC

#

RETAIL FOOD PROCESS

MANHATTAN

ST.COLD STORAGE HALL

#

WELL WATER

ST.COLD STORAGE HALL

#

WELL WATER

CUT CITY CORPOR COLD

#

FOOD SERVICE EST.

COLD STONE CREAMERY RESTAURANT LLC

#

TEMP FOOD SERV ESTAB

MANHATTAN

J & M COLD CUT CITY INC.

#

FOOD SERVICE EST.

(default) 2 queries took 12 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 ( '(+COLD +SPG +HBR)' IN BOOLEAN MODE) LIMIT 50		50	50	8
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+COLD +SPG +HBR)' IN BOOLEAN MODE)		1	1	4