SELECT `categories`.*, `categories_sections_descriptions`.`is_new`, `categories_sections_descriptions`.`show_unit_price` FROM `categories` LEFT JOIN `activities` ON activities.categories_id = categories.id AND activities.sections_id = 10 INNER JOIN `categories_sections_descriptions` ON categories_sections_descriptions.categories_id = categories.id WHERE (categories_sections_descriptions.sections_id = 10) AND (categories_sections_descriptions.is_deleted = 0) AND (categories_sections_descriptions.status_id = 1) AND (categories.is_deleted = 0) AND (categories.status_id = 1) GROUP BY `categories`.`id` ORDER BY `categories`.`title` ASC