For those that don't want to be bothered with designing their own sites we are pleased to provide you with a templated version of RadBids
Plain |
Black |
Blue |
Red |
Teal
| 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,
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='english' 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
 |
Bids  |
Last Bid |
Buy Now |
Expires  |
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/radbid/domains/radbids.com/public_html/auction_software/teal1/radbids/src/print_listings.php on line 749
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,
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='english' 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
 |
Bids  |
Last Bid |
Buy Now |
Expires  |
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/radbid/domains/radbids.com/public_html/auction_software/teal1/radbids/src/print_listings.php on line 749
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,
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='english' and type='Open'
GROUP BY id
HAVING timeleft>0
ORDER BY bids DESC, dateposted DESC LIMIT 0,5 Table 'radbid_db1.radbids_rate' doesn't exist
| |
Name
 |
Bids  |
Last Bid |
Buy Now |
Expires  |
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/radbid/domains/radbids.com/public_html/auction_software/teal1/radbids/src/print_listings.php on line 749
View All
Recent Offers
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='english' and type='Open'
GROUP BY id
HAVING timeleft>0
ORDER BY lastbid DESC LIMIT 0,5 Table 'radbid_db1.radbids_rate' doesn't exist
| |
Name
 |
Bids  |
Last Bid |
Buy Now |
Expires  |
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/radbid/domains/radbids.com/public_html/auction_software/teal1/radbids/src/print_listings.php on line 749
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,
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='english' 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
 |
Bids  |
Last Bid |
Buy Now |
Expires  |
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/radbid/domains/radbids.com/public_html/auction_software/teal1/radbids/src/print_listings.php on line 749
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,
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='english' and type='Close'
GROUP BY id
ORDER BY dateawarded DESC, dateposted DESC LIMIT 0,5 Table 'radbid_db1.radbids_rate' doesn't exist
| |
Name
 |
Bids  |
Last Bid |
Buy Now |
Expires  |
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/radbid/domains/radbids.com/public_html/auction_software/teal1/radbids/src/print_listings.php on line 749
View All
View All Categories
Your Site Name Quick Statistics |
Registered Members:
43 members, with 0 Open Listings
Currently Online: 2 Visitors,
0 members for a Total of: 2
We are pleased to report that a total of 0 auctions have been closed on Your Site Name for a total value of $0.00. |
|