SELECT
id,
area,
radbids_listings.moderated,
name,
type,
featured,
hot,
urgent,
detailview,
viewcount,
COUNT(radbids_bids.pid) AS bids,
AVG(radbids_bids.price) AS average,
MAX(radbids_bids.dateposted) AS lastbid,
radbids_listings.dateposted,
UNIX_TIMESTAMP(radbids_listings.dateposted) AS pdate,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft,
radbids_rate.avgrate,
min_bid,
bid_inc,
buynow,
dateawarded,
listing_type
FROM radbids_listings
LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid
LEFT JOIN radbids_rate ON radbids_listings.id=radbids_rate.pid
WHERE type='Open' and featured=1
GROUP BY id
HAVING timeleft>0
ORDER BY dateposted DESC LIMIT 0,25 Table 'radbid_db1.radbids_rate' doesn't exist SELECT
id,
area,
radbids_listings.moderated,
name,
type,
featured,
hot,
urgent,
detailview,
viewcount,
COUNT(radbids_bids.pid) AS bids,
AVG(radbids_bids.price) AS average,
MAX(radbids_bids.dateposted) AS lastbid,
radbids_listings.dateposted,
UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft,
radbids_rate.avgrate,
min_bid,
bid_inc,
buynow,
dateawarded,
listing_type
FROM radbids_listings
LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid
LEFT JOIN radbids_rate ON radbids_listings.id=radbids_rate.pid
WHERE type='Open' and featured=1
GROUP BY id
HAVING timeleft>0
ORDER BY dateposted DESC Table 'radbid_db1.radbids_rate' doesn't exist
