MySQL said: ': '
SELECT t1.ID,t1.Name,t1.Color,t1.Icon FROM t_offer_labels t1, t_offer_labels_totours t2 WHERE t2.TourID='9' AND t1.ID = t2.OfferLabelID ORDER BY Name