Ability Jobs Plus: Browse by category Retail

Home

Query SELECT `listings`.`sid` as `object_sid`, if( COUNT( `complex_enum` ) >0, COUNT( * ) -  COUNT( `complex_enum` ) +1, COUNT( *  ) ) `count` FROM `listings` JOIN `listings_properties` ON `listings`.`sid` = `listings_properties`.`object_sid`   WHERE 1 AND `listings`.`active` = '1' AND `listings`.`listing_type_sid` = '6' AND `listings`.`status` = 'approved' AND  (
			(`listings` . `access_type` = 'everyone') OR 
			(`listings` . `access_type` = 'only' AND FIND_IN_SET('', `listings` . `access_list`) ) OR 
			(`listings` . `access_type` = 'except' AND (FIND_IN_SET('', `listings` . `access_list`) = 0 OR FIND_IN_SET('', `listings` . `access_list`) IS NULL) )
			) AND (0 OR(1 AND (`id` = 'JobCategory' AND ( FIND_IN_SET('Retail', `value`) )) ) ) GROUP BY `listings_properties`.`object_sid` HAVING `count` = 1  ORDER BY priority desc, CompanyName ASC : 
Unknown column 'CompanyName' in 'order clause'

Browse by category / Retail

There are no listings with requested parameters in the system.

Query insert into session (`session_id`, `data`, `time`, `user_sid`) values ('opsv2clbu0r1d15u7bgd6k5v12', 'lang|s:2:\"en\";CURRENT_THEME|s:15:\"IntelligentView\";ListingSearcher1532408522.3805|a:7:{s:15:\"criteria_values\";a:4:{s:11:\"JobCategory\";a:1:{s:10:\"multi_like\";a:1:{i:0;s:6:\"Retail\";}}s:6:\"active\";a:1:{s:5:\"equal\";s:1:\"1\";}s:16:\"listing_type_sid\";a:1:{s:5:\"equal\";s:1:\"6\";}s:6:\"status\";a:1:{s:5:\"equal\";s:8:\"approved\";}}s:10:\"order_info\";a:2:{s:13:\"sorting_field\";s:11:\"CompanyName\";s:13:\"sorting_order\";s:3:\"ASC\";}s:4:\"page\";s:1:\"1\";s:17:\"listings_per_page\";i:10;s:22:\"show_brief_or_detailed\";s:8:\"detailed\";s:3:\"uri\";s:27:\"/browse-by-category/Retail/\";s:10:\"found_sids\";s:12:\"eJwDAAAAAAE=\";}', '1734025495', 0) : Table './rfhillii_20/session' is marked as crashed and last (automatic?) repair failed