|
|
Job Ready Listings
Job Summary  |
Reward |
Classification |
Started |
|---|
No Database Selected
SELECT
id,radlance_projects.moderated,name,type,featured,detailview,urgent,viewcount,area,radlance_projects.dateposted,
is_show_thubnail,
is_show_icon,
img_name,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft, minbudget+maxbudget as reward
FROM
radlance_projects WHERE type='Open' AND job=1 GROUP BY id ORDER BY featured DESC, dateposted DESC |
