|
|
Category List:
Project Category:
Wanted  |
Bids |
Avg. Bid |
Class |
Reward |
Started |
Expires |
|---|
No Database Selected
SELECT
CASE
WHEN maxbudget>=4000 AND 4000>0 THEN 5
WHEN minbudget>=4000 AND 4000>0 THEN 5
WHEN maxbudget>=2000 AND 4000>0 AND 2000>0 THEN 4
WHEN minbudget>=2000 AND 2000>0 THEN 4
WHEN maxbudget>=1000 AND 2000>0 AND 1000>0 THEN 3
WHEN minbudget>=1000 AND 1000>0 THEN 3
WHEN maxbudget>=500 AND 1000>0 AND 500>0 THEN 2
WHEN minbudget>=500 AND 500>0 THEN 2
ELSE 1
END as mlevel,
id,
radlance_projects.moderated,
name,
type,
featured,
detailview,
urgent,
viewcount,
area,
radlance_projects.dateposted,
programmer,
is_show_thubnail,
is_show_icon,
img_name,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft, minbudget, maxbudget FROM
radlance_projects
WHERE type='Open' AND ( (area LIKE '%:428:%') ) AND sell=0
GROUP BY id
ORDER BY mlevel DESC, featured DESC , timeleft
|
