SELECT `CatItems`.`__id`, `CatItems`.`Name`, `CatItems`.`Code`, `CatItems`.`Code2`, `CatItems`.`Code3`, `CatItems`.`Price`, `CatItems`.`OldPrice`, `CatItems`.`SmallDesc`, `CatItems`.`Category`, `CatItems`.`smallImage`, `CatItems`.`bigImage`, `CatItems`.`Units`, `CatItems`.`isNew`, `CatItems`.`isSale`, `CatItems`.`isAction`, `CatItems`.`isHit`, `CatItems`.`isAvailable`, `CatItems`.`Availability`, `CatItems`.`Parameters`, `CatItems`.`Active` , `Brands`.`Image` as BrandImg, `Brands`.`Name` as BrandName FROM `CatItems` LEFT JOIN `Brands` ON `Brands`.`__id` = `CatItems`.`Brand` WHERE `CatItems`.`Category` = 4480 AND `CatItems`.`__id`<>'262217' AND `CatItems`.`Active` = 1 ORDER BY `CatItems`.20