|
|
Got error -1 from storage engine
SELECT id,name,type,featured,urgent,detailview,viewcount,COUNT(pid) AS bids,
AVG(price) AS average,area,radnics_domains.dateposted,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft
FROM
radnics_domains LEFT JOIN radnics_bids ON id=pid WHERE type='Open' AND featured=0 GROUP BY id ORDER BY dateposted DESC
| |
