HomeFAQContact UsSign UpForumsLog In

Featured Items

There are currently no items featured
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, min_bid, bid_inc, buynow, dateawarded, listing_type FROM radbids_listings LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid WHERE listing_type='english' and type='Open' and featured=1 GROUP BY id HAVING timeleft>0 ORDER BY dateposted DESC LIMIT 0,10
Table 'crbaucti_radbidsDB.radbids_bids' doesn't exist
  Name Sort Alphabetically Bids Sort Last Bid Buy Now Expires Sort by Expiry Date
View All

Newest 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, min_bid, bid_inc, buynow, dateawarded, listing_type FROM radbids_listings LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid WHERE listing_type='english' and type='Open' GROUP BY id HAVING timeleft>0 ORDER BY dateposted DESC LIMIT 0,10
Table 'crbaucti_radbidsDB.radbids_bids' doesn't exist
  Name Sort Alphabetically Bids Sort Last Bid Buy Now Expires Sort by Expiry Date
View All

Most Bids
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, min_bid, bid_inc, buynow, dateawarded, listing_type FROM radbids_listings LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid WHERE listing_type='english' and type='Open' GROUP BY id HAVING timeleft>0 ORDER BY bids DESC, dateposted DESC LIMIT 0,10
Table 'crbaucti_radbidsDB.radbids_bids' doesn't exist
  Name Sort Alphabetically Bids Sort Last Bid Buy Now Expires Sort by Expiry Date
View All

Recent Bids
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, min_bid, bid_inc, buynow, dateawarded, listing_type FROM radbids_listings LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid WHERE listing_type='english' and type='Open' GROUP BY id HAVING timeleft>0 ORDER BY lastbid DESC LIMIT 0,10
Table 'crbaucti_radbidsDB.radbids_bids' doesn't exist
  Name Sort Alphabetically Bids Sort Last Bid Buy Now Expires Sort by Expiry Date
View All

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, min_bid, bid_inc, buynow, dateawarded, listing_type FROM radbids_listings LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid WHERE listing_type='english' and type='Open' GROUP BY id HAVING timeleft>0 ORDER BY viewcount DESC, dateposted DESC LIMIT 0,10
Table 'crbaucti_radbidsDB.radbids_bids' doesn't exist
  Name Sort Alphabetically Bids Sort Last Bid Buy Now Expires Sort by Expiry Date
View All

Recent Sales
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, min_bid, bid_inc, buynow, dateawarded, listing_type FROM radbids_listings LEFT JOIN radbids_bids ON radbids_listings.id=radbids_bids.pid WHERE listing_type='english' and type='Closed' GROUP BY id ORDER BY dateawarded DESC, dateposted DESC LIMIT 0,5
Table 'crbaucti_radbidsDB.radbids_bids' doesn't exist
  Name Sort Alphabetically Bids Sort Last Bid Buy Now Expires Sort by Expiry Date
View All

Categories
Advertising (0)
  Ad Packages
,  Auto/Manual Surf Views
,  Banner Impressions
,  Email Advertising
,  Paid to Review
,  Pay To Click
,  Pay to Sign Up
,  Personal Pages
,  PTP Rotator Views, 
Banner & Website Design (0)
Crafts (0)
Domains (0)
Downlines & Referrals (0)
Hosting (0)
Misc (0)
Scripts & Programs (0)
Upgraded Memberships (0)
WebSites (0)
  New Websites
,  Previously Owned Websites, 
View All Categories

CRBAuction Quick Statistics
Registered Members: 0 members, with 0 Open Listings
Currently Online: 3 Visitors, members for a Total of: 3 | Most Ever Online: 97 @ 08/10/2007 10:00am
We are pleased to report that a total of 61 listings have been closed on CRBAuction for a total value of $0.00.

Icon Descriptions
Featured By Invitation Credit Card Confirmed Hot Item/Fire Sale
Urgent Locked Listing Payment Confirmed Power Seller

 

 Powered by: RadBids Gold v4
Executed in 0.108 Seconds