SELECT promoID FROM promo m INNER JOIN partner p ON p.promoIDlook=m.promoID WHERE p.partnerID=??promoCode= AND p.referrerCode LIKE 'GMIG' LIMIT 0,1