SELECT products.*, product_brands.brand as brandname FROM `products` LEFT JOIN product_brands ON product_brands.id = products.brand WHERE products.site = '418' AND  ( `hidden` = '0' )  ORDER BY `sort` ASC, `id` DESC, `code` LIMIT 1215,15