About Us | Contact
Affiliate Program
(default) 109 queries took 61 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `categories`10102
2DESCRIBE `products`24242
3DESCRIBE `limits`551
4DESCRIBE `auctions`27272
5DESCRIBE `statuses`331
6DESCRIBE `users`21212
7DESCRIBE `genders`221
8DESCRIBE `sources`441
9DESCRIBE `points`551
10DESCRIBE `addresses`13132
11DESCRIBE `user_address_types`221
12DESCRIBE `countries`551
13DESCRIBE `bids`881
14DESCRIBE `bidbutlers`881
15DESCRIBE `accounts`991
16DESCRIBE `affiliates`881
17DESCRIBE `affiliate_codes`441
18DESCRIBE `referrals`661
19DESCRIBE `credits`771
20DESCRIBE `watchlists`551
21DESCRIBE `reminders`331
22DESCRIBE `messages`551
23DESCRIBE `auction_emails`221
24DESCRIBE `autobids`441
25DESCRIBE `smartbids`441
26DESCRIBE `images`771
27DESCRIBE `image_defaults`331
28DESCRIBE `setting_increments`772
29DESCRIBE `translations`992
30DESCRIBE `languages`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 `categories` AS `Category` LEFT JOIN `categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`parent_id` = 0 110
37SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`meta_description`, `ParentCategory`.`meta_keywords`, `ParentCategory`.`image`, `ParentCategory`.`created`, `ParentCategory`.`modified` FROM `categories` AS `Category` LEFT JOIN `categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc LIMIT 2015150
38SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 4 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1001
39SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 9 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
40SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 2 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1110
41SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 6 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
42SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 15 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
43SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 12 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
44SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 14 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
45SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 7 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
46SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 5 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
47SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 16 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
48SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 8 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
49SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 10 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
50SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 11 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
51SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 3 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
52SELECT `Image`.`image` FROM `images` AS `Image` LEFT JOIN `products` AS `Product` ON (`Image`.`product_id` = `Product`.`id`) LEFT JOIN `image_defaults` AS `ImageDefault` ON (`Image`.`image_default_id` = `ImageDefault`.`id`) WHERE `Product`.`category_id` = 13 AND `Image`.`image` != '' ORDER BY rand() ASC LIMIT 1000
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 `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
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` = 4 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
55SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 4 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` < 8 AND `Category`.`lft` > 7 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` = 9 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
58SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 9 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` < 18 AND `Category`.`lft` > 17 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` = 2 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
61SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 2 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` < 4 AND `Category`.`lft` > 3 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` = 6 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
64SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 6 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` < 12 AND `Category`.`lft` > 11 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` = 15 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
67SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 15 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` < 30 AND `Category`.`lft` > 29 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` = 12 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
70SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 12 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` < 24 AND `Category`.`lft` > 23 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` = 14 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
73SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 14 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` < 28 AND `Category`.`lft` > 27 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` = 7 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
76SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 7 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` < 14 AND `Category`.`lft` > 13 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` = 5 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
79SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 5 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` < 10 AND `Category`.`lft` > 9 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` = 16 AND `Auction`.`start_time` < '2010-07-31 18:45:40' AND `Auction`.`end_time` > '2010-07-31 18:45:40' 111
82SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 16 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` < 32 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 000
84SELECT 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:45:41' AND `Auction`.`end_time` > '2010-07-31 18:45:41' 111
85SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 8 LIMIT 1110
86SELECT `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
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 `Product`.`category_id` = 10 AND `Auction`.`start_time` < '2010-07-31 18:45:41' AND `Auction`.`end_time` > '2010-07-31 18:45:41' 111
88SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 10 LIMIT 1110
89SELECT `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
90SELECT 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:45:41' AND `Auction`.`end_time` > '2010-07-31 18:45:41' 111
91SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 11 LIMIT 1110
92SELECT `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
93SELECT 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:45:41' AND `Auction`.`end_time` > '2010-07-31 18:45:41' 111
94SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 3 LIMIT 1110
95SELECT `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
96SELECT 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:45:41' AND `Auction`.`end_time` > '2010-07-31 18:45:41' 111
97SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 13 LIMIT 1110
98SELECT `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
99SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
100SELECT 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:45:41' AND end_time > '2010-07-31 18:45:41' 111
101SELECT 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:45:41' 111
102SELECT 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
103SELECT 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:45:41' AND end_time > '2010-07-31 18:45:41' 111
104DESCRIBE `pages`13132
105DESCRIBE `departments`331
106SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
107SELECT `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
108SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
109SELECT `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