SELECT a.* FROM #__hikashop_category AS a WHERE a.category_left > 590 AND a.category_right < 883 AND (a.category_type = 'product' OR a.category_type = 'vendor') AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%') ORDER BY a.category_ordering ASC 

SELECT a.* FROM #__hikashop_category AS a WHERE a.category_left > 2 AND a.category_right < 129 AND (a.category_type = 'product' OR a.category_type = 'vendor') AND (a.show_in_horizontal_menu <> 0) AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%') ORDER BY a.category_ordering ASC