SELECT users.* FROM (SELECT *, (SELECT COUNT(id) FROM users_files WHERE user_id = users.id) AS files_count FROM users WHERE DATE_SUB(CURDATE(), INTERVAL 1 DAY) <= u.`timestamp_created`) AS users ORDER BY files_count ASC - Unknown table 'u' in where clause
This is on the lead system?
+ Reply to Thread
Results 1 to 2 of 2
Thread: What just caused this?
-
01-02-2008 12:29 PM #1
- Join Date
- Aug 2006
- Location
- Fort Worth texas
- Posts
- 4,815
What just caused this?
Looking for Real Estate, Investments, Condos in Dallas-Fort Worth-Denton-Keller-Haslet-North Texas Area. We have you covered, 400 New Homes and 60,000 Pre-owned home. Mike Pannell 817-703-3238
Dallas Texas Real Estate | Fort Worth Texas Real Estate | Dallas Real Estate
And remember...Nu Home Source Realty Rebates 20% of earned commissions back to the buyer!
-
01-02-2008 01:09 PM #2
- Join Date
- Aug 2006
- Location
- Fort Worth texas
- Posts
- 4,815
Re: What just caused this?
it is fixed know
Looking for Real Estate, Investments, Condos in Dallas-Fort Worth-Denton-Keller-Haslet-North Texas Area. We have you covered, 400 New Homes and 60,000 Pre-owned home. Mike Pannell 817-703-3238
Dallas Texas Real Estate | Fort Worth Texas Real Estate | Dallas Real Estate
And remember...Nu Home Source Realty Rebates 20% of earned commissions back to the buyer!
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
