03/10/2010 08:13am
|
You are now logged into iFreelanceWork.com as () - Logout
Most Reviewed Projects
Project Title  |
Bids |
Avg. Bid |
Project Category |
Started |
Expires |
|---|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY id
HAVING viewcount>0
ORDER BY viewcount DESC' at line 16SELECT
CASE
WHEN maxbudget>=1000 AND 1000>0 THEN 5
WHEN minbudget>=1000 AND 1000>0 THEN 5
WHEN maxbudget>=500 AND 1000>0 AND 500>0 THEN 4
WHEN minbudget>=500 AND 500>0 THEN 4
WHEN maxbudget>=250 AND 500>0 AND 250>0 THEN 3
WHEN minbudget>=250 AND 250>0 THEN 3
WHEN maxbudget>=100 AND 250>0 AND 100>0 THEN 2
WHEN minbudget>=100 AND 100>0 THEN 2
ELSE 1
END as mlevel,
id,radlance_projects.moderated,name,type,featured,detailview,urgent,viewcount,area,radlance_projects.dateposted,hidebid,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft FROM
radlance_projects LEFT JOIN radlance_reviews on radlance_projects.id=radlance_reviews.pid
WHERE type='Open' AND sell=0 AND job=0GROUP BY id
HAVING viewcount>0
ORDER BY viewcount DESC| | | Powered by: RadLance Gold v7.5
| |
