Categories

Used by Buyers to communicate what they want to buy (An RFX LISTING), used by Suppliers to search listings and make offers, and used by Buyers and/or Suppliers to sort and manage transactions and history.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z « Previous Next »

Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `listings`	331	331	6
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	0
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` = '5f164ba9fc9ce45cf8059d21a2d63868' 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`.`order` ASC	0	0	2
18	SELECT `Category`.`id`, `Category`.`category`, `Category`.`order` FROM `categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`order` ASC LIMIT 21, 24	24	24	1