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.
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = '8a8706eb289fc0e77379446dfb1ae049' LIMIT 1
0
0
0
2
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-09-08' AND `Listing`.`under_contract` = 0 AND `Listing`.`deleted` = 0 ORDER BY `Category`.`order` ASC
0
0
3
3
SELECT `Category`.`id`, `Category`.`category`, `Category`.`order` FROM `categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`order` ASC LIMIT 4307, 24
