Used Seat Ibiza Cars

select SQL_CALC_FOUND_ROWS used_vehicles.carID_int as id_int,manufacturer,model as range,engine_size,derivative,transmission,additional_details,no_doors,fuel_type,body,deal_price as price,used_vehicles.carID,mileage,colour,image_url,reg_year,reg_letter,users.type,used_vehicles.userID,advertType,dealerLogo.imageSmall,dealerLogo.tagLine1,dealerLogo.tagLine2,dealerLogo.tagLine3,dealerLogo.tagLine4,features,users.town,users.company,used_vehicles_user_payment.payment_method,users.telephone,product_link FROM used_vehicles JOIN users using (userID_int) LEFT JOIN used_vehicles_user_payment on used_vehicles.userID_int=used_vehicles_user_payment.userID_int LEFT JOIN dealerLogo on used_vehicles.userID_int=dealerLogo.userID_int WHERE manufacturer='Seat' AND model='ibiza' AND (advertType='Premium') AND generic_colour='red' ORDER BY advertType='Premium' desc, manufacturer, model, price ASC LIMIT 0,10