Cabaret [Permits for Cabaret]

151 - 167 of 167

REMIX

Business

Inactive


PURLIEU

Business

Inactive


PODIUM

Business

Inactive


42ND STREET LESSEE LLC

Business

Inactive


AVANT GARDNER

Business

Inactive


EL FORUM

Business

Inactive


STUDIO TEN

Business

Inactive


SUPER EL NOA NOA CORP.

Business

Inactive


SAPPHIRE 39

Business

Inactive


PERFECTION

Business

Inactive


LIBERTY DINER

Business

Inactive


GOLDFINGER'S SECRETS

Business

Inactive


GOOD UNITS

Business

Inactive


GLEN ROY LUNCH

Business

Inactive


IGUANA NEW YORK, LTD.

Business

Inactive


FLIRT

Business

Inactive


UES REST. CORP.

Business

Inactive


(default) 2 queries took 970 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Cabaret)' IN BOOLEAN MODE) LIMIT 150, 501717545
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Cabaret)' IN BOOLEAN MODE)11425