Freelancewell.com is your source for finding professional freelancers who can address areas such as: |
|
|
Featured Projects
Project Title  |
Bids |
Avg. Bid |
Project Type |
Started |
Expires |
|---|
Got error 122 from table handler
SELECT
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,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft FROM
radlance_projects
WHERE type='Open' AND featured=1 AND sell=0 AND job=0
GROUP BY id
ORDER BY featured DESC , dateposted DESC
| Powered by: RadLANCE Gold v7
|
