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 = 66
ORDER BY t1.ordem ASC, t1.id
LIMIT 0, 9