Amusement Device Permanent [Permits for Amusement Device Permanent]

151 - 171 of 171

NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive




FLUSHING MEADOWS CAROUSEL

Business

Inactive


VICTORIAN GARDENS

Business

Inactive


ADVENTURE'S AMUSEMENT PARK

Business

Inactive



NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


ADVENTURE'S AMUSEMENT PARK

Business

Active


LUNA PARK

Business

Inactive


VICTORIAN GARDENS

Business

Inactive



VICTORIAN GARDENS

Business

Inactive


FLUSHING MEADOWS PARK

Business

Inactive


SCREAM ZONE

Business

Inactive


FUN STATION USA

Business

Inactive




ADVENTURE'S PARK

Business

Active


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


Museum of Sex

Business

Active


(default) 2 queries took 521 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 ( '(+Amusement +Device +Permanent)' IN BOOLEAN MODE) LIMIT 150, 502121284
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Amusement +Device +Permanent)' IN BOOLEAN MODE)11237