CAMPBELL [Permits for CAMPBELL]

51 - 72 of 72

MASTROVASELIS, GEORGE

Individual

Active


CAMPBELL, GLENN P.

Individual

Inactive


CAMPBELL, ELVIN D

Individual

Active


CAMPBELL, RICHARD

Individual

Active




CAMPBELL CHEESE & GROCERY

Business

Inactive



POE CARRIAGES

Business

Active



EAST VILLAGE MUSIC STORE

Business

Inactive


SIMPLE RENOVATION SOLUTIONS

Business

Inactive


TK LAUNDROMAT

Business

Active



CAMPBELL, JOSEPH

Business

Active



LEBELL ELECTRONIC

Business

Active


SARAH CLOTHING STORE

Business

Active


Ridgewood Coins & Collectibles

Business

Inactive


IAIN CAMPBELL DESIGN, LTD.

Business

Active



CAMPBELL, JAMES J

Individual

Active


(default) 2 queries took 572 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 ( '(+CAMPBELL)' IN BOOLEAN MODE) LIMIT 50, 502222298
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+CAMPBELL)' IN BOOLEAN MODE)11274