errno: 256
errstr: Db query failed. Error from db: Errno: 1021: Disk full (/var/tmp/#sql_edf_0); waiting for someone to free some space....
sql: SELECT
*,
pr.profile_id,
if (pr.previousProfilePackage_code <> '' AND pr.previousProfilePackage_code IS NOT NULL,
pr.previousProfilePackage_code,
pr.profilePackage_code
) AS currentPackage_code

FROM profiles AS pr
LEFT JOIN companies AS c ON pr.company_id = c.company_id
LEFT JOIN profilePackages AS pp ON pr.profilePackage_code = pp.code

LEFT JOIN profilePhotoGalleries AS ppg ON pr.profile_id = ppg.profile_id
LEFT JOIN photos ON ppg.photoGallery_id = photos.photoGallery_id


LEFT JOIN profile_theme AS pt ON pr.profile_id = pt.profile_id
WHERE pr.profile_id IS NOT NULL AND (pr.approvalStatus_code = 'approved'
OR
(
pr.approvalStatus_code = 'needsApproval'
AND
pr.previousProfilePackage_code IS NOT NULL
AND
pr.previousProfilePackage_code <> ''
)
)
AND pt.theme_id = '92'

GROUP BY
pr.profile_id

ORDER BY
pp.rank DESC,
c.company



errfile: /web/sites/nywelcomesyou/releases/20160217153638/lib/db.lib.php
errline: 72
errno: 256
errstr: Db query failed. Error from db: Errno: 1021: Disk full (/var/tmp/#sql_edf_0); waiting for someone to free some space....
sql: SELECT
*,
pr.profile_id,
if (pr.previousProfilePackage_code <> '' AND pr.previousProfilePackage_code IS NOT NULL,
pr.previousProfilePackage_code,
pr.profilePackage_code
) AS currentPackage_code

FROM profiles AS pr
LEFT JOIN companies AS c ON pr.company_id = c.company_id
LEFT JOIN profilePackages AS pp ON pr.profilePackage_code = pp.code

LEFT JOIN profilePhotoGalleries AS ppg ON pr.profile_id = ppg.profile_id
LEFT JOIN photos ON ppg.photoGallery_id = photos.photoGallery_id


LEFT JOIN profile_theme AS pt ON pr.profile_id = pt.profile_id
WHERE pr.profile_id IS NOT NULL AND (pr.approvalStatus_code = 'approved'
OR
(
pr.approvalStatus_code = 'needsApproval'
AND
pr.previousProfilePackage_code IS NOT NULL
AND
pr.previousProfilePackage_code <> ''
)
)
AND pt.theme_id = '92'

GROUP BY
pr.profile_id

ORDER BY
pp.rank DESC,
c.company
LIMIT 0, 8


errfile: /web/sites/nywelcomesyou/releases/20160217153638/lib/db.lib.php
errline: 72
errno: 256
errstr: Db query failed. Error from db: Errno: 1021: Disk full (/var/tmp/#sql_edf_0); waiting for someone to free some space....
sql: SELECT
*
FROM profiles AS pr
LEFT JOIN profile_adPlacementType AS papt ON pr.profile_id = papt.profile_id
LEFT JOIN profile_theme AS pt ON pr.profile_id = pt.profile_id
LEFT JOIN themes AS t ON pt.theme_id = t.theme_id

LEFT JOIN companies AS c ON pr.company_id = c.company_id
LEFT JOIN zipCodes AS z ON c.ship_address_zip = z.ZIPCode
AND z.CityType = 'D'
LEFT JOIN counties AS cnty ON z.County IN (cnty.county, cnty.alias1, cnty.alias2)
LEFT JOIN regions AS reg ON cnty.region_id = reg.region_id
LEFT JOIN profilePhotoGalleries AS ppg ON pr.profile_id = ppg.profile_id
LEFT JOIN photos ON ppg.photoGallery_id = photos.photoGallery_id

WHERE t.theme_id = '92' AND pr.profilePackage_code = 'featured' AND pr.profile_id IS NOT NULL AND (pr.approvalStatus_code = 'approved'
OR
(
pr.approvalStatus_code = 'needsApproval'
AND
pr.previousProfilePackage_code IS NOT NULL
AND
pr.previousProfilePackage_code <> ''
)
)

GROUP BY
pr.profile_id

ORDER BY
RAND(NOW())

LIMIT 0,5


errfile: /web/sites/nywelcomesyou/releases/20160217153638/lib/db.lib.php
errline: 72
New York Welcomes You to see tour and travel videos looking for things to do with our New York Travel Guide. Real Estate Services. errno: 8<br /> errstr: Undefined index: company<br /> errfile: /web/sites/nywelcomesyou/shared/templates_c/%%DA^DAA^DAAF7566%%thingsToDo.tpl.html.php<br /> errline: 11<br /> .
Real Estate Services
you are here: home / Things to do
Real Estate Services - Search New York
New York welcomes you™
Buying a New York home or business can be a terrific experience, whether it is your first or 99th real estate transaction. The key is to work with an industry leader, ask direct questions and take the right steps at the right time. New York has every type of property in any price range imaginable. Wonderful schools, quaint neighborhoods and friendly people are alway here to welcome you. Want to know more? Then browse through our website, request the New York Welcomes You DVD Travel Planner and enjoy your own New York Vacation.
No Matches Found
New York's Premier
Diamond sponsors:
 
errno: 2
errstr: Unknown: write failed: No space left on device (28)
errfile: Unknown
errline: 0
errno: 2
errstr: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session)
errfile: Unknown
errline: 0