SELECT SQL_CALC_FOUND_ROWS self.*
FROM equipment self
JOIN view_vehicles vh ON self.VehicleID = vh.ID
WHERE vh.VUID = '2828763' AND self.ID IS NOT NULL AND vh.active <> '0' AND self.is_active <> '0' ORDER BY self.Category