Browse Listings
No listings found for this search
Oooops, that category is not among the 4000 categories that are available. Please select the most relevant category from this list
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `listings` | 331 | 331 | 2 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 1 | |
| 3 | SHOW FULL COLUMNS FROM `users` | 62 | 62 | 1 | |
| 4 | SHOW FULL COLUMNS FROM `groups` | 2 | 2 | 1 | |
| 5 | SHOW FULL COLUMNS FROM `corporations` | 4 | 4 | 1 | |
| 6 | SHOW FULL COLUMNS FROM `accounts` | 17 | 17 | 1 | |
| 7 | SHOW FULL COLUMNS FROM `business_designations` | 18 | 18 | 1 | |
| 8 | SHOW FULL COLUMNS FROM `offers` | 79 | 79 | 1 | |
| 9 | SHOW FULL COLUMNS FROM `contracts` | 164 | 164 | 1 | |
| 10 | SHOW FULL COLUMNS FROM `pp_actions` | 37 | 37 | 1 | |
| 11 | SHOW FULL COLUMNS FROM `uploads` | 10 | 10 | 1 | |
| 12 | SHOW FULL COLUMNS FROM `categories` | 3 | 3 | 1 | |
| 13 | SHOW FULL COLUMNS FROM `multiple_listings` | 31 | 31 | 1 | |
| 14 | SHOW FULL COLUMNS FROM `ndas` | 12 | 12 | 1 | |
| 15 | SHOW FULL COLUMNS FROM `cake_sessions` | 3 | 3 | 1 | |
| 16 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = '8d9164e4777f553c962bdae4317e4a2e' LIMIT 1 | 0 | 0 | 0 | |
| 17 | SELECT DISTINCT `Category`.`id`, `Category`.`category`, `Listing`.`id` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`expire_date_listing` >= '2026-07-10' AND `Listing`.`under_contract` = 0 AND `Listing`.`deleted` = 0 ORDER BY `Category`.`category` ASC | 0 | 0 | 4 | |
| 18 | SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`under_contract` = 0 AND `Listing`.`active` = 1 AND `Listing`.`send_to` = 0 AND `Listing`.`expire_date_listing` >= '2026-07-10' AND `Listing`.`deleted` = 0 | 1 | 1 | 3 | |
| 19 | SELECT `Listing`.`id`, `Listing`.`created`, `Listing`.`desc`, `Listing`.`user_id`, `Listing`.`add_picture1`, `Listing`.`title`, `Listing`.`category_id`, `Listing`.`expire_date_listing`, `Listing`.`more_than_one`, `Listing`.`shipping_country`, `Listing`.`shipping_state`, `Listing`.`state_other` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`under_contract` = 0 AND `Listing`.`active` = 1 AND `Listing`.`send_to` = 0 AND `Listing`.`expire_date_listing` >= '2026-07-10' AND `Listing`.`deleted` = 0 ORDER BY `Listing`.`id` desc LIMIT 100 | 0 | 0 | 5 |