About Us | Contact
Home » Auctions » Closed Auctions

Closed Auctions

There are no closed auctions at the moment.

 
Affiliate Program
(default) 94 queries took 62 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `auctions`27272
2DESCRIBE `products`24242
3DESCRIBE `categories`10102
4DESCRIBE `limits`552
5DESCRIBE `images`772
6DESCRIBE `image_defaults`331
7DESCRIBE `setting_increments`772
8DESCRIBE `translations`992
9DESCRIBE `languages`441
10DESCRIBE `statuses`331
11DESCRIBE `users`21212
12DESCRIBE `genders`221
13DESCRIBE `sources`441
14DESCRIBE `points`551
15DESCRIBE `addresses`13132
16DESCRIBE `user_address_types`221
17DESCRIBE `countries`551
18DESCRIBE `bids`881
19DESCRIBE `bidbutlers`881
20DESCRIBE `accounts`991
21DESCRIBE `affiliates`881
22DESCRIBE `affiliate_codes`441
23DESCRIBE `referrals`661
24DESCRIBE `credits`771
25DESCRIBE `watchlists`551
26DESCRIBE `reminders`331
27DESCRIBE `messages`551
28DESCRIBE `auction_emails`221
29DESCRIBE `autobids`441
30DESCRIBE `smartbids`441
31DESCRIBE `settings`441
32DESCRIBE `currencies`331
33SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
34SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE `Setting`.`name` = 'default_meta_description' LIMIT 1110
35SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE `Setting`.`name` = 'default_meta_keywords' LIMIT 1110
36SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` WHERE `closed` = 1 AND `Auction`.`active` = 1 110
37SELECT `Auction`.`id`, `Auction`.`product_id`, `Auction`.`start_time`, `Auction`.`end_time`, `Auction`.`max_end`, `Auction`.`max_end_time`, `Auction`.`price`, `Auction`.`autolist`, `Auction`.`featured`, `Auction`.`peak_only`, `Auction`.`nail_bitter`, `Auction`.`penny`, `Auction`.`hidden_reserve`, `Auction`.`autobids`, `Auction`.`random`, `Auction`.`minimum_price`, `Auction`.`leader_id`, `Auction`.`winner_id`, `Auction`.`status_id`, `Auction`.`active`, `Auction`.`closed`, `Auction`.`bid_debit`, `Auction`.`hits`, `Auction`.`created`, `Auction`.`modified`, `Auction`.`auto_start`, `Auction`.`auto_start_time` FROM `auctions` AS `Auction` WHERE `closed` = 1 AND `Auction`.`active` = 1 ORDER BY `Auction`.`end_time` desc LIMIT 30000
38SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
39SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 4 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
40SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 4 LIMIT 1110
41SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 8 AND `Category`.`lft` > 7 ORDER BY `Category`.`lft` asc 000
42SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 9 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
43SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 9 LIMIT 1110
44SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 18 AND `Category`.`lft` > 17 ORDER BY `Category`.`lft` asc 000
45SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 2 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
46SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 2 LIMIT 1110
47SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 4 AND `Category`.`lft` > 3 ORDER BY `Category`.`lft` asc 000
48SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 6 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
49SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 6 LIMIT 1110
50SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 12 AND `Category`.`lft` > 11 ORDER BY `Category`.`lft` asc 000
51SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 15 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
52SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 15 LIMIT 1110
53SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 30 AND `Category`.`lft` > 29 ORDER BY `Category`.`lft` asc 000
54SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 12 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
55SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 12 LIMIT 1110
56SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 24 AND `Category`.`lft` > 23 ORDER BY `Category`.`lft` asc 000
57SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 14 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
58SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 14 LIMIT 1110
59SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
60SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 7 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
61SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 7 LIMIT 1110
62SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
63SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 5 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
64SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 5 LIMIT 1110
65SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 10 AND `Category`.`lft` > 9 ORDER BY `Category`.`lft` asc 000
66SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 16 AND `Auction`.`start_time` < '2010-07-31 18:50:24' AND `Auction`.`end_time` > '2010-07-31 18:50:24' 111
67SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 16 LIMIT 1110
68SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 32 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 000
69SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 8 AND `Auction`.`start_time` < '2010-07-31 18:50:25' AND `Auction`.`end_time` > '2010-07-31 18:50:25' 111
70SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 8 LIMIT 1110
71SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 16 AND `Category`.`lft` > 15 ORDER BY `Category`.`lft` asc 000
72SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 10 AND `Auction`.`start_time` < '2010-07-31 18:50:25' AND `Auction`.`end_time` > '2010-07-31 18:50:25' 111
73SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 10 LIMIT 1110
74SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 20 AND `Category`.`lft` > 19 ORDER BY `Category`.`lft` asc 000
75SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 11 AND `Auction`.`start_time` < '2010-07-31 18:50:25' AND `Auction`.`end_time` > '2010-07-31 18:50:25' 111
76SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 11 LIMIT 1110
77SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 22 AND `Category`.`lft` > 21 ORDER BY `Category`.`lft` asc 000
78SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 3 AND `Auction`.`start_time` < '2010-07-31 18:50:25' AND `Auction`.`end_time` > '2010-07-31 18:50:25' 111
79SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 3 LIMIT 1110
80SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 6 AND `Category`.`lft` > 5 ORDER BY `Category`.`lft` asc 000
81SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 13 AND `Auction`.`start_time` < '2010-07-31 18:50:25' AND `Auction`.`end_time` > '2010-07-31 18:50:25' 111
82SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 13 LIMIT 1110
83SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 26 AND `Category`.`lft` > 25 ORDER BY `Category`.`lft` asc 000
84SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
85SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE start_time < '2010-07-31 18:50:25' AND end_time > '2010-07-31 18:50:25' 111
86SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE start_time > '2010-07-31 18:50:25' 111
87SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `closed` = 1 110
88SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`free` = 1 AND start_time < '2010-07-31 18:50:25' AND end_time > '2010-07-31 18:50:25' 111
89DESCRIBE `pages`13132
90DESCRIBE `departments`331
91SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
92SELECT `Page`.`id`, `Page`.`name`, `Page`.`title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`content`, `Page`.`slug`, `Page`.`top_show`, `Page`.`top_order`, `Page`.`bottom_show`, `Page`.`bottom_order`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`top_show` > 0 ORDER BY `Page`.`top_order` ASC 110
93SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
94SELECT `Page`.`id`, `Page`.`name`, `Page`.`title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`content`, `Page`.`slug`, `Page`.`top_show`, `Page`.`top_order`, `Page`.`bottom_show`, `Page`.`bottom_order`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`bottom_show` > 0 ORDER BY `Page`.`bottom_order` ASC 110