|
|
Auctions
 |
Bids |
Avg. Bid |
|
Started |
Expires |
|---|
No Database Selected
SELECT
CASE
WHEN rp.maxbudget>4000 AND 4000>0 THEN 5
WHEN rp.minbudget>4000 AND 4000>0 THEN 5
WHEN rp.maxbudget>2000 AND 4000>0 AND 2000>0 THEN 4
WHEN rp.minbudget>2000 AND 2000>0 THEN 4
WHEN rp.maxbudget>1000 AND 2000>0 AND 1000>0 THEN 3
WHEN rp.minbudget>1000 AND 1000>0 THEN 3
WHEN rp.maxbudget>500 AND 1000>0 AND 500>0 THEN 2
WHEN rp.minbudget>500 AND 500>0 THEN 2
ELSE 1
END as mlevel,
rp.id as id,
rp.moderated as moderated,
rp.name as name,
rp.type as type,
rp.featured as featured,
rp.detailview as detailview,
rp.urgent as urgent,
rp.viewcount as viewcount,
rp.area as area,
rp.dateposted as dateposted,
rp.programmer as programmer,
is_show_thubnail,
is_show_icon,
img_name,
UNIX_TIMESTAMP(rp.dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft
FROM
radlance_projects as rp
INNER JOIN
radlance_bids as rb
ON
rb.pid = rp.id
WHERE rp.`type`='Open' AND rb.bidby='143' GROUP BY id ORDER BY mlevel DESC, featured DESC, dateposted
|
