LAUREL

1 - 50 of 127

LAUREL ENVIRONMNETAL ASSO

#0604896

EQUIPMENT WORK

BRONX

LAUREL HILL PROPERTIES, LLC

#999994

EQUIPMENT WORK

QUEENS

372 LAUREL RD

#0009435

EQUIPMENT WORK

QUEENS

372 LAUREL RD

#0009435

EQUIPMENT

QUEENS

372 LAUREL RD

#0009435

EQUIPMENT

QUEENS

372 LAUREL RD

#0009435

EQUIPMENT WORK

QUEENS

372 LAUREL RD

#0009435

EQUIPMENT WORK

QUEENS

LAUREL LESIO EISENSTADT & BERT

#

ALTERATION

BROOKLYN

372 LAUREL ROAD

#0009435

ALTERATION

QUEENS

LIBURD, LAUREL

#

TEMP FOOD SERV ESTAB

LAUREL UPTOWN REALTY LLC

#

INCORRECT LICENSE

MANHATTAN

REID, LAUREL A

#

TEMP FOOD SERV ESTAB

LAUREL DRINKS,INC.

#

FOOD SERVICE EST.

INC LAUREL LEE REST

#

FOOD SERVICE EST.

MANHATTAN

LAUREL HILL LLC

#

INCORRECT LICENSE

MANHATTAN

LAUREL LIBURD

#

TEMP FOOD SERV ESTAB

LAUREL VITO

#

INCORRECT LICENSE

STATEN ISLAND

KLEPPE, LAUREL S.

#

N/A

LAUREL LIBURD

#

TEMP FOOD SERV ESTAB

LONG ISLAND CITY

QUEENS

NEIL & LAUREL GREENSTEIN

#

FOOD SERVICE EST.

LAUREL A LIBURD

#

TEMP FOOD SERV ESTAB

LAUREL COPELAND

#

INCORRECT LICENSE

THE LAUREL CONDOMINIUM

#

BATHING POOL ESTAB.

LAUREL DRINKS, INC.

#

FOOD SERVICE EST.

PATTON, LAUREL ANN

#

N/A

LIBURD, LAUREL A.

#

TEMP FOOD SERV ESTAB

LAUREL DONUT CORPORATION

#

FOOD SERVICE EST.

LAUREL MARKET, INC

#

FOOD SERVICE EST.

LIBURD, LAUREL

#

TEMP FOOD SERV ESTAB

THE LAUREL CONDOMINIUM

#

BATHING POOL ESTAB.

LAUREL HILL LLC MGMT OFFICE

#

INCORRECT LICENSE

QUEENS

61-16 LAUREL HILL BLVD INC.

#

FOOD SERVICE EST.

QUEENS

LAUREL LORD

#

TEMP FOOD SERV ESTAB

BRONX

LAUREL LEE REST INC

#

FOOD SERVICE EST.

MANHATTAN

THE LAUREL CONDOMINIUM

#

BATHING POOL ESTAB.

LAUREL LEE RESTAURANT INC

#

FOOD SERVICE EST.

MANHATTAN

LAUREL LEE REST INC

#

FOOD SERVICE EST.

MANHATTAN

LAUREL LEE REST INC

#

FOOD SERVICE EST.

MANHATTAN

LIBURD, LAUREL

#

TEMP FOOD SERV ESTAB

LAUREL & FRANKLIN WHITTAKER

#

INCORRECT LICENSE

BROOKLYN

WILLIAMS, LAUREL

#

TEMP FOOD SERV ESTAB

ROSENZWEIG, LAUREL M.

#

N/A

MANHATTAN

LAUREL UPTOWN REALTY LLC

#

INCORRECT LICENSE

MANHATTAN

JOHNSON, LAUREL

#

N/A

THE LAUREL CONDOMINIUM

#

BATHING POOL ESTAB.

INC. LAUREL DRINKS

#

FOOD SERVICE EST.

MANHATTAN

LAUREL & FRANKLIN WHITTAKER

#

INCORRECT LICENSE

BROOKLYN

LIBURD, LAUREL

#

TEMP FOOD SERV ESTAB

BRONX

LIBURD, LAUREL

#

TEMP FOOD SERV ESTAB

MALCOLM, LAUREL F.

#

N/A

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