Used Vauxhall Corsa 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='Vauxhall' AND model='corsa' AND ((manufacturer like '%ls%' or model like '%ls%' or derivative like '%ls%' or body like '%ls%' or fuel_type like '%ls%' or transmission like '%ls%' or additional_details like '%ls%' or colour like '%ls%' or generic_colour like '%ls%' or features like '%ls%' or reg_letter like '%ls%' or engine_size like '%ls%')) ORDER BY advertType='Premium' desc, manufacturer, model, price ASC LIMIT 0,10