SELECT rentals.*, rentals_brands.brand as brandname FROM `rentals` LEFT JOIN rentals_brands ON rentals_brands.id = rentals.brand WHERE rentals.site = '415' AND `visible` = '1' AND  ( `topics` LIKE '%T232T%' )  ORDER BY `sort`, id desc LIMIT 0,15