Categories
Street address
City
State Zip code
Country
Home Products Send Enquiry
Send Enquiry for
Notice (8): Undefined variable: products [APP/View/Search/contact_supplier.ctp, line 44]
0 Products
Post buy requirement toget multiple quotes
(default) 2 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`short_name`, `Parent`.`name`, `Parent`.`id` FROM `deallogic_new`.`tbl_categories` AS `Category` LEFT JOIN `deallogic_new`.`tbl_categories` AS `Parent` ON (`Category`.`parent_id` = `Parent`.`id`) WHERE `Category`.`status` = 1 AND `Category`.`has_business` = 1 ORDER BY `Parent`.`name` ASC, `Category`.`name` ASC5475471
2SELECT COUNT(*) AS `count` FROM `deallogic_new`.`tbl_deals` AS `Deal` LEFT JOIN `deallogic_new`.`tbl_users` AS `User` ON (`Deal`.`user_id` = `User`.`id`) LEFT JOIN `deallogic_new`.`tbl_categories` AS `Category` ON (`Deal`.`category_id` = `Category`.`id`) LEFT JOIN `deallogic_new`.`tbl_categories` AS `SubCategory` ON (`Deal`.`subcategory_id` = `SubCategory`.`id`) LEFT JOIN `deallogic_new`.`tbl_currencies` AS `Currency` ON (`Deal`.`currency_id` = `Currency`.`id`) WHERE `Deal`.`status` = 1 AND `User`.`status` = 1 AND `Category`.`status` = 1 AND `Deal`.`validate_till` >= '2019-05-26'110