About Us | Contact

Contact Us

Contact us using the contact form below:

 
Affiliate Program
(default) 91 queries took 58 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `settings`441
2DESCRIBE `currencies`331
3DESCRIBE `languages`441
4DESCRIBE `translations`991
5DESCRIBE `products`24242
6DESCRIBE `categories`10102
7DESCRIBE `limits`552
8DESCRIBE `auctions`27272
9DESCRIBE `statuses`331
10DESCRIBE `users`21212
11DESCRIBE `genders`221
12DESCRIBE `sources`441
13DESCRIBE `points`551
14DESCRIBE `addresses`13132
15DESCRIBE `user_address_types`221
16DESCRIBE `countries`551
17DESCRIBE `bids`882
18DESCRIBE `bidbutlers`881
19DESCRIBE `accounts`992
20DESCRIBE `affiliates`881
21DESCRIBE `affiliate_codes`441
22DESCRIBE `referrals`661
23DESCRIBE `credits`771
24DESCRIBE `watchlists`551
25DESCRIBE `reminders`331
26DESCRIBE `messages`551
27DESCRIBE `auction_emails`221
28DESCRIBE `autobids`441
29DESCRIBE `smartbids`441
30DESCRIBE `images`771
31DESCRIBE `image_defaults`331
32DESCRIBE `setting_increments`771
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 `Department`.`id`, `Department`.`name` FROM `departments` AS `Department` WHERE 1 = 1 ORDER BY `name` asc 000
37SELECT `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
38SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
39SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 4 LIMIT 1110
40SELECT `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
41SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
42SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 9 LIMIT 1110
43SELECT `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
44SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
45SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 2 LIMIT 1110
46SELECT `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
47SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
48SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 6 LIMIT 1110
49SELECT `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
50SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
51SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 15 LIMIT 1110
52SELECT `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
53SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
54SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 12 LIMIT 1110
55SELECT `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
56SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
57SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 14 LIMIT 1110
58SELECT `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
59SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
60SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 7 LIMIT 1110
61SELECT `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
62SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
63SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 5 LIMIT 1110
64SELECT `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
65SELECT 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:51:38' AND `Auction`.`end_time` > '2010-07-31 18:51:38' 111
66SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 16 LIMIT 1110
67SELECT `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
68SELECT 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:51:39' AND `Auction`.`end_time` > '2010-07-31 18:51:39' 111
69SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 8 LIMIT 1110
70SELECT `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
71SELECT 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:51:39' AND `Auction`.`end_time` > '2010-07-31 18:51:39' 111
72SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 10 LIMIT 1110
73SELECT `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
74SELECT 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:51:39' AND `Auction`.`end_time` > '2010-07-31 18:51:39' 111
75SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 11 LIMIT 1110
76SELECT `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
77SELECT 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:51:39' AND `Auction`.`end_time` > '2010-07-31 18:51:39' 111
78SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 3 LIMIT 1110
79SELECT `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
80SELECT 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:51:39' AND `Auction`.`end_time` > '2010-07-31 18:51:39' 111
81SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 13 LIMIT 1110
82SELECT `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
83SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
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 start_time < '2010-07-31 18:51:39' AND end_time > '2010-07-31 18:51:39' 111
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:51:39' 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 `closed` = 1 110
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`.`free` = 1 AND start_time < '2010-07-31 18:51:39' AND end_time > '2010-07-31 18:51:39' 111
88SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
89SELECT `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
90SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
91SELECT `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