Add your logo here!!!
HomeFAQContact UsSign UpForumsLog In
Price Drop Auctions Featured
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 listing_type='pd' and type='Open' and featured=1 GROUP BY id HAVING timeleft>0 ORDER BY dateposted DESC LIMIT 0,5
Table 'radbid_db1.radbids_rate' doesn't exist
  Name Sort Alphabetically Price Sort by Price Expires Sort by Expiry Date
View All

Newst Additions
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 listing_type='pd' and type='Open' GROUP BY id HAVING timeleft>0 ORDER BY dateposted DESC LIMIT 0,5
Table 'radbid_db1.radbids_rate' doesn't exist
  Name Sort Alphabetically Price Sort by Price Expires Sort by Expiry Date
View All

0 0 Most Viewed
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 listing_type='pd' and type='Open' GROUP BY id HAVING timeleft>0 ORDER BY viewcount DESC, dateposted DESC LIMIT 0,5
Table 'radbid_db1.radbids_rate' doesn't exist
  Name Sort Alphabetically Price Sort by Price Expires Sort by Expiry Date
View All

Recently Sold
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 listing_type='pd' and type='Close' GROUP BY id ORDER BY dateawarded DESC, dateposted DESC LIMIT 0,5
Table 'radbid_db1.radbids_rate' doesn't exist
  Name Sort Alphabetically Price Sort by Price Expires Sort by Expiry Date
View All

 

 Powered by: RadBids Gold v4
Executed in 0.039 Seconds