|
|
 |
|
|
|
SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage,
oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate,
oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType,
oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName,
oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v
FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='US Bank' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o
WHERE o.CategoryName='US Bank') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE
c.CategoryName='US Bank' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='US Bank') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE
r.CategoryName='US Bank' and r.old_offer=0 and OfferStatus=1 order by r.RankId,randcol
* See the online application for details about terms and conditions for these offers. Every reasonable effort has been made to maintain accurate information. However all credit card information is presented without warranty. After you click on the offer you desire you will be directed to the credit card issuer's web site where you can review the terms and conditions for your selected offer. |
|
|
