SELECT t1.id, t1.preco, t1.designacao, t1.descricao, t1.tipo, t2.marca FROM www_veiculos AS t1 LEFT JOIN www_marcas AS t2 ON t1.marca = t2.id WHERE t1.tipo = 1 AND t1.marca = 28 ORDER BY t1.ordem ASC, t1.id LIMIT 0, 9