Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_list): failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_cake_dev_eng) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'cake_dev_eng' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_list' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_list) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_list' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_permits) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_permits' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_permits) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_permits' to File cache [CORE/Cake/Cache/Cache.php, line 328]
S RICHMOND HILL

S RICHMOND HILL

Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_cake_eng) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'cake_eng' to File cache [CORE/Cake/Cache/Cache.php, line 328]
151 - 200 of 24163

LLOYD G DRUMMOND PLBG&GEN

#0000656

EQUIPMENT WORK


CISCO GENERAL CONSTRUCT

#0035170

EQUIPMENT


CISCO GENERAL CONSTRUCT

#0035170

NEW BUILDING


CISCO GENERAL CONSTRUCT

#0035170

NEW BUILDING


LLOYD G DRUMMOND PLBG&GEN

#0001386

EQUIPMENT WORK


LLOYD G DRUMMOND PLBG&GEN

#0001386

PLUMBING


SMITH-MCCORD, INC

#0008693

EQUIPMENT WORK


SMITH-MCCORD, INC

#0008693

EQUIPMENT WORK


NORTH SHORE NEON SIGN CO

#0000212

SIGN


NORTH SHORE NEON SIGN CO

#0000212

SIGN


NORTH SHORE NEON SIGN CO

#0000212

SIGN


NORTH SHORE NEON SIGN CO

#0000212

SIGN


PSI PLUMBING INC.

#0001596

PLUMBING


KADAR ELITE CNSTR INC

#0600713

EQUIPMENT WORK


KADAR ELITE CNSTR INC

#0600713

EQUIPMENT WORK


KADAR ELITE CNSTR INC

#0600713

ALTERATION


KADAR ELITE CNSTR INC

#0600713

NEW BUILDING


KADAR ELITE CNSTR INC

#0600713

EQUIPMENT


KADAR ELITE CNSTR INC

#0600713

EQUIPMENT


STRAIGHT LINE CONSTR COR*

#0602844

FOUNDATION


STRAIGHT LINE CONSTR COR*

#0602844

FOUNDATION


STRAIGHT LINE CONSTR COR*

#0602844

NEW BUILDING


STRAIGHT LINE CONSTR COR*

#0602844

EQUIPMENT


STRAIGHT LINE CONSTR COR*

#0602844

EQUIPMENT WORK


JTP PLBING CONTRACTOR, LT

#0001637

PLUMBING


#0036663

NEW BUILDING


JOHNNY'S P&H CONT. INC

#0000826

EQUIPMENT WORK


SUNSET PLGB.& FIRE CORP

#0000218

EQUIPMENT WORK


SJ VISION & SON P & H INC

#0000975

EQUIPMENT WORK


SJ VISION & SON P & H INC

#0000975

EQUIPMENT WORK


&quot;I AM&quot; CONSTRUCTION INC

#0009855

NEW BUILDING




&quot;I AM&quot; CONSTRUCTION INC

#0009855

NEW BUILDING


&quot;I AM&quot; CONSTRUCTION INC

#0009855

FOUNDATION


&quot;I AM&quot; CONSTRUCTION INC

#0009855

FOUNDATION


&quot;I AM&quot; CONSTRUCTION INC

#0009855

NEW BUILDING



JOHNNY'S P&H CONTRAC INC

#0001504

PLUMBING


CASE PLUMBING LLC

#0000860

EQUIPMENT WORK

RICHMOND HILL

QUEENS


MRMD NY CORP

#0608799

EQUIPMENT

RICHMOND HILL

QUEENS


MRMD NY CORP

#0608799

NEW BUILDING

RICHMOND HILL

QUEENS


NAVICO B & S CONSTRUCTION

#0603036

EQUIPMENT

RICHMOND HILL

QUEENS


NAVICO B & S CONSTRUCTION

#0603036

EQUIPMENT

RICHMOND HILL

QUEENS


EVEREST DEVELOPMENT ROUP

#0017959

EQUIPMENT

RICHMOND HILL

QUEENS


EVEREST DEVELOPMENT ROUP

#0017959

NEW BUILDING

RICHMOND HILL

QUEENS


EVEREST DEVELOP GROUP INC

#0017959

EQUIPMENT

RICHMOND HILL

QUEENS


EVEREST DEVELOP GROUP INC

#0017959

NEW BUILDING

RICHMOND HILL

QUEENS


EVEREST DEVELOP GROUP INC

#0017959

EQUIPMENT

RICHMOND HILL

QUEENS


BIJOY CONSTRUCTION CORP

#0037512

EQUIPMENT

RICHMOND HILL

QUEENS


(default) 2 queries took 4082 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 ( '(+S +RICHMOND +HILL)' IN BOOLEAN MODE) LIMIT 150, 50505014
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+S +RICHMOND +HILL)' IN BOOLEAN MODE)114068
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_file_map) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'file_map' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_method_cache) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'method_cache' to File cache [CORE/Cake/Cache/Cache.php, line 328]